—执行execute
    exec sp_databases
    exec sp_helpdb ‘db_shopping’
    exec sp_helpfile
    execute sp_helpfilegroup
    exec sp_help
    exec sp_helptext v_1
    exec sp_rename V_3,’V_5’

    exec p_1

    create procedure p_1
    as
    begin
    —第一步，先创建分类
    insert into Category (CategoryName,P_Cate)values(‘苹果手机’,’2’)
    —获取分类主键
    declare @id int
    set @id=@@identity
    —创建商品
    insert into Product(ProductName,CategoryID,Price,Store)values(‘iPhone13’,@id,’5999’,’1000’)
    end
    exec p_1
    select *from Product join Category on Product.CategoryID=Category.CategoryID where CategoryName=’苹果手机’

    alter proc p_4
    (
    @categoryname nvarchar(50)
    )
    as
    select * from Product join Category on Product.CategoryID=Category.CategoryID
    where CategoryName=@categoryname
    exec p_4’母婴’

    create proc p_6
    as
    declare @a int,@sum int
    set @a=1
    set @sum=0
    while(@a<=5)
    begin
    set @sum+=@a
    set @a+=1
    end
    print @sum
    exec p_6

    alter proc p_6
    (
    @b int
    )
    as
    declare @a int,@sum int
    set @a=1
    set @sum=0
    while(@a<=@b)
    begin
    set @sum+=@a
    set @a+=1
    end
    print @sum
    exec p_6 100

    create proc p_7(
    @c int,@d int
    )
    as
    print @c+@d
    exec p_7 3,8

    alter proc p_8(
    @ee int,@ff int,@ii int output,@gg int output
    )
    as
    set @ii=@ee+@ff
    set @gg=@ee-@ff

    declare @ii int,@dd int
    exec p_8 1,2,@ii output,@dd output
    print @ii
    print @dd

    —5.编写存储过程，实现输入一个分类名称，查询并保存当前分类下所有产品的库存数量
    create proc P_10
    (
    @catename nvarchar(50),
    @stores int output
    )
    as
    select @stores=sum(Store) from product join Category
    on Product.CategoryID=Category.CategoryID
    where CategoryName=@catename

    declare @sto int
    exec P_10 ‘苹果手机’,@sto output
    print @sto