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

Database

 
AnswerRe: If it is a bug? Pin
Terry O'Nolley25-Oct-03 15:07
Terry O'Nolley25-Oct-03 15:07 
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 
Hi I am using VB.net/ASP.NET and SQL Server 2000 for a web application.

I have AccountNo as identity column. I use some dummy records for testing. But, every time I do a Delete from table and Insert Dummy rows, the identity Number of AccountNo starts for (Max(AccountNo)+1) of previously inserted rows. This throws of the AccountNo associated with my Dummy rows and actual table table rows.

How can I reset the IDENTITY to start from 1 without re-creating the table?

Please advice. Thanks in advance.

Pankaj

Follow your goals, Means will follow you ---Gandhi---
AnswerRe: IDENTITY COLUMN QUESTION??? Pin
andyharman20-Oct-03 11:53
professionalandyharman20-Oct-03 11:53 
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 

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.