What is the T-SQL equivalent of IIF (immediate if/ternary
operator) function of other programming languages?



What is the T-SQL equivalent of IIF (immediate if/ternary operator) function of other programming l..

Answer / nitin

Case (..) When (condotion) then (statement) else
(statement) end

Is This Answer Correct ?    4 Yes 5 No

Post New Answer

More ASP.NET Interview Questions

What is actually returned from server to the browser when a browser requests an .aspx file and the file is displayed?

0 Answers   MindCracker,


What are type/key pairs in client script registration?

0 Answers  


what does Page.IsValid in asp.net

6 Answers   Infosys, Net Solution,


How do you implement postback with a text box? What is postback and usestate?

1 Answers  


In my code i have 3 tables,i have to insert 3 tables data using single insert query so that i wrote transations in a sp.but what my problem is,in those 3 tables i have to include my empId from another table.when i'm passing values im getting error at this EmpId. how can i solve this error to execute insert query? plesae tell me the solution...

1 Answers  


What is custom tag in Web.Config?

0 Answers   Accenture,


What are the server control tags in asp.net.?

0 Answers   MCN Solutions,


What are the disadvantages of view state?

0 Answers  


Can we set master page as a start page?

0 Answers  


What are the benefits of Razor View?

0 Answers   NA,


How many web config files can be created for an application?

0 Answers  


What is difference between session and application in asp net?

0 Answers  


Categories