Write a store procedure for insert and pass the input value as parameters

how to give input dynamically to a insert statement in
sqlserver

Question Posted / ramadass

Answer Posted / ramadass

Write a store procedure for insert and pass the input value
as parameters to proc.

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is parameterized reports in ssrs ?

143

How to download and install microsoft sql server management studio express?

989

Explain the collation?

1058

What is the optimization being performed in oracle and SQL Server?

1001

Explain left outer join and right outer join?

984

What is sparse columns of sql server 2008?

1000

Can I use sql azure as a backup with log shipping or database mirroring?

156

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1168

Can we use trigger new in before insert?

871

Difference between report and query parameter. Why do we need different type of parameter?

910

Explain optimistic and pessimistic concurrency?

943

What is indexed view?

941

What is the difference between insensitive and scroll cursor?

1081

What action plan is preferred if sql server is not responding?

1041

Explain primary key?

906