Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

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
where xaoFormID like '%FSIPVSTR09%'  and (xaoControlName like '%chkelecpckupg%' or xaoControlName like '%cmdelecpckupg%')

Open in new window


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.
0
jeremyll
Asked:
jeremyll
2 Solutions
 
celdridgeMadmanCommented:
delete from FormDefinitions where xaoFormID like '%FSIPVSTR09%'  and (xaoControlName like '%chkelecpckupg%' or xaoControlName like '%cmdelecpckupg%')

Just be careful when deleting obviously!
0
 
vdr1620Commented:
Be sure of what you want to delete...I would you to go through these articles before you delete the data from the table..

http://msdn.microsoft.com/en-us/library/ms189835.aspx
http://www.sql-tutorial.net/SQL-DELETE.asp
http://www.sql-tutorial.com/sql-delete-sql-tutorial/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now