Can you explain what is indexed view? How to create it?
How can we call UDF(User Define Function) using C# code in ASP.net ?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What method is used by the Command classes to execute SQL statements that return single values?
What is the use of toad or sqldbx.?
Define constraints and give an example of their use?
What is nolock?
What is log cache in sql server?
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
how to overcome kernel isssues
Which data type can be used only on OUTPUT parameters of the stored proceduer?
What are acid properties of transaction?