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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-27 : 08:11:32
|
| Sammy Burgos writes "How I can insert a new row to a table from the same table, just changing un value fiels?Thanks" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-10-27 : 08:56:41
|
| insert into tselect PK=55555, Col1, Col2, ..., ColNfrom twhere PK=5 |
 |
|
|
|
|
|
Insert From (but using the same table)