Hello guys. I have a problem in sql server .
I create a table and I create a stored proc in another stored proc.
When i execute USP_CRE_USP_INS the sqlserver give me an error.
please help me
CREATE DATABASE TESTDB
GO
CREATE TABLE TEST
(
ID INT IDENTITY PRIMARY KEY,
FNAME VARCHAR(50),
LNAME VARCHAR (50)
)
GO
CREATE PROC USP_CRE_USP_INS
AS
BEGIN
DECLARE @RESULT VARCHAR(500)
SET @RESULT=
'CREATE PROC USP_INS_TEST
@FNAME VARCHAR(50),
@LNAME VARCHAR(50)
AS
BEGIN
INSERT TEST(FNAME,LNAME)
VALUES (@FNAME,@LNAME)
END '
EXEC @RESULT '123','123'
END
And sql server error is:
Msg 203, Level 16, State 2, Procedure USP_CRE_USP_INS, Line 14
The name 'CREATE PROC USP_INS_TEST
@FNAME VARCHAR(50),
@LNAME VARCHAR(50)
AS
BEGIN
INSERT TEST(FNAME,LNAME)
VALUES (@FNAME,@LNAME)
END ' is not a valid identifier.