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
What security features are available for stored procedure?
What is difference between equi join and natural join?
Explain what are commit and rollback in sql?
How can you fetch alternate records from a table?
What are xml indexes?
what is a live lock? : Sql server database administration
What is stored in the mssqlsystemresource database? : sql server database administration
What should be the fill factor for indexes created on tables? : sql server database administration
What are the difference between “where” and “having” clause in sql server?
What are the options which must be set to allow the usage of optimistic models?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Which is better statement or preparedstatement?
What is transact-sql language?
What are constraints in microsoft sql server?
List the advantages of using stored procedures?
