Click here to Skip to main content
15,908,661 members
Home / Discussions / Database
   

Database

 
GeneralAlternative SQL Queries based on Table Data Pin
Jo Fredrickson3-Nov-03 21:58
Jo Fredrickson3-Nov-03 21:58 
GeneralRe: Alternative SQL Queries based on Table Data Pin
andyharman5-Nov-03 11:35
professionalandyharman5-Nov-03 11:35 
GeneralRe: Alternative SQL Queries based on Table Data Pin
Jo Fredrickson5-Nov-03 14:59
Jo Fredrickson5-Nov-03 14:59 
GeneralMSADO 2.5 Pin
Kant3-Nov-03 15:46
Kant3-Nov-03 15:46 
GeneralRe: MSADO 2.5 Pin
Mike Dimmick5-Nov-03 1:51
Mike Dimmick5-Nov-03 1:51 
GeneralRe: MSADO 2.5 Pin
Kant5-Nov-03 5:01
Kant5-Nov-03 5:01 
GeneralFULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 12:53
devvvy3-Nov-03 12:53 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
Jeff Varszegi3-Nov-03 14:28
professionalJeff Varszegi3-Nov-03 14:28 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 14:30
devvvy3-Nov-03 14:30 
GeneralTrouble Running Sql Script from Code Pin
perlmunger3-Nov-03 11:42
perlmunger3-Nov-03 11:42 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi3-Nov-03 14:54
professionalJeff Varszegi3-Nov-03 14:54 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 3:58
perlmunger4-Nov-03 3:58 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 4:03
professionalJeff Varszegi4-Nov-03 4:03 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 4:54
perlmunger4-Nov-03 4:54 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 5:38
professionalJeff Varszegi4-Nov-03 5:38 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 6:55
perlmunger4-Nov-03 6:55 
GeneralIdentity Seeds Pin
Colin Angus Mackay3-Nov-03 6:56
Colin Angus Mackay3-Nov-03 6:56 
Hello,

I am currently building a script to populate a database with an initial set of data. As the database will potentially be brand new (but may not be) when the scripts are run I want to find a way to set the value the next insert will put in an identity column after the initial set of records are in. If the database is brand new I don't want new records overwriting or causing problems with the initial set. If the database was previously populated the values are deleted and the initial set is re-inserted, but in this case I don't want the new records to be placed with IDs too far removed from the IDs used in the initial set.

I am fairly certain it can be done, but after trawling through the docs I can't seem to find what I am looking for - The initial value can be set when the table is created, but I'm doing that after the table is created.

Any ideas?



--Colin Mackay--

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)


GeneralHandling Disconnected Data In ADO.NET Pin
L Thomas3-Nov-03 5:10
L Thomas3-Nov-03 5:10 
Generalsql tables Pin
ranjjj31-Oct-03 3:14
ranjjj31-Oct-03 3:14 
GeneralRe: sql tables Pin
ranjjj31-Oct-03 3:18
ranjjj31-Oct-03 3:18 
GeneralDublication of rows Pin
Vaibhav Sanghavi30-Oct-03 22:15
Vaibhav Sanghavi30-Oct-03 22:15 
GeneralRe: Dublication of rows Pin
Rahul Walavalkar3-Nov-03 2:54
Rahul Walavalkar3-Nov-03 2:54 
GeneralRe: Dublication of rows Pin
Vaibhav Sanghavi3-Nov-03 3:10
Vaibhav Sanghavi3-Nov-03 3:10 
GeneralSystem.Data.Sqlclient.TdsParser Pin
yyf30-Oct-03 9:27
yyf30-Oct-03 9:27 
GeneralConnectionString.Timeout Pin
yyf30-Oct-03 8:06
yyf30-Oct-03 8:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.