Re: MSSQL inserting into a table with a valid result set
| From: | hubo | Date: | Fri, 12 Mar 2004 19:05:10 +0000 |
| Subject: | Re: MSSQL inserting into a table with a valid result set | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23123@lists.php.net to get a copy of this message | ||
You might want to try the SQL
insert into sometable select * from someothertable where something =
somethingelse
"Gerardo Rojas" <grojas@strategicinc.com> schrieb im Newsbeitrag
news:F0EDCD6B96C14741A2F6B0BE6EB7D9CF6D7250@scsprdm.strategicinc.com...
I have a valid result set from running a simple query. Is there a way of
inserting this into an existing table or creating a new table with the
result set? All ideas are welcome!
MSSQL Server 2000
PHP 4.3.4
Windows 2000 pro
IIS 5.0
--
Gerardo S. Rojas
mailto: grojas@strategicinc.com