Friday, December 26, 2014

using case function with insert

the is inserted in the code, as 50000


INSERT into dbo.SelectQueries (Name,LastName,Email,Salary,Monthduration,Country,Categories) VALUES( 'Ted','Click','tedc@robus.co.uk',50000,2,'United Kingdom', CASE Salary when >= 35000 then [senior Staff] ELSE [Junior Staff] )


No comments:

Post a Comment