How many types of schemas are there?
Which are ddl commands?
Why do we use functions?
Do you know what is replace and stuff function in sql server?
What is 1nf 2nf and 3nf?
What are security principals used in sql server 2005?
What is intellisense?
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
what is a deadlock? : Sql server database administration
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What part does database design plays a role in performance of an sql server-based application?
Mention the differences between substr and charindex in sql server.
In what three ways is the return statement used in a stored procedure?