Answer Posted / nivedita
Stored procedures are "defined once, used many times."A
stored procedure is written using Transact-SQL (T-SQL). T-
SQL is a subset of ANSI SQL-92 that has extensions to the
Standard. T-SQL includes variables, conditional logic,
loops and flow control.A stored procedure allows you to put
code or business logic on the database server.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between stored procedure and functions?
What is the significance of master, tempdb and model databases?
Can truncate be rolled back?
What is a cube? : sql server analysis services, ssas
Suggest a method of joining two tables.
What stored by the master? : sql server database administration
What are the different type of replication in sql server?
What is sql server replication? : sql server replication
What is sub-query in sql server?
Explain aggregate functions?
How to create a dynamic cursor with the dynamic option?
Explain primary key?
Explain what is the purpose of sql profiler in sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
what are the Prerequisites for Replication?