am I not allowed to use

am I not allowed to use

Post by Alex » Thu, 20 Sep 2001 03:47:44

DDLs within a DML statement???




am I not allowed to use

Post by Gert-Jan Stri » Thu, 20 Sep 2001 05:23:50

No. DML is for data manipulation, DDL is for data definition (meta-data)
manipulation. That is what the abbreviations actually stand for.

However, you can use the same channel/connection/command to send DDL
and/or DML statements. You can also make batch files that mix DML and
DDL, for example:

CREATE TABLE #t (id int not null)  -- DDL
SELECT * from #t  -- DML

Then again, with Dynamic SQL you can do anything...


> DDLs within a DML statement???

> TIA.

> Alex


1. Microsoft SQL isapi extension - 405 Method Not Allowed - POST queries are not allowed - OpenXML

I have IIS installed on a Win2000 Server and i have another IIS instalation
on my Window XP laptop.

Posting a form (<FORM>) to an XML file works fine on XP but does not work
fine on Win2000.

On Win2000 I have the following error :

ERROR: 405 Method Not Allowed
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: POST queries are not allowed.

Here is the sample that i tried on my 2 distinct IIS Instalation

All this is working perfectly on XP and does not work on 2K.

please note the use of the following code

<form name="Employee"

2. Drop Down List

3. Allow/Not Allow Duplicates?

4. Mysterious error message

5. nulls not allowed to nulls allowed

6. E_GC0134 - the problem is the message

7. transactions: what is allowed / not allowed

8. access

9. SQL Enterprise Manager using SP3 not allowing access

10. keys allowed in child which do not exist in parent table when restoring using pg_restore

11. Using Command object not allowing field editing

12. Select not returning records based on Date I am using

13. I am getting this message when i am tring to export or import anything using