Loading

sqlserver 2008 insertion

satish babu

13y1.2k

Hi,i have a table with 2 columns.I want to insert values into table.For that one column value want to take from some variable and another value from another table.Is it possible to insert data like that?

ex:insert into emps values(@a,'hhh')

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
hi,

yes it is possible

try...
Insert into table1 (val1,val2)
select @someValue, FieldName from table2

replace your value in above code

hope this will help you.
0