Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: liquidtox
  • Content: Threads
  • Order by date
  1. liquidtox

    Ms Sql Server 2000 Identity Columns Gaps

    With regards to Identity columns in ms sql server 2000, what is the best way to manage the gaps after rows have been deleted? I read somewhere about using : DBCC CHECKIDENT (TableName, RESEED,1) DBCC CHECKIDENT (TableName, RESEED) But i think it only works if the rows are removed from the...
  2. liquidtox

    SQL query help

    Hi, I am having problems making a query that will return the rows for a specified date AND the preceding N number of days (not necessarily just date - N days). I.e. table date column consists of: Date Column ... Aug 5,2002 Aug 7,2002 Aug 8,2002 Aug 10,2002 Aug 12,2002 ... If i want to...

Part and Inventory Search

Back
Top