Declare @id int,@name varchar(100),@class varchar(100) set @id=1 set @nam

how to give input dynamically to a insert statement in
sqlserver

Question Posted / ashutosh rai

3 Answers
8465 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / ashutosh rai

Declare @id int,@name varchar(100),@class varchar(100)
set @id=1
set @name='Ashutosh'
set @class='MCA'

insert into student_table(id,name,class)
values(@id,@name,@class)

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to make a column nullable?

1109

Explain the advantages of merge replication?

946

What are basics of policy management?

1094

What is triggers and stored procedures?

935

How to delete exactly duplicate records from a table?

1054

Does sql server use java?

1062

What are date and time data types in ms sql server?

1084

Relational calculus is what type of language?

1025

What are wait types?

1100

Why use triggers?

1004

How to divide query output into multiple groups with the group by clause in ms sql server?

1026

What is the main purpose of having conversation group?

894

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

975

What is index, cluster index and nonclustered index?

990

Should you normalize audio?

932