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
8488 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

What will be query used to get the list of triggers in a database?

1005

What do you mean by a dependent functionality in a build?

1154

What are triggers in ms sql server?

1162

What are different backups available in sql server?

1072

What is mscorsvw.exe - process - microsoft .net framework ngen?

955

What is difference between aggregate and analytic function?

938

How to use the inserted and deleted pseudo tables?

961

What are the differences between having and where clause.

966

What is the command dbcc checkdb used for?

1010

How to check table values in sql server?

956

What is the distinction amongst delete and truncate?

1071

When I run the sql server 2000 setup, it just hangs. What do I do?

1082

What are indexes in sql?

1281

What is a matrix in ssrs?

153

What do you understand by the analysis services in sql server?

939