how to give input dynamically to a insert statement in
sqlserver
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
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
what stored procedure would you use to view lock information? : Sql server administration
Explain what is the difference between union and union all?
when you create a database how is it stored? : Sql server database administration
What is a synonym for manipulation?
What is bit data type?
Suggest a method of joining two tables.
Explain acid?
What is the difference between commit and rollback?
What is an expression in ms sql server?
What is mssql?
Why would you call update statistics?
What is filestream?
List some advantages and disadvantages of stored procedure?
Mention what are the different types of ssrs reports?