SP is good for security purpose, as it grant privileges to the use.......

Difference between writing SQL query and stored procedure ?

Question Posted / ramneet

Answer Posted / ramneet

SP is good for security purpose, as it grant privileges to
the use.........

Is This Answer Correct ?

23 Yes

20 No

Please Help Members By Posting Answers For Below Questions

What are the essential components of sql server service broker?

1020

How to list all objects in a given schema?

1064

What are distributed partitioned views?

1084

How column data types are determined in a view?

967

What do you understand by intent locks?

1018

What is the difference between resultset and resultsetmetadata?

981

Indexes are updated automatically is the full-text index also updated automatically?

1032

How to see existing views in ms sql server?

1050

What is always encrypted?

1006

What is the contrast between sql and pl/sql?

1150

When would you use sql joins?

966

what is difference between NULL and ISNULL in SQL Server 2008?

1021

Define right outer join in sql server joins?

1055

What are the advantages of using stored procedures in sql server?

1014

What is the purpose of the master database?

1135