CREATE
PROCEDURE
SpecialInsertProcedure
@TableName
varchar
(50),
@userId
varchar
(10),
@pwd
varchar
(10),
@userRole
int
AS
exec
(
'insert into '
+@TableName +
'(userId,pwd,userRole) values ('
''
+@userId+
''
','
''
+@pwd+
''
','
+@userRole+
')'
)