Answer Posted / subrahmanyam
Function is collection of T-Sql statements and used as unit
of reuse
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are distributed partitioned views?
What is row_number () and partition by in sql server?
Explain the dirty pages?
What are different types of table joins?
What is sharding?
Can a database be shrunk to 0 bytes, if not, why?
How to specify the collation for a character data type in ms sql server?
What is awe?
What the different topologies in which replication can be configured?
Explain how does the report manager work in ssrs?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is cursors?
How to list all stored procedures in the current database using ms sql server?
What are out-of-range errors with date and time literals?
What is the report builder?