how to give input dynamically to a insert statement in
sqlserver
- 3 Answers
- 7710 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
Create and insert into temp table in sql server?
How to use old values to define new values in update statements in ms sql server?
Explain transaction server isolation?
What is default constraint in ms sql server?
How to create an identity column?
What is meant by referential integrity?
What is user-defined function?
How would you add a section to a table?
Indexes are updated automatically is the full-text index also updated automatically?
What do you mean by SQL injection attack?
What is an execution plan? When would you use it?
What is trigger and different types of Triggers?
What is local temp table?
How to name query output columns in ms sql server?
How to backup SQL Server Reporting Services ?
