Interested to Buy Any Domain ? << Click Here >> for more details...
how to give input dynamically to a insert statement in
sqlserver
- 3 Answers
- 8341 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramadass
Write a store procedure for insert and pass the input value
as parameters to proc.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / senthil kumar.m
Declare @sql_tmp varchar(100)
set @sql_tmp="insert into table1(col1,col2..)
select 'val1','val2','') "
sp_executesql @sql_tmp
| Is This Answer Correct ? | 0 Yes | 10 No |
How to perform backup for certificates in sql server? : sql server security
what is a mixed extent? : Sql server administration
ehat is the default port no of sql 2000?
What are null values in ms sql server?
what is the main difference between after trigger and instead trigger.
Explain the difference between delete,drop and truncate in SQL Server?
How to create dbo table in sql server?
What is stored procedures?
can you any body tell me which service pack is installed in the sql server?
What is filestream?
What is an index in sql?
how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
