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.

 All Forums
 General SQL Server Forums
 Script Library
 Delete Mutilple Records

Author  Topic 

webfort
Starting Member

9 Posts

Posted - 2007-04-13 : 05:54:57
Hi,

I was wondering if any one could help me. I have two tables from which I need to delete information from. I have an excel spreadsheet which has the reecords in need to delete.

Is there any way I can delete them all in one go instead of going through each delete query manually?

Many thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-13 : 05:57:07
This forum "Script Library" is for posting working script. Please post in appropriate forum.


KH

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-04-13 : 06:11:21
Follow whast was said in addition to referring this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-13 : 06:14:35
quote:
Originally posted by madhivanan

Follow whast was said in addition to referring this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail


11 pages, 210 replies

After reading through that, OP will also be an expert on the subject

KH

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-04-13 : 06:42:07
Sure

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -