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 to send a ssrs report from ssis?
what is a live lock? : Sql server database administration
What are the 2 types of classifications of constraints in the sql server?
How to store and query spatial data?
What number sorts of privileges are accessible in sql?
What is read committed?
What is a dataset and what are the different types of datasets?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain isolation levels that sql server supports?
Explain datetimeoffset data type in sal server 2008?
What are the dmvs? : sql server database administration
What is indexed view?
How to define output parameters in stored procedures?
What are character string data types in ms sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?