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 use of sql profiler in sql server 2012?
What types of replication are supported in sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
Explain stored procedure?
What is the server name in sql server?
What are the events recorded in a transaction log?
Define indexes?
How to copy data from one table to another table?
How to drop an existing table with "drop table" statements in ms sql server?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is the process of normalization?
Do you know sql server 2008 introduces automatic auditing?
What are different types of raid configurations? : SQL Server Architecture
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
What is the use of floor function in sql server?