15 May 2009

Video: Microsoft Visual Studio 2008 - How to create DELETE SQL statement visually


The above video shows you how to create a DELETE SQL statement with Microsoft Visual Studio 2008.  SQL statement can be created visually by clicking and dragging, etc. 

After creating it, you can copy the SQL code too.

Essential steps:

  1. To open Server Explorer, click “View” > “Server Explore”
  2. Create new query.
  3. Select table(s).  Add table(s).
  4. Change query to “Delete” type. i.e. “Change Type” > Delete
  5. Key in the Delete criteria.
  6. Execute SQL statement (DELETE).

No comments: