Sunday, July 23, 2017

Testing a comparison operator in an SQL Query?

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

No comments:

Post a Comment

What is unique to StarSQL ODBC connectivity?

 StarSQL is a database driver designed to facilitate connectivity between client applications and IBM DB2 databases. Specifically, StarSQL a...