Click here to Skip to main content
15,847,427 members
Home / Discussions / Database
   

Database

 
GeneralTrouble Running Sql Script from Code Pin
perlmunger3-Nov-03 12:42
perlmunger3-Nov-03 12:42 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi3-Nov-03 15:54
professionalJeff Varszegi3-Nov-03 15:54 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 4:58
perlmunger4-Nov-03 4:58 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 5:03
professionalJeff Varszegi4-Nov-03 5:03 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 5:54
perlmunger4-Nov-03 5:54 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 6:38
professionalJeff Varszegi4-Nov-03 6:38 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 7:55
perlmunger4-Nov-03 7:55 
GeneralIdentity Seeds Pin
Colin Angus Mackay3-Nov-03 7:56
Colin Angus Mackay3-Nov-03 7: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 6:10
L Thomas3-Nov-03 6:10 
Generalsql tables Pin
ranjjj31-Oct-03 4:14
ranjjj31-Oct-03 4:14 
GeneralRe: sql tables Pin
ranjjj31-Oct-03 4:18
ranjjj31-Oct-03 4:18 
GeneralDublication of rows Pin
Vaibhav Sanghavi30-Oct-03 23:15
Vaibhav Sanghavi30-Oct-03 23:15 
GeneralRe: Dublication of rows Pin
Rahul Walavalkar3-Nov-03 3:54
Rahul Walavalkar3-Nov-03 3:54 
GeneralRe: Dublication of rows Pin
Vaibhav Sanghavi3-Nov-03 4:10
Vaibhav Sanghavi3-Nov-03 4:10 
GeneralSystem.Data.Sqlclient.TdsParser Pin
yyf30-Oct-03 10:27
yyf30-Oct-03 10:27 
GeneralConnectionString.Timeout Pin
yyf30-Oct-03 9:06
yyf30-Oct-03 9:06 
Generalsimple sample of ADO + Access + VC++ Pin
slomoman30-Oct-03 8:12
slomoman30-Oct-03 8:12 
Generaldate Pin
Anonymous30-Oct-03 7:30
Anonymous30-Oct-03 7:30 
GeneralRe: date Pin
andyharman3-Nov-03 12:26
professionalandyharman3-Nov-03 12:26 
GeneralIDbCommand.CommandTimeOut Pin
yyf30-Oct-03 5:21
yyf30-Oct-03 5:21 
GeneralRe: IDbCommand.CommandTimeOut Pin
Mike Dimmick30-Oct-03 5:59
Mike Dimmick30-Oct-03 5:59 
GeneralRe: IDbCommand.CommandTimeOut Pin
yyf30-Oct-03 9:07
yyf30-Oct-03 9:07 
QuestionProblem in connection string??? Pin
d meenakshi29-Oct-03 19:53
d meenakshi29-Oct-03 19:53 
GeneralRows Pin
Anonymous29-Oct-03 10:17
Anonymous29-Oct-03 10:17 
GeneralUpdate and select in same procedure with a dataadapter Pin
MrDanJordan29-Oct-03 6:49
MrDanJordan29-Oct-03 6:49 

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.