Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / raghuram
Stored procedure is a set of T-Sql statements combined to
perform a single task of multiple tasks. It do not run
values, It performs only tasks. It reduces network traffic
and improve the performance. It accepts the input
parameters. It helps to ensure the integrity of the
database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to get the definition of a stored procedure back?
how would you troubleshoot blocking? : Sql server database administration
How can you list all the table constraints in a database?
What is partition index in sql server?
How to use clusters?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are the differences between clustered and non-clustered index?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to include date and time values in sql statements?
What is ms sql server index?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to write character string constants or literals in ms sql server?
Which tcl commands are available on the sql server?
Can you get second highest salary from the table?
What is the use of sign function?
