贵州茅台 东方财富网:请高手帮我解释一下代码

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/30 05:08:36
在记事本里:
CREATEZT代码如下:
CREATE PROCEDURE graspcw_insertzt
(
@dbname varchar(30),
@szFullname varchar(30)
)
AS

insert into graspcwzt(dbname,fullname)values(@dbname,@szFullName)
if @@RowCount <=0 return -1 else Return 0

DELETEZT代码如下:
CREATE PROCEDURE Graspcw_DeleteZt
(
@ztId int
)
AS
set nocount on
delete from graspcwzt where [order]=@ztId
return 0

BarCodeCfg代码如下:
PrinterType=0
Label_1_Tag=6
Label_1_Top=51
Label_1_Left=14
Label_1_Value=我们都是中国人
Label_1_FontName=宋体
Label_1_FontSize=9
Label_2_Tag=1
Label_2_Top=67
Label_2_Left=48
Label_2_Value=品名
Label_2_FontName=宋体
Label_2_FontSize=9
Label_3_Tag=0
Label_3_Top=67
Label_3_Left=17
Label_3_Value=编号
Label_3_FontName=宋体
Label_3_FontSize=9
Text_count=3

GETZT代码如下:
CREATE PROCEDURE graspcw_getzt AS
set nocount off
select * from graspcwzt
return 0

GETZT代码如下:
CREATE PROCEDURE graspcw_getzt AS
set nocount off
select * from graspcwzt
return 0

DROP代码如下:
if exists (select * from sysobjects where id = object_id(N'[dbo].[Graspcw_InsertZt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Graspcw_InsertZt]
if exists (select * from sysobjects where id = object_id(N'[dbo].[Graspcw_DeleteZt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Graspcw_DeleteZt]
if exists (select * from sysobjects where id = object_id(N'[dbo].[Graspcw_GetZt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Graspcw_GetZt]