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 - 2007-02-26 : 10:08:34
|
| Sandesh writes "If i hv 100 record in one system & i want only selected 15 records form old sys to new sys, is there any commands in SQL to copy that data fr 1sys to another sys." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-02-26 : 10:21:06
|
quote:
Originally posted by AskSQLTeam
Sandesh writes "If i hv 100 record in one system & i want only selected 15 records form old sys to new sys, is there any commands in SQL to copy that data fr 1sys to another sys."
Come on Rob, now you're just messing with usBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-26 : 10:31:54
|
| INSERT NewSystemTableSELECT TOP 15 *FROM OldSystemTableORDER BY ....Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
SQL Queries