Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmh
Starting Member
20 Posts |
 Posted - 2003-01-16 : 11:02:51
|
| I need to remove all records from a SQL database that were created in 2002. I am brand new to SQL and am wondering the best way to do this. If it is a query can someone suggest where I could find the best "How To" for queries since I have never written one. The field is in mmddyy format. Thanks. |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2003-01-16 : 11:04:16
|
| Look up Books On Line under DELETE and DATEPART... |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-16 : 11:07:42
|
Cindy, you should ask your organizations DBA for help with this. If you don't know how to delete data, you shouldn't be doing it?Is there a "How To" guide for surgeons? Jay White{0} |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-16 : 11:25:41
|
quote:
"There is no DBA onsite. I create the db's for use in ASP applications. I have never had to delete information before and there is nobody else here."- from email ...
Well, good luck. Take rihardh's advice and start working through Books Online. You may also want to visit the bookstore on this site and pick up some books.Look up BACKUP in Books Online as well.Jay White{0} |
|
|
|
|
|
|
Omit records according to date