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 is a functions and types in sql server?
how you can deploy an ssrs report?
What number aggregate functions are accessible there in sql?
What are secondary xml indexes?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is the difference between cartesian product and cross join?
What is the ‘fillfactor’?
Is sql server a database?
What is sql server database?
What should be the fill factor for indexes created on tables? : sql server database administration
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is RAID? What are the different types of RAID configurations?
Which is the main third-party tool used in sql server?
