Information générale
Forum:
Microsoft SQL Server
Titre:
Newbie SQL Server question
I am using SQL Server for the first time with C#. I have a webservice that manages a products table in SQL Server. This webservice accepts XML and either adds product or updates product. For reasons I won't go into here, for each update I am needing to delete the product record and all related records in other tables and then readd the udpated item in the product table and related tables.
Long story short, this webservice is going to be deleting a lot of records in SQL Server. Are they still there marked for deletion like in VFP. If so, how do I remove them?
Should I rethink this method of deleting records and re adding for all updates?
Thanks for your input and suggestions.
Paul
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement