Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to delete multiple records from SQL Server database using a single updategram Expand / Collapse
Author
Message
Posted Tuesday, October 09, 2012 3:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 11, 2012 1:06 AM
Points: 2, Visits: 11
Hi there

My database table is as below with two columns and with no primary key

Employee (EmpNo, IsDummy)
eg.
1,Y
2,Y
3,N
4,N
5,Y

My updategram is as below

<SendRequest xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
<updg:sync>
<before>
<Employee IsDummy="N" />
</before>
</updg:sync>
</SendRequest>

Now I want this updategram to delete all records where IsDummy=N.
Please find me the best way to do it as I have been trying to achieve it for long time.

Thanks
Post #1370269
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse