摘要:
use my_temp CREATE VIEW V_temp --创建视图 AS SELECT * FROM A select *from V_temp 阅读全文
摘要:
select col from [dbo].[GetInPara]('101,102,103',',') USE [xxx] GO /****** Object: UserDefinedFunction [dbo].[GetInPara] Script Date: 2019/9/26 11:06:28 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFI 阅读全文
摘要:
SELECT LEN('SQL Server LEN') length, LEN('SQL Server LEN ') length_with_trailing_blanks; SELECT (CASE WHEN LEN('')=0 THEN '001' ELSE '1线' END) --执行001 SELECT (CASE WHEN LEN('1线')=0 THEN '001' ELSE '1线 阅读全文