Viewing 15 posts - 2,311 through 2,325 (of 5,356 total)
Well, you shouldn't use sp_sqlexec any more as BOL states for SQL Server 2000
>Removed; no longer available. Remove all references to sp_sqlexec.
It can be found when searching for sq_sqlexec
March 3, 2004 at 7:57 am
The procedure and the dynamic statement run in different scopes.
I think you can't use a table variable. *Better* would be a temp or permanent table like this
CREATE PROCEDURE USP_RULE
AS
CREATE table...
March 3, 2004 at 7:28 am
No, we should not be joking anymore.
It's pretty serious to me!
March 3, 2004 at 7:14 am
Please avoid cross postings. They make it hard to follow. We should leave it here
![]()
March 3, 2004 at 6:24 am
sp_sqlexec() ??? ![]()
I think you mean sp_executesql()
March 3, 2004 at 6:23 am
Sorry, this is a real world example from one of my tables.
Replace with your table name and with your PrimaryKey or Unique Identifier.
HTH
March 3, 2004 at 6:18 am
Are you sure it's SQL Server 2000?
Here is a list of SQL Server versions. To be on SQL 2K you should at least see something like 8.00xx
March 3, 2004 at 5:14 am
If you don't mind that it's a german site you can have a look at this here. They also have a sample script. As this is mostly code it...
March 3, 2004 at 4:08 am
Posts containing any feedback like 'Thanks' are quite okay as they show a solution to the problem has been found.
Sorry, for posting this as a separate post, but editing the...
March 3, 2004 at 4:05 am
From this point on, I would only be guessing and I don't want to do this.
Sorry, but I'm sure someone else will jump right in.
March 3, 2004 at 3:57 am
DECLARE @text_var varchar(8000)
SELECT @text_var = MsgNoteText
FROM mails_header
WHERE MsgID =
'0000000052473604077444499F10F4A2A11C085E0700EE482D8B9388E841ADE11B0CF1FA
A1DC0000008750640000EE482D8B9388E841ADE11B0CF1FAA1DC000000A438B30000'
SELECT LEFT(@text_var,20)
...
March 3, 2004 at 3:51 am
xp_regread
xp_regenumkeys
xp_regwrite
xp_regdeletevalue
xp_regdeletekey
I would search for them here or on the net. None of them is documented in BOL for a very good reason.
March 3, 2004 at 3:44 am
Viewing 15 posts - 2,311 through 2,325 (of 5,356 total)