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

SQL SERVERÒìµØ±¸·Ý·½·¨(1)

д³É´æ´¢¹ý³Ì£¬½¨Á¢×÷Òµ¶¨Ê±±¸·Ý~~~
--ÔÚsqlÖÐÓ³ÉäһϾͿÉÒÔÁË
exec master..xp_cmdshell 'net use z: \\yizhi\D$ "ÃÜÂë" /user:yizhi\administrator'
/*--˵Ã÷:
exec master..xp_cmdshell 'net use z: \\xz\c$ "ÃÜÂë" /user:xz\administrator'
z:ÊÇÓ³ÉäÍøÂç·¾¶¶ÔÓ¦±¾»úµÄÅÌ·û,ÓëÏÂÃæµÄ±¸·Ý¶ÔÓ¦
\\xz\c$ÊÇÒªÓ³ÉäµÄÍøÂç·¾¶
xz\administrator
xzÊÇÔ¶³ÌµÄ¼ÆËã»úÃû,
administratorÊǵǽµÄÓû§Ãû
ÃÜÂë ÃæÖ¸¶¨µÄadministratorÓû§µÄÃÜÂë
--*/
--±¸·Ý£»with init¸²¸Ç|noinitÌí¼Ó
backup database ¿âÃû to disk='E:\H_BACKUP.bak' with init
--COPY
exec master..xp_cmdshell 'copy E:\H_BACKUP.bak z:'
--ɾ³ý£¨Õâ¾ä¿ÉÒÔÈ¥µô£©
--exec master..xp_cmdshell 'del E:\H_BACKUP.bak'
--Íê³Éºóɾ³ýÓ³Éä
exec master..xp_cmdshell 'net use z: /delete'


Ïà¹ØÎĵµ£º

OM裡±£Áô記錄備·ÝSQL

 First:
create table gobo.gobo_om_reservations_2008b as
select * from gobo_om_reservations
where to_char(CREATION_DATE,'yyyy')<'2008'
delete from gobo_om_reservations
where to_char(CREATION_DATE,'yyyy')<'2008'
commit
After 2009Year:
create table gobo.gobo_om_reservations_????b as ......

Éú³ÉÊ¡ÊеÄSQL½Å±¾

 --Ê¡¼¶   Provincial
--³ÇÊР  City
create table Provincial(pid int,Provincial varchar(50),primary key (pid))
insert into Provincial values(1,'±±¾©ÊÐ')
insert into Provincial values(2,'Ìì½òÊÐ')
insert into Provincial values(3,'ÉϺ£ÊÐ')
insert into Provincial values(4,'Ö ......

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓÃ

 Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄsql serverÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý£¨clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý£©ºÍ·Ç¾Û¼¯Ë÷Òý£¨nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý£©¡£ÏÂÃæ£¬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒÃǵĺºÓï× ......

SQLµÄǰÊÀ½ñÉú

 Ç°ÑÔÀÎÒ̸µ½ÁËһЩFORTRAN³ÌÐòÔ±ºÍÒ»ÃûLISP³ÌÐòÔ±µÄÊ£¬Ç°ÕßÖ»»áʹÓÃÑ­»·À´½â¾öÎÊÌ⣬ºóÕßÖ»»áʹÓõݹ鷽ʽ½â¾öÎÊÌâ¡£ÕâÖÖÇé¿ö²¢²»
ÉÙ¼û£¬ÒòΪÈËÃǶ¼Ï²»¶Ê¹ÓÃ×Ô¼ºÁ˽âµÄ¹¤¾ß¡£ÏÂÃæ½²Ò»¸öЦ»°£¬²»ÊÇÕæÊ£ºÓÐÈ˸øÒ»¸öÊýѧ¼Ò¡¢Ò»¸öÎïÀíѧ¼ÒºÍÒ»¸öÊý¾Ý¿â³ÌÐòÔ±¸÷·¢ÁËÒ»¸öÏðƤÇò£¬²¢ÇÒÈÃËûÃÇÈ·
¶¨ÇòµÄÌå»ý¡£
Êýѧ¼Ò ......

sql_ÉèÖÃȨÏÞ_Êý¾Ý¿â»ù´¡

ÉèÖÃȨÏÞ
²»ÂÛÓû§»ò½ÇÉ«£¬¶¼ÊÇȨÏÞµÄÉèÖöÔÏó¡£³ýÁËÓ¦ÓóÌÐò½ÇÉ«½ÏÌØÊ⣬ÓëÆäËû½ÇÉ«¼°ÓÃ
»§ÓÐÏ໥ÅÅ³â¹ØÏµÍ⣬Êý¾Ý¿â½ÇÉ«¼°³ÉÔ±ÔÚȨÏ޵ĹØÏµÉϷdz£ÃÜÇС£Ò»¸öÓû§¿ÉÄÜͬʱÁ¥
ÊôÓÚ¶à¸öÊý¾Ý¿â½ÇÉ«£¬Ã¿Ò»½ÇÉ«ÓÖ¿ÉÓµÓв»Í¬È¨ÏÞ£¬´ËʱÓû§»ñȡʵ¼ÊȨÏÞµÄÔ­ÔòÊÇ“²¢
¼¯”£¬³ý·ÇÓÐ deny£¨½ûÖ¹£©µÄÉèÖá£Èç½ÇÉ« A ½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ