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 is an inner join?

981

---

What is sql server replication? : sql server replication

983

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1005

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1024

---

State the difference between union and union all?

926

---

What is the difference between coalesce() & isnull()?

1132

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2394

---

How to enable/disable indexes?

1066

---

explain different types of joins? : Sql server database administration

982

---

How column data types are determined in a view?

956

---

What is a print index?

882

---

Explain what is the difference between a local and a global temporary table?

995

---

How to join two tables in a single query in ms sql server?

991

---

What are extended events in sql server?

953

---

What is the difference between index seek vs. Index scan?

1023

---