Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71730 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 is the sql equivaent of the dataset relation object ?
What is user-defined multi-statement table-valued function?
Where views are stored in sql server?
Explain “row_number()” in sql server with an example?
What are the advantages of sql azure?
What is a livelock?
Relational calculus is what type of language?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
what data regions are and what are the different data regions?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is transact-sql ddl trigger?
How do I start and stop sql server?
What is oltp (online transaction processing)?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
