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
What are the advantages of policy management?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Why do we use trigger?
Define the one-to-one relationship while designing tables.
Define inner join? Explain with an example?
What is an indexing technique?
How to skip remaining statements in a loop block using continue statements?
What is a virtual table in sql?
Can we store videos inside the sql server table?
What are the different types of upgrades that can be performed in sql server?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What do you know about normalization and de- normalization?
Where are stored procedures in sql server?
How to list all objects in a given schema?
How to search for a string in all stored procedure in sql server?