Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CRagsdell
Starting Member
2 Posts |
 Posted - 2002-02-13 : 16:52:43
|
| In the SQL documentation, they say: "To create a Delete query Add the table to delete rows from to the Diagram pane. Start a Delete query by right-clicking in the Diagram or SQL pane, choosing Change Type, and then choosing Delete. "When I do so, however, the option for Change Type is NOT available. I have both SQL 7 and 2000, and the option is not available using either version's Enterprise Manager. I have updated both to the latest Service Packs, the latest MDAC, still no "Choose Type" option available?Any ideas?CREdited by - CRagsdell on 02/13/2002 17:06:50 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-13 : 17:13:57
|
| Are you doing this in the DTS Designer? That's the only place I've seen something like this. It was in a Data Driven Query Task (and I've never used it).I would encourage you to dive into BOL and learn the proper syntax for a DELETE statement, rather than trying to use the graphical tool, and then you can put it in a stored procedure, or wherever you need it.------------------------GENERAL-ly speaking... |
 |
|
|
CRagsdell
Starting Member
2 Posts |
Posted - 2002-02-13 : 20:52:27
|
| AjarnMark,I have been working on databases since well... before SQL... so I know how to create a SQL DELETE statement. I was working with a SQL novice and was showing him how to use the GUI to build "views". He asked how to use it to delete a group of records, so I hit F1 and was lead down a fuzzy path.What I was wondering is why the documentation said the "Change Type" selection would be available when building a view, but is was not available when building a view.I have since learned that the documentation fails to tell the user that this feature is only available after opening a table, not when building a view. Another example of poor documentation from Gates & Co.Thanks for the "help"...CR |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-14 : 14:55:14
|
quote:
I have been working on databases since well... before SQL... so I know how to create a SQL DELETE statement.
Sorry about that , I never meant any offense. I didn't see any mention of your experience in the question, and assumed (Bad Mark, Bad Mark!) that because you were using the GUI tools that you were relatively new to SQL.------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
|
|
DELETE query