Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MSSQLÖмì²éËùʹÓõÄÓï¾äÊÇ·ñ±ê×¼

 ¼ì²éËùʹÓõÄÓï¾äÊÇ·ñ±ê×¼
 /*
     ±ê×¼SQLºÍT-SQLÖ®¼äÓкܶàÇø±ð——Ì«¶àÁË£¬ÕâÀï¾Í²»ËµÁË¡£»¹ÓУ¬Èç¹ûÄãÔÚSQL ServerÉϹ¤×÷£¬
 ÄÇôʹÓÃÕâЩ˽ÓеÄÀ©Õ¹ÊÇÓкô¦µÄ¡£ÓÉÓÚÐí¶àSQL ServerµÄÌØÐԵı¾ÖÊ£¬Ä㲻ʹÓ÷DZê×¼µÄÃüÁîµÄ»°£¬
 ½«»áÓкܶàÇ¿´óµÄ¹¦ÄÜÎÞ·¨ÊµÏÖ¡£Èç¹ûÄãÏëÒª¿´¿´ÄãµÄSQLÊÇ·ñ·ûºÏ±ê×¼£¬Äã¿ÉÒÔʹÓÃSET FIPS_FLAGGER
 ÃüÁî
 */
  SET FIPS_FLAGGER 'level'
/*
' level '
¶Ô FIPS 127-2 ±ê×¼µÄ×ñ´Ó¼¶±ð£¬½«¼ì²éËùÓÐÊý¾Ý¿â²Ù×÷ÊÇ·ñ´ïµ½¸Ã¼¶±ð¡£Èç¹ûÊý¾Ý¿â²Ù×÷ÓëÑ¡¶¨µÄ ISO ±ê×¼¼¶±ð³åÍ»£¬Ôò Microsoft SQL Server ½«Éú³ÉÒ»¸ö¾¯¸æ¡£
level ±ØÐëÊÇÏÂÁÐÖµÖеÄÒ»¸ö¡£
Öµ  ˵Ã÷  
ENTRY  ¼ì²éÊÇ·ñ×ñ´Ó ISO ÈëÃż¶±ê×¼¡£
 
FULL
 ¼ì²éÊÇ·ñ×ñ´Ó ISO ÍêÈ«¼¶±ê×¼¡£
 
INTERMEDIATE ¼ì²éÊÇ·ñ×ñ´Ó ISO Öм伶±ê×¼¡£
 
OFF
 ²»¼ì²éÊÇ·ñ×ñ´Ó±ê×¼¡£
*/
/*
SET FIPS_FLAGGER µÄÉèÖÃÊÇÔÚ·ÖÎöʱÉèÖ㬶ø²»ÊÇÔÚÖ´ÐлòÔËÐÐʱÉèÖá£ÔÚ·ÖÎöʱ½øÐÐÉèÖÃÒâζ×Å£ºSET Óï¾äÖ»Òª³öÏÖÔÚÅú´¦Àí»ò´æ´¢¹ý³ÌÖм´ÉúЧ£¬Óë´úÂëÖ´ÐÐʵ¼ÊÉÏÊÇ·ñµ½´ï¸ÃµãÎ޹أ»²¢ÇÒ SET Óï¾äÔÚÈκÎÓï¾äÖ´ÐÐ֮ǰÉúЧ¡£ÀýÈ磬¼ÙÉè SET Óï¾äÔÚ IF...ELSE Óï¾ä¿éÖУ¬¶øÔÚÖ´Ðйý³ÌÖдÓδµ½´ï¹ý¸ÃÓï¾ä¿é£¬µ«ÓÉÓÚ·ÖÎöÁË IF...ELSE Óï¾ä¿é£¬Òò´Ë SET Óï¾äÈÔÉúЧ¡£
Èç¹ûÔÚ´æ´¢¹ý³ÌÖÐÉèÖà SET FIPS_FLAGGER£¬Ôò´Ó´æ´¢¹ý³Ì·µ»Ø¿ØÖƺ󽫻¹Ô­ SET FIPS_FLAGGER µÄÖµ¡£Òò´Ë£¬ÔÚ¶¯Ì¬ SQL ÖÐÖ¸¶¨µÄ SET FIPS_FLAGGER Óï¾ä¶Ô¶¯Ì¬ SQL Óï¾äÖ®ºóµÄÈκÎÓï¾äÎÞЧ¡£
*/


Ïà¹ØÎĵµ£º

MsSQL,MySQL,Oracle,Êý¾Ý¿âÁ¬½Ó×Ö¶Î

Ms sql 2000
drivername=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books
username=sa
password=sa
MySQL
drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/books
username=root
password=root
Oracle
drivername=orac ......

mssql Öн«ºº×Öת»»ÎªÆ´ÒôÊ××Öĸ·½·¨


1.
--½«ºº×Öת»»ÎªÆ´ÒôÊ××Öĸ
CREATE   function   GetAllPY(@str   nvarchar(4000))
returns   nvarchar(4000)
--WITH   ENCRYPTION
as
begin
declare   @intLen int
declare   @strRet nvarchar(4000)
declare   @temp   nvarchar(100)
set   @intLen &nb ......

MSSQLÌí¼Ó×Ö¶Î˵Ã÷

--×Ö¶ÎÌí¼Ó˵Ã÷
EXEC sp_addextendedproperty 'MS_Description', 'ÒªÌí¼ÓµÄ˵Ã÷', 'user', dbo, 'table', ±íÃû, 'column', ÁÐÃû
--ɾ³ý×Ö¶Î˵Ã÷
EXEC sp_dropextendedproperty 'MS_Description', 'user', dbo, 'table', ±íÃû, 'column', ×Ö¶ÎÃû
--²é¿´×Ö¶Î˵Ã÷
SELECT
    [Table Name] = i_s.TAB ......

½²½âMSSQLÊý¾Ý¿âÖÐSQLËø»úÖƺÍÊÂÎñ¸ôÀ뼶±ð

Ëø»úÖÆ
NOLOCKºÍREADPASTµÄÇø±ð¡£
1. ¿ªÆôÒ»¸öÊÂÎñÖ´ÐвåÈëÊý¾ÝµÄ²Ù×÷¡£
BEGIN TRAN t
INSERT INTO Customer
SELECT 'a','a'
2. Ö´ÐÐÒ»Ìõ²éѯÓï¾ä¡£
SELECT * from Customer WITH (NOLOCK)
½á¹ûÖÐÏÔʾ"a"ºÍ"a"¡£µ±1ÖÐÊÂÎñ»Ø¹öºó£¬ÄÇôa½«³ÉΪÔàÊý¾Ý¡£(×¢:1ÖеÄÊÂÎñδÌá½») ¡£NOLOCK±íÃ÷ûÓжÔÊý¾Ý±íÌí¼Ó¹²Ï ......

ÆôÓÃMSSQL·Ö²¼Ê½ÊÂÎñµÄ³£¼ûÎÊÌâ

ÈçºÎ´´½¨Á´½Ó·þÎñÆ÷
IF  EXISTS (SELECT srv.name from sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'Á´½Ó·þÎñÆ÷Ãû')
EXEC master.dbo.sp_dropserver @server=N'Á´½Ó·þÎñÆ÷Ãû'', @droplogins='droplogins'
GO
EXEC master.dbo.sp_addlinkedserver
 @server = N'Á´½Ó·þÎñÆ÷Ãû'', @srvproduct= ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ