⑧o年崋日常记录

IF EXISTS ( SELECT 1 FROM sys.objects WHERE name = 'P_DeleteDscirption' AND type = 'p' ) BEGIN DROP PROCEDURE P_DeleteDscirption ENDGOCREATE PROCEDURE P_DeleteDscirptionAS BEGIN

-- 使用函数的方法：--建立 演示环境if object_id('tb_bookInfo') is not null drop table tb_bookInfogocreate table tb_bookInfo(number int,name varchar(10),type int)insert tb_bookInfoselect 1 ,'n1', 6 union allselect 2 ,'n2', 3if object_id('tb_bookType') is not n