What is the use of partition by in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
Tell me what do we need queues in sql service broker?
How to link up the text file to a Database table?
Explain what are sparse columns?
What is the difference between createstatement and preparedstatement?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
role of sql sever 2005 in database rather than any other database
What is the process of normalising?
Explain syntax for viewing trigger?
What is ddl and dml commands?
what are default? Is there a column to which a default cant be bound?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration