Interested to Buy Any Domain ? << Click Here >> for more details...
how to give input dynamically to a insert statement in
sqlserver
- 3 Answers
- 8599 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 |
Do you know what are different types of replication in sql server?
What is subquery in sql?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is a database in ms sql server?
what r steps to we need to fallow b4 kill the process?
What is a mixed extent?
What is 1nf normalization form?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What are the different types of Indexes available in SQL Server?
sql server architecture ?
What is isnull() operator?
Working with TLogs
-
Oracle (3253) - 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)
