Interested to Buy Any Domain ? << Click Here >> for more details...
how to give input dynamically to a insert statement in
sqlserver
- 3 Answers
- 8486 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 |
What is the contrast between sql and pl/sql?
What is a livelock?
What do you mean by data manipulation language?
Explain what is use of dbcc commands?
What are wait types?
What is the distinction amongst delete and truncate?
Explain the microsoft sql server delete command? : SQL Server Architecture
How much space does sql server 2016 take?
What are the recovery models in sql server 2000?
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
3 Answers CarrizalSoft Technologies, IBM,
What is sub-query in sql server? Explain its properties.
How to select all columns of all rows from a table with a select statement in ms sql server?
-
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)
