Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76209 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / ramneet
SP is good for security purpose, as it grant privileges to
the use.........
| Is This Answer Correct ? | 23 Yes | 20 No |
Post New Answer View All Answers
What are the new features of sql server 2008 r2 reporting service?
Can binary strings be converted into numeric or float data types?
What do mean by xml datatype?
Can group functions be used in the order by clause in ms sql server?
How to create database with physical files specified in ms sql server?
What are trace flags and mention a few common trace flags used with sql server?
What is SQL Azure Data sync?
Explain about Joins?
Tell me about pre-defined functions of sql?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to use "begin ... End" statement structures in ms sql server?
When would you use a before or after trigger?
What is the process of normalization?
Explain the use of keyword with encryption. Create a store procedure with encryption?
What is difference between index seek vs. Index scan?
