DDLs within a DML statement???
TIA.
Alex
by Alex » Thu, 20 Sep 2001 03:47:44
TIA.
Alex
by Gert-Jan Stri » Thu, 20 Sep 2001 05:23:50
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
INSERT INTO #t VALUES (1) -- DML
SELECT * from #t -- DML
DROP TABLE #t -- DDL
Then again, with Dynamic SQL you can do anything...
Gert-Jan
> 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
http://msdn.microsoft.com/library/en-us/xmlsql/ac_openxml_1pv0.asp
All this is working perfectly on XP and does not work on 2K.
please note the use of the following code
<form name="Employee"
action="http://localhost/nwind/Template/UpdateEmployee.XML"
method="POST">
3. Allow/Not Allow Duplicates?
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