摘要:
declare @billIds varchar(400) declare @billId varchar(40) DECLARE c1 CURSOR FOR select top 5 SaleNo from Pos_Master where SaleDate>@dd -- 一次上传5笔 open... 阅读全文
摘要:
ALTER PROCEDURE [dbo].[sp_get_saleData]ASBEGIN set nocount on -- 获取最近上传数据的时间戳 declare @dd datetime select @dd=LastUpload from sys_upload where UploadT... 阅读全文
摘要:
ALTER FUNCTION [dbo].[f_GetCookType] (@saleDate datetime)RETURNS varchar(6)ASBEGIN declare @cookType varchar(6) declare @time datetime Select @time=CO... 阅读全文
摘要:
USE [pos]GO/****** Object: Trigger [dbo].[tr_insert] Script Date: 06/26/2014 09:27:19 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =====... 阅读全文