摘要:
1. 运输确认--运输证选择 (NOT IN 自连接,内连接)SELECT Distinct T0.U_TransportarNo AS '运输证编号' , T0.U_FromDate AS '有效期从' , T0.U_ToDate AS '有效期到' , T0.U_ItemCode AS '物料代... 阅读全文
摘要:
---两个字段顺序相似CREATE FUNCTION DBO.FN_Resemble_order (@Cloumna NVARCHAR(MAX), @Cloumnb NVARCHAR(MAX) )RETURNS FLOATASBEGIN DECLARE @num FLOAT,@len int SET... 阅读全文