Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anand.mind
Starting Member
4 Posts |
 Posted - 2008-03-19 : 09:21:28
|
| I have a table with two columns. I have to insert data in one column from another table and in another column a general scalar value. As like the following..insert into <table1>(column1,column2)values(select columnX from <table2>,XYZ)But I couldn't do this because values clause doesn't support select statement. So,please suggest me how can I do this..... |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-19 : 09:23:40
|
| [code]insert into <table1>(column1,column2)select columnX, XYZ from table2>[/code]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
insert into table