摘要:
use my_temp CREATE VIEW V_temp --创建视图 AS SELECT * FROM A select *from V_temp 阅读全文
posted @ 2019-09-26 16:11
enych
阅读(155)
评论(0)
推荐(0)
摘要:
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 阅读全文
posted @ 2019-09-26 11:07
enych
阅读(1000)
评论(0)
推荐(0)
摘要:
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线 阅读全文
posted @ 2019-09-26 10:41
enych
阅读(740)
评论(0)
推荐(0)

浙公网安备 33010602011771号