Let us say we want to know if a variable x is greater or less than another variable y. How do we write a query to test it?
One way to do this is as follows:
declare @x int
set @x=5
declare @y int
set @y=10
IF @x < @y
print 1
ELSE
print 0
One way to do this is as follows:
declare @x int
set @x=5
declare @y int
set @y=10
IF @x < @y
print 1
ELSE
print 0
No comments:
Post a Comment