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
8432 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 get a list of columns in a view using the "sp_columns" stored procedure?

1024

What are the steps you must follow to hide sql server instances?

957

What is a matrix in ssrs?

151

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5897

What are the different authentication modes in sql server?

1090

What are data files?

1021

Explain system rowset functions?

973

What is de-normalization and what are some of the examples of it?

955

What are the benefits and tasks of object explorer? : sql server management studio

1154

Explain the architecture of ms sql reporting service?

905

How to create a testing table with test data in ms sql server?

1063

Why use stored procedures in sql server?

990

What is the primary use of the model database?

1065

When to use null data driven subscription?

204

Can you explain powershell included in sql server 2008?

923