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
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.
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Explain about Joins?
Can we take the full database backup in log shipping?
Tell me what is use of except clause? How it differs from not in clause?
How to perform backup for certificates in sql server? : sql server security
Explain how does the report manager work in ssrs?
What is the latest version of microsoft sql server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Can two different columns be merged into single column? Show practically?
What is NOT NULL Constraint in sql server 2012?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How to filter records of table in SQL SERVER?
How to concatenate two strings in SQL Server.
