Interested to Buy Any Domain ? << Click Here >> for more details...
how to give input dynamically to a insert statement in
sqlserver
- 3 Answers
- 8370 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 are the steps to insert a table?
What is the use of builtinadministrators group in sql server? : sql server security
How to find related tables in sql server?
What is query and its types?
What are the dis_advantages of stored procedures, triggers, indexes?
What is difference between Triggers and store procedure?
Explain how to use linked server?
Differentiate between ms sql server reporting services vs crystal reports?
What are the different acid properties?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
How to create a view with data from multiple tables?
how we use window authentication connection with 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)
