jeremyll
asked on
remove record from SQL database
The table FormDefinitions have the following:
(<xaoFormID, char(75),>
,<xaoControlName, char(70),>
,<xaoClassID, char(35),>
,<xaoType, numeric(1,0),>
,<xaoProperties, text,>
,<xaoCode, text,>)
I would like to delete the following records
I've been using SQL Server for about 5 months and never had to delete any records.
So, what is the the best way to do this via SQL Statement?
THANKS.
(<xaoFormID, char(75),>
,<xaoControlName, char(70),>
,<xaoClassID, char(35),>
,<xaoType, numeric(1,0),>
,<xaoProperties, text,>
,<xaoCode, text,>)
I would like to delete the following records
where xaoFormID like '%FSIPVSTR09%' and (xaoControlName like '%chkelecpckupg%' or xaoControlName like '%cmdelecpckupg%')
I've been using SQL Server for about 5 months and never had to delete any records.
So, what is the the best way to do this via SQL Statement?
THANKS.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.