是的,先创建后修改就没问题.-- 创建 CREATE PROCEDURE p_AAA (@TypeId int) AS select * from t_productstype where ParentId = @TypeId -- 修改 ALTER PROCEDURE p_AAA (@TypeId int) AS select * from t_productstype where ParentId = @TypeId
是的,先创建后修改就没问题.-- 创建 CREATE PROCEDURE p_AAA (@TypeId int) AS select * from t_productstype where ParentId = @TypeId -- 修改 ALTER PROCEDURE p_AAA (@TypeId int) AS select * from t_productstype where ParentId = @TypeId
CREATE PROCEDURE p_AAA
(@TypeId int)
AS
select * from t_productstype where ParentId = @TypeId
-- 修改
ALTER PROCEDURE p_AAA
(@TypeId int)
AS
select * from t_productstype where ParentId = @TypeId
CREATE PROCEDURE p_AAA
(@TypeId int)
AS
select * from t_productstype where ParentId = @TypeId
-- 修改
ALTER PROCEDURE p_AAA
(@TypeId int)
AS
select * from t_productstype where ParentId = @TypeId
已经创建了,但是提示说无效
CREATE PROCEDURE p_AAA
(@TypeId int)
AS
select * from t_productstype where ParentId = @TypeId
-- 修改
ALTER PROCEDURE p_AAA
(@TypeId int)
AS
select * from t_productstype where ParentId = @TypeId