Answer Posted / neethu mohanan

stored procedure is used to write queries,if there is an
error in the query it willnot be saved.In this if there is
any parameters first declare it,and then the query is write.
Each stored procedure could have a name.We can create the
stored procedure for any tables in the database.
create database->create table->stored procedure.
format:

(stored procedure name)
(@parameter1 type(size),@parameter2 type(size))


//(query)
insert into tablename values(@parameter1,@parameter2 )

Do you know data definition language, data control language and data manipulation language?

1085

---

Does partitioning ssd reduce performance?

928

---

How to test subquery results with the exists operator?

1163

---

Do you know query execution plan?

1262

---

What are page splits? : SQL Server Architecture

1037

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1059

---

Do you know sql server 2008 introduces automatic auditing?

1047

---

Is the primary key column of a table an index in ms sql server?

1001

---

Why do we backup Active Directory ?

1098

---

How important do you consider cursors or while loops for a transactional database?

1009

---

What are the different authentication modes in sql server? How can it be changed?

1134

---

What you can do to delete a table without the delete trigger firing?

1011

---

What is executereader?

999

---

Explain about remote stored procedure?

1056

---

Can you import Microsoft Excel data to SSRS?

135

---