CONVERT or CAST expression from binary to integer might cause a problem because of platform dependence
Comparing binary value with Timestamp
column was different between Sybase and SQL server. The below code was working
fine in Sybase but not in SQL server
Where timestamp = substring(CONVERT(varbinary
(16), CONVERT(INT, @row_upd)), 5, 8) where @row_upd was varchar(38
datatype)
To handle this the same code has been
rewritten using Dummy value concatenation
0x00000000+substring (0x00000000 +CONVERT
(varbinary(8), CONVERT(INT, @row_upd')),5,8)
No comments:
Post a Comment