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
Can truncate be rolled back?
What are the difference between clustered and a non-clustered index?
Explain differences between web edition and business edition?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Why people hate cursor?
What is thr feature of change data capture?
What guidelines should be followed to help minimize deadlocks?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What are the tables in sql?
Explain the usage of floor function in sql server.
Explain what is dbcc?
What is log cache in sql server?
Define constraints and give an example of their use?
How do you trace the traffic hitting a sql server?
What is oltp (online transaction processing)?