SQLÊý¾ÝÖÐÔËÐÐcmdÃüÁî
ÔÚsql²éѯ·ÖÎöÆ÷ÀïÃæÊDz»ÄÜÖ±½ÓÔËÐÐcmdÃüÁîµÄ
µ«ÊÇSQL¸ø³öÁËÒ»¸ö½Ó¿Ú
--´ò¿ª¸ß¼¶ÉèÖÃ
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
--´ò¿ªxp_cmdshellÀ©Õ¹´æ´¢¹ý³Ì
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE
Ê×ÏÈ ´ò¿ªÒ»Ð©ÅäÖÃ
È»ºóÖ´ÐÐÄãÒªÔËÐÐcmdÃüÁî
exec master..xp_cmdshell 'net start "computer browser"'
RECONFIGURE
--Ìí¼ÓÍøÂçÇý¶¯Æ÷Ó³Éä
exec master..xp_cmdshell 'net use z: \\192.168.0.3\F$\DataBase "ÃÜÂë" /user:192.168.0.3£¨IP£©\administrator£¨µÇ½Óû§Ãû£©
È»ºó¹Ø±ÕÏàÓ¦µÄ³ÌÐò
--ɾ³ýÓ³Éä
exec master..xp_cmdshell 'net use z: /delete'
--¹Ø±Õxp_cmdshellÀ©Õ¹´æ´¢¹ý³Ì¡¢¸ß¼¶ÉèÖÃ
EXEC sp_configure 'xp_cmdshell', 0
RECONFIGURE
EXEC sp_configure 'show advanced options', 0
RECONFIGURE
Ïà¹ØÎĵµ£º
½â¾ö·½·¨Ò»
ÔÚoraDb10g_home->ÅäÖúÍÒÆÖ²¹¤¾ß->net Manager
ÔÚ±¾µØÖÐн¨Ò»¸ö·þÎñÃüÃû
Õâ¸öÍøÂç·þÎñÃû¾ÍÊǵǽʱµÄÊý¾Ý¿âÃû
Íê³ÉÕâЩ²Ù×÷ºó£¬Ñ¡Ôñ²Ëµ¥ÖÐÎļþ->±£´æÍøÂçÅäÖþÍokÁË¡£
½â¾ö·½·¨¶þ
´ò¿ª°²×°Ä¿Â¼Ï·þÎñÆ÷¶ËµÄtnsnames.ora£¬±ÈÈçÎÒµÄÍêÕûĿ¼ÊÇE:\oracle\product\ ......
use Tempdb
go
if object_ID ( 'fn_ACITEncryption' ) is not null
drop function fn_ACITEncryption
go
create function fn_ACITEncryption
(
@Str nvarchar ( 4000), -- ¼ÓÃܵÄ×Ö·û´®
@Flag bit = 1, --1 ¡¢¼ÓÃÜ 0 ¡¢½âÃÜ
@Key nvarchar ( 50) -- ÃÜÎÄ
)
returns nvarchar ( 4000) ......
SQL°´ÕÕÈÕ¡¢ÖÜ¡¢Ô¡¢Äêͳ¼ÆÊý¾Ý ÊÕ²Ø
ÎÄÕ²ο¼£ºhttp://www.cnblogs.com/wenbhappy/archive/2008/07/02/1233660.html
Èç:
±í:consume_record
×Ö¶Î:consume (moneyÀàÐÍ)
date (datetimeÀàÐÍ)
ÇëÎÊÔõôдËÄÌõsqlÓï¾ä·Ö±ð°´ÈÕ,°´ÖÜ,°´ÔÂ,°´¼¾Í³¼ÆÏû·Ñ×ÜÁ¿.
Èç:1ÔÂ 1200Ô ......
Microsoft Access Êý¾ÝÀàÐÍ
Êý¾ÝÀàÐÍ
ÃèÊö
´æ´¢
Text
ÓÃÓÚÎı¾»òÎı¾ÓëÊý×ÖµÄ×éºÏ¡£×î¶à 255 ¸ö×Ö·û¡£
Memo
Memo ÓÃÓÚ¸ü´óÊýÁ¿µÄÎı¾¡£×î¶à´æ´¢ 65,536 ¸ö×Ö·û¡£
×¢ÊÍ£ºÎÞ·¨¶Ô memo ×ֶνøÐÐÅÅÐò¡£²»¹ýËüÃÇÊÇ¿ÉËÑË÷µÄ¡£
Byte
ÔÊÐí 0 µ½ 255 µÄÊý×Ö¡£
1 ×Ö½Ú
Integer
ÔÊÐí½éÓÚ -32,768 µ½ 32 ......