Click here to Skip to main content
15,903,856 members
Home / Discussions / Database
   

Database

 
GeneralGroup by Pin
Anonymous20-Oct-03 7:06
Anonymous20-Oct-03 7:06 
GeneralRe: Group by Pin
Chris Meech20-Oct-03 8:00
Chris Meech20-Oct-03 8:00 
GeneralMultiple SOMETHING in DataGrid Pin
Cirrus200019-Oct-03 21:00
Cirrus200019-Oct-03 21:00 
GeneralRe: Multiple SOMETHING in DataGrid Pin
Guillermo Rivero20-Oct-03 3:59
Guillermo Rivero20-Oct-03 3:59 
GeneralRe: Multiple SOMETHING in DataGrid Pin
Cirrus200020-Oct-03 10:19
Cirrus200020-Oct-03 10:19 
GeneralComplex DataBinding, advice required Pin
Anonymous18-Oct-03 7:15
Anonymous18-Oct-03 7:15 
QuestionIDENTITY COLUMN QUESTION??? Pin
mittalpa18-Oct-03 4:45
mittalpa18-Oct-03 4:45 
AnswerRe: IDENTITY COLUMN QUESTION??? Pin
andyharman20-Oct-03 11:53
professionalandyharman20-Oct-03 11:53 
Do a "Truncate Table MyTableName". That will delete all of the records from the table, and resets the seed for the identity column. Note that this will only work if you don't have any tables with foreign keys pointing at your table (you would have to drop the foreign key contraints before doing the truncate).

Hope this helps.
Andy
GeneralRe: IDENTITY COLUMN QUESTION??? Pin
mittalpa21-Oct-03 4:42
mittalpa21-Oct-03 4:42 
GeneralEmbedded Query Pin
Chris Meech17-Oct-03 9:04
Chris Meech17-Oct-03 9:04 
GeneralRe: Solution Pin
Chris Meech20-Oct-03 4:59
Chris Meech20-Oct-03 4:59 
GeneralServer link Pin
Anonymous17-Oct-03 4:55
Anonymous17-Oct-03 4:55 
GeneralRe: Server link Pin
Colin Angus Mackay17-Oct-03 6:21
Colin Angus Mackay17-Oct-03 6:21 
GeneralVB.NET datagrid Pin
Anonymous16-Oct-03 12:30
Anonymous16-Oct-03 12:30 
GeneralRe: VB.NET datagrid Pin
Edbert P16-Oct-03 20:15
Edbert P16-Oct-03 20:15 
GeneralADO+"Update"+RecordsAffected+"VC++" Pin
DaviziN16-Oct-03 5:31
DaviziN16-Oct-03 5:31 
GeneralRe: ADO+"Update"+RecordsAffected+"VC++" Pin
DaviziN16-Oct-03 21:37
DaviziN16-Oct-03 21:37 
GeneralSome SQL problem in displaying data Pin
erbest15-Oct-03 22:20
erbest15-Oct-03 22:20 
GeneralRe: Some SQL problem in displaying data Pin
andyharman20-Oct-03 12:14
professionalandyharman20-Oct-03 12:14 
GeneralALTER TABLE ALTER COLUMN IDENTITY,help me Pin
crodling15-Oct-03 21:52
crodling15-Oct-03 21:52 
GeneralRe: ALTER TABLE ALTER COLUMN IDENTITY,help me Pin
Mike Dimmick16-Oct-03 5:03
Mike Dimmick16-Oct-03 5:03 
GeneralRe: ALTER TABLE ALTER COLUMN IDENTITY,help me Pin
Anonymous19-Oct-03 14:55
Anonymous19-Oct-03 14:55 
GeneralHighlighting a datagrid row based on condition Pin
Anonymous15-Oct-03 14:49
Anonymous15-Oct-03 14:49 
GeneralLoooping through SELECT values in SQL Pin
mittalpa15-Oct-03 10:59
mittalpa15-Oct-03 10:59 
GeneralRe: Loooping through SELECT values in SQL Pin
Mike Dimmick16-Oct-03 5:14
Mike Dimmick16-Oct-03 5:14 

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.