Comments by Putchicks

Putchicks 5-Jun-15 9:18am View

Thanks CHill60. I was out of the office, sorry for the late reply. I will try to remove TRY-CATCH.

Putchicks 29-May-15 15:04pm View

Thanks Richard Deeming for the suggestion, though this is not my issue right now and not a priority but will consider your suggestions. Do you happen to have a sample for us of parameterized query.

Putchicks 29-May-15 14:51pm View

Thank you very much for the prompt response RyanDev.
I cannot a run a trace (profiler) because I am not a member of sysadmin.

Putchicks 9-Apr-15 10:30am View

Thanks RyanDev. I too also think that this is not possible but is there any way that I can do similar to this. Any idea? Thanks.

Putchicks 8-Apr-15 16:48pm View

Sorry RyanDev I somehow deleted the @PK in below line, appreciate your help on this

EXECUTE dbo.sp_executesql @S, @P, @PK, @pOldPK OUTPUT

Putchicks 8-Apr-15 16:27pm View

Thanks RyanDev. Please see below code:
DECLARE @OldPK AS VARCHAR(50)
DECLARE @PK AS VARCHAR(50)
DECLARE @S AS NVARCHAR(MAX)
DECLARE @P AS NVARCHAR(MAX)
DECLARE @pPK AS VARCHAR(50)

SET @PK = 'ModeName'
SET @S = N'SELECT TOP 1 @pOldPK = ' + QUOTENAME(@pPK) + ' FROM Modes '
SET @P = N'@pOldPK VARCHAR(50) OUTPUT'
EXECUTE dbo.sp_executesql @S
, @P
, @PK
, @pOldPK = @OldPK OUTPUT
SELECT @OldPK

this generates a NULL value it supposed to give a 'xxx'

Putchicks 8-Apr-15 15:52pm View

Thank RyanDev. I rectified the error in codes but it doesn't give me what I want to have a dynamic column (injected by user). please see below changes:

DECLARE @OldPK AS VARCHAR(50)
DECLARE @S AS NVARCHAR(MAX)
DECLARE @P AS NVARCHAR(MAX)
DECLARE @pOldPK AS VARCHAR(50)

SET @S = N'SELECT @pOldPK = m.ModeName FROM Modes m'
SET @P = N'@pOldPK VARCHAR(50) OUTPUT'
EXECUTE dbo.sp_executesql @S, @P, @pOldPK OUTPUT
SELECT @pOldPK

and it gives me the value sample "XXXX" when executed...

Putchicks 8-Apr-15 14:46pm View

I tried to run the in SSMS - Thanks Sergey

Comments by Putchicks (Top 8 by date)