Difference between a query and strored procedure?
- 4 Answers
- 9082 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / r.s.chauhan
Sp gets stored at the server side where as Not necessary
for query(It can be from application or Clint(sql oem) etc)
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
what are the 'mysql' command line options? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
how do you control the max size of a heap table? : Sql dba
What is a temporal data type?
What is a table?
what is 'trigger' in sql? : Sql dba
Which is faster truncate or drop?
What is forward declaration in pl sql?
what is a relationship and what are they? : Sql dba
What does fetching a cursor do?
Explian rowid, rownum? What are the psoducolumns we have?
What is cursor and why it is required?
Where do we use pl sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
