Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can you append an identity column to a temporary table?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Explain indexes disadvantages?
What are the grouping functions?
Tell me what are cursors and when they are useful?
Explain the creation and execution of a user-defined function in the sql server?
What is the use of partition by in sql server?
Why union all is faster than union?
What is store procedure?
What is the difference between clustered index and primary key?
How to modify the underlying query of an existing view?
Why should one not prefix user stored procedures with ‘sp_’?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is the sql case statement used for?
What is explicit cursors?
