I need a query to Delete a SITE_ID entry for a dbo.MERC_SITE in SQL Server 2008
Posted on 2014-04-16
I am needing to run a query to delete an entry from the table dbo.MERC_SITE and am not sure how to go about it.
I know to use this query when I need to change the SITE_ID from one to another when a mistake happens:
set SITE_ID='A5532592'--New Site ID you wish to have.
Where SITE_ID='A5532592'--Old Site ID you are replacing.
But I am not sure how to use a query to delete an entry. Can someone help me with this?