Answer Posted / sudarshan
Procedure is a collection of simple DML statements used to
perform certain meaningful operation stored in the database
and used whenever and wherever required.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is bit datatype? : Sql server database administration
Explain various On-Delete options in a DB table. Which is the default option?
What are the built in functions in sql server?
What stored procedure would you use to view lock information?
What is the difference between for xml raw and for xml auto?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is relationship? What number of sorts of relationship are there?
Can you pass expressions to stored procedure parameters?
What are a scheduled jobs or what is a scheduled tasks?
Can we call stored procedure in trigger?
What are the types of table?
What is the purpose of a table?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Can you explain full-text query in sql server?
What is extent? Types of extents?