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 )

Explain about SQL server 2005?

979

---

Tell me what do we need queues in sql service broker?

995

---

What is nonclustered index with included columns ?

968

---

Explain the different index configurations a table can have?

947

---

What functions can a view be used to performed?

1060

---

How to specify the collation for a character data type in ms sql server?

1030

---

What is a recursive stored procedure in sql server?

1175

---

Why do you want to join software field as you have done your BE in Electronics?

2145

---

How to locate and take substrings with charindex() and substring() functions?

1016

---

How to encrypt Strored Procedure in SQL SERVER?

1168

---

How to create user defined functions with parameters?

1236

---

What is data block and how to define data block size?

1027

---

What is the osql utility?

975

---

What is service broker? : sql server database administration

996

---

How many databases can we create in a single server?

207

---