ctrl + k + c : \u6ce8\u91ca\u591a\u884c<\/p>\n\n\n\n
ctrl + k + u : \u53d6\u6d88\u591a\u884c\u6ce8\u91ca<\/p>\n\n\n\n
\u67e5\u8be2\u4e0e\u622a\u53d6\u5b57\u7b26<\/p>\n\n\n\n
CHARINDEX ( \u8981\u627e\u5230\u7684\u5b57\u7b26\u4e32 , \u88ab\u67e5\u627e\u7684\u5b57\u7b26\u4e32 ,\u5f00\u59cb\u67e5\u627e\u7684\u4f4d\u7f6e )<\/p>\n\n\n\n
SUBSTRING( \u5b57\u7b26\u4e32 , \u5f00\u59cb\u4f4d , \u957f\u5ea6 )<\/p>\n\n\n\n
\u65e5\u671f<\/p>\n\n\n\n
CONVERT(VARCHAR(10),GETDATE(),n)<\/p>\n\n\n\n
n\u5982\u4e0b<\/p>\n\n\n\n
100 \u6216\u8005 0 mon dd yyyy hh:miAM \uff08\u6216\u8005 PM\uff09<\/p>\n\n\n\n
101 mm\/dd\/yy<\/p>\n\n\n\n
102 yy.mm.dd<\/p>\n\n\n\n
103 dd\/mm\/yy<\/p>\n\n\n\n
104 dd.mm.yy<\/p>\n\n\n\n
105 dd-mm-yy<\/p>\n\n\n\n
106 dd mon yy<\/p>\n\n\n\n
107 Mon dd, yy<\/p>\n\n\n\n
108 hh:mm:ss<\/p>\n\n\n\n
109 \u6216\u8005 9 mon dd yyyy hh:mi:ss:mmmAM\uff08\u6216\u8005 PM\uff09<\/p>\n\n\n\n
110 mm-dd-yy<\/p>\n\n\n\n
111 yy\/mm\/dd<\/p>\n\n\n\n
112 yymmdd<\/p>\n\n\n\n
113 \u6216\u8005 13 dd mon yyyy hh:mm:ss:mmm(24h)<\/p>\n\n\n\n
114 hh:mi:ss:mmm(24h)<\/p>\n\n\n\n
120 \u6216\u8005 20 yyyy-mm-dd hh:mi:ss(24h)<\/p>\n\n\n\n
121 \u6216\u8005 21 yyyy-mm-dd hh:mi:ss.mmm(24h)<\/p>\n\n\n\n
126 yyyy-mm-ddThh:mm:ss.mmm\uff08\u6ca1\u6709\u7a7a\u683c\uff09<\/p>\n\n\n\n
130 dd mon yyyy hh:mi:ss:mmmAM<\/p>\n\n\n\n
131 dd\/mm\/yy hh:mi:ss:mmmAM<\/p>\n\n\n\n
\u56db\u820d\u4e94\u5165<\/p>\n\n\n\n
CONVERT(decimal(10,2),1.0461)<\/p>\n\n\n\n
CAST(1.0461 as decimal(10,2))<\/p>\n\n\n\n
ROUND(1.0461,2) \u540e\u97620\u4fdd\u7559<\/p>\n\n\n\n
floor(1.06)\u5411\u4e0b\u53d6\u6574\u4e3a 1<\/p>\n\n\n\n
ceiling(1.02)\u5411\u4e0a\u53d6\u6574\u4e3a 2<\/p>\n\n\n\n
rtrim()\u53bb\u9664\u53f3\u8fb9\u7a7a\u683c<\/p>\n\n\n\n
ltrim()\u53bb\u9664\u5de6\u8fb9\u7a7a\u683c<\/p>\n\n\n\n
DATEPART(yy,GETDATE())<\/p>\n\n\n\n
year(GETDATE()) \u5e74<\/p>\n\n\n\n
DATEPART(mm,GETDATE())<\/p>\n\n\n\n
month(GETDATE()) \u6708<\/p>\n\n\n\n
DATEPART(dd,GETDATE())<\/p>\n\n\n\n
day(GETDATE()) \u65e5<\/p>\n\n\n\n
DATEPART(WW,GETDATE()) \u5468<\/p>\n\n\n\n
\u4e0d\u591f6\u4f4d\u524d\u88650<\/p>\n\n\n\n
isnull(REPLICATE(‘0’,6 – len(‘123′))+’123’,”)<\/p>\n\n\n\n
right(‘000000’+’123’,6)<\/p>\n\n\n\n
\u56fe\u7247<\/p>\n\n\n\n
\u51fd\u6570<\/p>\n\n\n\n
CREATE FUNCTION [dbo].[fn_fun]
(
@key NVARCHAR(10)
)
RETURNS VARCHAR(10)
AS
BEGIN
DECLARE @code VARCHAR(10)
if(LEN(@key)=1)
begin
SET @code=@key
end
if(LEN(@key)=2)
begin
SET @code=case
when @key=’10’ then ‘A’<\/p>\n\n\n\n
\u2026else\u2026end
end
return @code
end<\/p>\n\n\n\n
\u89c6\u56fe<\/p>\n\n\n\n
CREATE VIEW [dbo].[t_view]
as
select * from table where<\/p>\n\n\n\n
\u5b58\u50a8\u8fc7\u7a0b<\/p>\n\n\n\n
CREATE PROCEDURE caozuo
@st varchar(10)
as
\u8c03\u7528 exec caozuo ‘x’<\/p>\n","protected":false},"excerpt":{"rendered":"
ctrl + k + c : \u6ce8...<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[14],"class_list":["post-115","post","type-post","status-publish","format-standard","hentry","category-4","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/comments?post=115"}],"version-history":[{"count":1,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/115\/revisions"}],"predecessor-version":[{"id":116,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/115\/revisions\/116"}],"wp:attachment":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/media?parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/categories?post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/tags?post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}