Answer Posted / santhanakumari
SP r nothing but collection of SQL stments and control flow
of language.it execute very fastly than a stand alone sql
statment because its a precompiled statement.SPs r reduce
the network traffic
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can we delete a table in sql server?
Should you normalize audio?
How to get a list of columns in a view using "sys.columns" in ms sql server?
How do I view a trc file?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is acid db?
What is command parameter in ssrs?
What are partitioned views and distributed partitioned views?
Explain what are page splits? : SQL Server Architecture
how to use DTS package in 2000,2005,2008 in sql server
How to disable a login name in ms sql server?
Do you know the different ddl commands in sql?
What is the use of sql profiler in sql server 2012?
Can we do dml on views?