摘要： 在MES中经常会有SN与规则匹配,用SQL中的通配符试试看 SELECT CASE WHEN 'ABC123321BVC' like 'ABC______BVC' THEN 'Match' ELSE 'No Match' END AS Result; 'ABC123321BVC'==实际的条码 'A 阅读全文

摘要： 自定义函数返回时间或时间戳 CREATE FUNCTION [dbo].[DateAndTimestamp] (@date as datetime, @timestamp as int, @retType as varchar(10) ) RETURNS varchar(100) AS BEGIN 阅读全文

摘要： Create FUNCTION [dbo].[FormatDateTime] (@date as datetime, 传入时间 @dformat as varchar(10) 传入要生成的格式代码 ) RETURNS varchar(100) AS BEGIN declare @datestring 阅读全文