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 Óï¾äÖ®ºóµÄÈκÎÓï¾äÎÞЧ¡£
*/
Ïà¹ØÎĵµ£º
@echo off
:dosmenu
REM Ñ¡Ôñ²Ëµ¥
echo Windows ·þÎñÆô¶¯»ò¹Ø±Õ By hope 2008Äê2ÔÂ7ÈÕ
echo.
echo [1]Æô¶¯Sql Server2005 [2]¹Ø±ÕSql Server2005
echo [3]Æô¶¯Oracle9i [4]¹Ø±ÕOracle9i
echo.
echo ......
ÏàÐźܶàASP+MSSQLµÄÍøÕ¾¶¼Óб»ÈË×¢Èë¹ýµÄ¾Àú£¬Êý¾Ý¿â±íÖжàÁËһЩ±í£¬ÀàËÆÒÔϵıíD99_tmp,D99_cmd£¬kill_kk¡£
D99_tmp£¨subdirectory,depth,fileÈý¸ö×ֶΣ¬ÀïÃæµÄÊý¾Ý¶¼ÊÇÍøÕ¾ÎļþºÍĿ¼£©
MSSQLÊý¾Ý¿â´æÔÚ¼¸¸öΣÏÕµÄÀ©Õ¹´æ´¢¹ý³Ì£¬Ä¬ÈÏPublic×é¿ÉÖ´ÐÐȨÏÞ£¬SQL×¢ÈëÕß¿ÉÀûÓô˶ÁÈ¡ÎļþĿ¼¼°Óû§×飬²¢¿Éͨ¹ýÏÈдÈëÊý¾ ......
1.°´ÐÕÊϱʻÅÅÐò:
Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.·ÖÒ³SQLÓï¾ä
select * from(select (row_number() OVER (ORDER BY tab.ID Desc)) as rownum,tab.* from ±íÃû As tab) As t where rownum between ÆðʼλÖà And ½áÊøÎ»ÖÃ
3.»ñÈ¡µ±Ç°Êý¾ ......
ÈçºÎ´´½¨Á´½Ó·þÎñÆ÷
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= ......