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 )

What happens when unicode strings concatenate with non-unicode strings?

999

---

How to find table changes in sql server?

1045

---

How each E-R model constructs can be mapped to the relational model?

918

---

Explain the flow of creating a cube? : sql server analysis services, ssas

998

---

What is model database? : SQL Server Architecture

1056

---

What is postgresql server?

937

---

Do you know how to implement service broker?

885

---

Is it possible to have clustered index on separate drive from original table location?

903

---

Explain how to maintain a fill factor in existing indexes?

926

---

What are the general features of sql server management studio? : sql server management studio

1013

---

What are the tools available in market as an alternative to sql server reporting services?

119

---

How do you delete duplicate rows in sql server?

896

---

What is SQL Azure?

105

---

How to verify the port number of the sql server?

1033

---

what are the new features introduced in sql server 2000? : Sql server database administration

870

---