MSSQL\u670d\u52a1\u5668\u662f\u8bb8\u591a\u4f01\u4e1a\u5728\u6570\u636e\u5e93\u73af\u5883\u4e2d\u6240\u91c7\u7528\u7684\u5f3a\u5927\u7684\u89e3\u51b3\u65b9\u6848\uff0c\u7528\u4e8e\u5b58\u50a8\u53ca\u7ba1\u7406\u5ba2\u6237\u548c\u4f01\u4e1a\u7684\u6570\u636e\u3002\u56e0\u6b64\uff0c\u4fdd\u62a4\u6570\u636e\u5b89\u5168\u975e\u5e38\u91cd\u8981\uff0c\u4fdd\u8bc1MSSQL\u670d\u52a1\u5668\u7684\u5b89\u5168\u6027\u5bf9\u4f01\u4e1a\u6765\u8bf4\u975e\u5e38\u91cd\u8981\u3002\u4e3a\u4e86\u63d0\u9ad8MSSQL\u670d\u52a1\u5668\u5b89\u5168\u6027\uff0c\u63d0\u6743\u662f\u4e00\u79cd\u91cd\u8981\u7684\u6280\u672f\u624b\u6bb5\u3002\u867d\u7136\u8fd9\u79cd\u6280\u672f\u53ef\u80fd\u4f1a\u5c06\u670d\u52a1\u5668\u63d0\u5347\u5230\u66f4\u9ad8\u7684\u5b89\u5168\u6c34\u5e73\uff0c\u4f46\u5b83\u4ecd\u7136\u53ef\u80fd\u906d\u53d7\u653b\u51fb\u3002\u56e0\u6b64\uff0c\u638c\u63e1\u4e86\u76f8\u5173\u6280\u672f\u53ca\u65b9\u6cd5\u6709\u52a9\u4e8e\u9884\u9632\u53ca\u5e94\u5bf9MSSQL\u653b\u51fb\u3002<\/p>\n<\/p>\n
\u964d\u4f4eMSSQL\u653b\u51fb\u7684\u4e00\u79cd\u6709\u6548\u65b9\u6cd5\u662f\u63d0\u6743MSSQL\u670d\u52a1\u5668\uff0c\u4ee5\u9632\u6b62\u9ed1\u5ba2 missiles\u8bd5\u56fe\u767b\u5f55\u7cfb\u7edf\u5e76\u76d7\u53d6\u6570\u636e\u3002\u8fd9\u6837\u4e00\u6765\uff0c\u5373\u4f7f\u662f\u8f83\u9ad8\u7684\u6743\u9650\u7528\u6237\u4e5f\u65e0\u6cd5\u8bbf\u95ee\u670d\u52a1\u5668\uff0c\u4ece\u800c\u9632\u6b62\u4e86\u6570\u636e\u6cc4\u9732\u3002\u53e6\u5916\uff0cMSSQL\u670d\u52a1\u5668\u7684\u63d0\u6743\u8fd8\u53ef\u4ee5\u8ba9\u7cfb\u7edf\u66f4\u52a0\u7a33\u5b9a\uff0c\u4f7f\u5ba2\u6237\u7684\u670d\u52a1\u66f4\u52a0\u53ef\u9760\u3002 <\/p>\n<\/p>\n
\u5177\u4f53\u7684\u63d0\u6743\u6280\u672f\u53ef\u4ee5\u901a\u8fc7\u5efa\u7acb\u5b58\u50a8\u8fc7\u7a0b\uff0c\u5bf9MSSQL\u670d\u52a1\u5668\u8fdb\u884c\u5b89\u5168\u6027\u63d0\u5347\u3002\u4f8b\u5982\uff0c\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u6b65\u9aa4\u63d0\u5347MSSQL\u670d\u52a1\u5668\u5b89\u5168\u6027\uff1a<\/p>\n<\/p>\n
1.\u4f7f\u7528SQL Server\u539f\u751f\u811a\u672c\u68c0\u67e5\u6570\u636e\u5e93\u53ca\u5e94\u7528\u7a0b\u5e8f\u7684\u5b89\u5168\u6027\uff0c\u641c\u7d22\u5f31\u53e3\u4ee4\u767b\u5f55\u7cfb\u7edf\u7b49\u6f5c\u5728\u6f0f\u6d1e\u3002<\/p>\n
2.\u7981\u6b62MSSQL\u670d\u52a1\u5668\u4e2d\u672a\u7ecf\u6388\u6743\u7684\u7528\u6237\u8bbf\u95ee\uff0c\u5e76\u9650\u5236\u6bcf\u4e2a\u7528\u6237\u7684\u6709\u6548\u65f6\u95f4\uff0c\u4ee5\u964d\u4f4e\u88ab\u653b\u51fb\u7684\u98ce\u9669\u3002<\/p>\n
3.\u521b\u5efa\u81ea\u5b9a\u4e49\u89c6\u56fe\u548c\u51fd\u6570\u6765\u9650\u5236\u5bf9\u6570\u636e\u5e93\u7684\u8bbf\u95ee\uff0c\u9632\u6b62\u672a\u7ecf\u6388\u6743\u7684\u6570\u636e\u8bbf\u95ee\u3002<\/p>\n
4.\u542f\u7528\u6570\u636e\u5e93\u5ba1\u8ba1\uff0c\u4ee5\u5b9a\u671f\u68c0\u67e5MSSQL\u670d\u52a1\u5668\u4e2d\u53d1\u751f\u7684\u60c5\u51b5\u3002<\/p>\n<\/p>\n
\u5982\u4e0b\u662f\u90e8\u5206\u5b9e\u9645\u64cd\u4f5c\u4ee3\u7801\uff0c\u4f7f\u7528SQL Sever Data Tools (SSDT)\u6765\u5b8c\u6210\uff1a<\/p>\n<\/p>\n
\u2014 \u521b\u5efa\u89c6\u56fe<\/p>\n
CREATE VIEW view_name<\/p>\n
AS<\/p>\n
SELECT field1, field2<\/p>\n
FROM table_name<\/p>\n
GO<\/p>\n<\/p>\n
\u2014 \u521b\u5efa\u51fd\u6570<\/p>\n
CREATE FUNCTION function_name<\/p>\n
(<\/p>\n
@parameter1 int,<\/p>\n
@parameter2 varchar(50)<\/p>\n
)<\/p>\n
RETURNS varchar(50)<\/p>\n
AS<\/p>\n
BEGIN <\/p>\n
DECLARE @result varchar(50)<\/p>\n
\/\/ Do something<\/p>\n
SET @result = \u2018Value\u2019<\/p>\n
RETURN @result<\/p>\n
END<\/p>\n
GO<\/p>\n<\/p>\n
\u2014 \u641c\u7d22\u5f31\u53e3\u4ee4<\/p>\n
SELECT name, COUNT(*) AS Number_of_Failed_Logins<\/p>\n
FROM sys.dm_exec_login_stats<\/p>\n
WHERE is_login_successful = 0<\/p>\n
GROUP BY name<\/p>\n
GO<\/p>\n<\/p>\n
\u4ee5\u4e0a\u662fMSSQL\u670d\u52a1\u5668\u7684\u63d0\u6743\u6280\u672f\uff0c\u5b83\u53ef\u4ee5\u5e2e\u52a9\u4f01\u4e1a\u63d0\u5347\u670d\u52a1\u5668\u5b89\u5168\u6027\uff0c\u6709\u52a9\u4e8e\u9632\u8303\u653b\u51fb\u3002\u53e6\u5916\uff0c\u6309\u7167\u4ee5\u4e0a\u6b65\u9aa4\u4ee5\u53ca\u4ee3\u7801\u53ef\u4ee5\u6709\u6548\u63d0\u5347MSSQL\u670d\u52a1\u5668\u7684\u5b89\u5168\u6027\u3002<\/p>\n