נסיון נוסף.. ../images/Emo22.gif
Terms of Agreement: By using this code, you agree to the following terms... 1) You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for langauges that allow it) freely and with no charge. 2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws. 3) You may link to this code from another website, but ONLY if it is not wrapped in a frame. 4) You will abide by any additional copyright restrictions which the author may have placed in the code or code´s description. --************************************** -- -- Name: Perform SELECT INTO for the res -- ult set of a SP.sql -- Description:How to perform SELECT..IN -- TO type of queries for results from a SP -- . This is useful in cases where you do n -- ot know the metadata of the result set & -- do not want to write the CREATE TABLE s -- tatement before doing the INSERT..EXEC. -- This can be used in a easy way to say sa -- ve the data from a SP in a table. -- By: Umachandar -- --This code is copyrighted and has-- limited warranties.Please see http:// -- www.Planet-Source-Code.com/xq/ASP/txtCod -- eId.120/lngWId.5/qx/vb/scripts/ShowCode. -- htm--for details.--************************************** -- -- To use OPENQUERY on local server, do: -- EXEC sp_serveroption [VALHALLA-MDD06H] , ´data access´, ´true´ SELECT * INTO #W FROM OPENQUERY([VALHALLA-MDD06H], ´exec sp_who´) SELECT * FROM #W
