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
When to use Inner join & when to use subquery?
What is the difference between primary key and unique constraints?
What is partition in sql server?
If we delete pack Spec what will be the status of pack Body ?
What is user defined stored procedures?
What is cdc in sql server?
How to insert new line characters into strings?
What are null values in ms sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
What is the primary use of the model database?
What is trigger and different types of Triggers?
What are the new features in sql server 2016?
What is tabulation?
What is the difference between drop table and truncate table?
What happens if null values are involved in arithmetic operations?
