Guest User

Untitled

a guest
May 25th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. create procedure proc1 @inputTS rowversion
  2.  
  3. create procedure proc2 @inputTS binary(8)
  4.  
  5. declare @testRV rowversion = 0x0000000070000000
  6.  
  7. declare @testBin binary(8) = @testRV
  8.  
  9. select * from MyTable where tStamp > @testRV -- First Query
  10.  
  11. select * from MyTable where tStamp > @testBin -- Second Query
Add Comment
Please, Sign In to add comment