Viewing 15 posts - 16 through 30 (of 154 total)
The cursor will hold the record set in tempdb...
if you are looping on the table using a identity or some such column - this should reduce the overhead of storing...
November 19, 2003 at 12:03 am
try this
SELECT *
INTO #WrkTable
FROM OPENROWSET('SQLOLEDB','server';'user';'pass','SET FMTONLY OFF EXEC master..sp_sproc_columns')
November 18, 2003 at 11:55 pm
and yes,
The procedural code within sp's is interpreted , the query plan only contains the execution tree for the SQLs (SELECT ,INSERT etc)
November 12, 2003 at 12:04 am
Yes procedures need to be compiled prior to execution .. but such a compiled plan (query plan) will stay in the procedure cache and will be reused or aged out...
November 11, 2003 at 11:39 pm
excellent solution , never thought of that..
November 6, 2003 at 4:17 am
Sorry ,
yes that is correct , you should probably use "SET FMTONLY OFF EXEC master..sp_who" , this would avoid the temp table problem
November 6, 2003 at 4:14 am
you could use a select into ...
SELECT *
INTO #WrkTable
FROM OPENROWSET('SQLOLEDB','server';'user';'pass','master..sp_who')
This would fail with sp's that return more than 1 result set as output
November 6, 2003 at 3:54 am
I do not know any native T-SQL method to do this .. this information would be available from the client though..
if you are restricted to a SQL Environment - a...
November 6, 2003 at 3:43 am
Aldon , Simon - thanks for your suggestions .. I Guess the client will have to upgrade their support level, The vendor keeps passing the buck to MS...The MSDN website...
October 23, 2003 at 12:01 am
the two scripts below should give you what you want, the first one uses the SQL dmo object - and the other isql
EXEC master..xp_cmdshell 'isql -L;'
DECLARE @AppObj int
DECLARE @NmList int
DECLARE...
October 18, 2003 at 3:30 am
had a similar problem with temp tables using openquery .Don't know if this will help , but the metadata retrieval phase in the openquery function errors if the sp has...
October 18, 2003 at 3:15 am
Also the select distinct is not required - union would return distinct rows by itself
June 19, 2003 at 1:30 am
John -
i'm used to using derived tables in my selects - bad habit i've picked up thanks for reminding me
June 16, 2003 at 1:36 am
is this what you are looking for
SELECT number0 , number1
FROM
(
SELECT number AS number0
FROM indecontb
WHERE index LIKE @idx AND
month LIKE @month0 AND
...
June 14, 2003 at 6:27 am
Viewing 15 posts - 16 through 30 (of 154 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy