syntax error (at stored proc)?
in [Programming SQL]
|
Prev: using backslash ( \ ) inside Parameter
Next: marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicotePara Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 36832
From: Justin D. on 19 Feb 2010 19:12 Hi, I am not sure what is the issue. I got following error. "Incorrect syntax near '@Param'." Bottom is the stored procedure. --------------------------------------------------------- CREATE PROC [dbo].[spCreateUser] @Param nvarchar(50) AS BEGIN CREATE USER @Param FOR LOGIN @Param END --------------------------------------------------------- I would appreciate if you let me know. Thanks.
From: Plamen Ratchev on 19 Feb 2010 20:46
You cannot use parameters/variables in the CREATE USER statement. To accomplish that you would need to use dynamic SQL. -- Plamen Ratchev http://www.SQLStudio.com |