zimmer9
asked on
I execute a stored procedure in Microsoft SQL Server Management Studio 2005 and I don't know why the table doesn't get created?
I execute the following stored procedure in Microsoft SQL Server 2005.
I don't know why the table doesn't get created.
I use 'dbo' as the owner for the stored procedure and "empdwmsq" as the owner for the tables.
-------------------------- ---------- ---------- ---------- -----
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE procedure [dbo].[sp_action_group]
As
If Exists(SELECT * FROM dbo.SYSOBJECTS WHERE NAME = 'tblAction_Grp' AND TYPE = 'U')
DROP TABLE empdwmsq.tblAction_Grp
create table empdwmsq.tblAction_Grp
(PRINCIPAL_GROUP_TYPE varchar(255),
PRINCIPAL_GROUP_VALUE varchar(255),
ELEMENT_TYPE_VALUE_PAIRS varchar(255)
)
insert into empdwmsq.tblAction_Grp (PRINCIPAL_GROUP_TYPE,PRIN CIPAL_GROU P_VALUE,EL EMENT_TYPE _VALUE_PAI RS)
values ('RIGHTS', 'Everything', NULL);
insert into empdwmsq.tblAction_Grp (PRINCIPAL_GROUP_TYPE,PRIN CIPAL_GROU P_VALUE,EL EMENT_TYPE _VALUE_PAI RS)
values ('RIGHTS', 'Security Administrator', NULL);
insert into empdwmsq.tblAction_Grp (PRINCIPAL_GROUP_TYPE,PRIN CIPAL_GROU P_VALUE,EL EMENT_TYPE _VALUE_PAI RS)
values ('RIGHTS', 'User', NULL);
insert into empdwmsq.tblAction_Grp (PRINCIPAL_GROUP_TYPE,PRIN CIPAL_GROU P_VALUE,EL EMENT_TYPE _VALUE_PAI RS)
values ('RIGHTS', 'View', NULL);
I don't know why the table doesn't get created.
I use 'dbo' as the owner for the stored procedure and "empdwmsq" as the owner for the tables.
--------------------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE procedure [dbo].[sp_action_group]
As
If Exists(SELECT * FROM dbo.SYSOBJECTS WHERE NAME = 'tblAction_Grp' AND TYPE = 'U')
DROP TABLE empdwmsq.tblAction_Grp
create table empdwmsq.tblAction_Grp
(PRINCIPAL_GROUP_TYPE varchar(255),
PRINCIPAL_GROUP_VALUE varchar(255),
ELEMENT_TYPE_VALUE_PAIRS varchar(255)
)
insert into empdwmsq.tblAction_Grp (PRINCIPAL_GROUP_TYPE,PRIN
values ('RIGHTS', 'Everything', NULL);
insert into empdwmsq.tblAction_Grp (PRINCIPAL_GROUP_TYPE,PRIN
values ('RIGHTS', 'Security Administrator', NULL);
insert into empdwmsq.tblAction_Grp (PRINCIPAL_GROUP_TYPE,PRIN
values ('RIGHTS', 'User', NULL);
insert into empdwmsq.tblAction_Grp (PRINCIPAL_GROUP_TYPE,PRIN
values ('RIGHTS', 'View', NULL);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.