quote:

---

Originally posted by visakh16

you need to declare the variables before using inside sp_executesql

see

http://msdn.microsoft.com/en-us/library/ms175170(v=sql.105).aspx

---

DECLARE @IntVariable INT;
DECLARE @SQLString NVARCHAR(500);
DECLARE @ParmDefinition NVARCHAR(500);

/* Build the SQL string one time. */
SET @SQLString =
     N'SELECT * FROM AdventureWorks2008R2.Sales.Store WHERE SalesPersonID = @SalesID';
/* Specify the parameter format one time. */
SET @ParmDefinition = N'@SalesID int';

/* Execute the string with the first parameter value. */
SET @IntVariable = 275;
EXECUTE sp_executesql @SQLString, @ParmDefinition,
                      @SalesID = @IntVariable;
/* Execute the same string with the second parameter value. */
SET @IntVariable = 276;
EXECUTE sp_executesql @SQLString, @ParmDefinition,
                      @SalesID = @IntVariable;

Here @SalesID is used in WHERE clause...
While executing your prepared SQLString, you have to pass parameters definition as well as input values

quote:

---

Originally posted by dave1816

quote:

---

Originally posted by visakh16

you need to declare the variables before using inside sp_executesql

see

http://msdn.microsoft.com/en-us/library/ms175170(v=sql.105).aspx

---

Hi visakh16,

I have already done this at the top of my code (I havn't added it to this forum) My question really is if im using a select statement how do input a varibale for say the username? I get error 'Invalid Column Name if I put it into the statement.





D.ARNOLD

---