SQLÓï¾äʾÀý
--²éѯÊý¾Ý
SELECT *
from main_table;
--Ìí¼ÓÊôÐÔ
ALTER TABLE main_table
ADD AcctStop_Time SMALLDATETIME NULL;
--²åÈëÐÂÊý¾Ý
INSERT INTO main_table(Digital_ID, Letter_ID, User_Password, On_Line, IP, AcctStop_Time, FriendTable_UpdaeTime)
VALUES(10000000 + IDENT_CURRENT('main_table') + IDENT_INCR('main_table'), 'ttl', 666666, 0, 192168001025, GetDate(),GetDate());
--ÐÞ¸ÄÐÐÐÅÏ¢
UPDATE main_table
SET Digital_ID = 1000000+3, Letter_ID = 'ttoob'
WHERE Digital_Mark = 3
--Ìí¼ÓΨһÐÔÔ¼Êø
ALTER TABLE main_table
ADD CONSTRAINT user_id_key UNIQUE(Digital_ID);
--ɾ³ýΨһÐÔÔ¼Êø
ALTER TABLE main_table
DROP CONSTRAINT user_id_key
--»ñµÃ±í½á¹¹ SQLServer2000Ï¿ÉÓá£
exec sp_columns '±íÃû'
Ïà¹ØÎĵµ£º
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
´´½¨Îļþ¼Ð£ºexec xp_cmdshell 'md ÅÌ·û:\Îļþ¼ÐÃû³Æ', no_output
ÀýÈ磺ÔÚDÅÌ´´½¨ÃûΪ£º“×ÊÁÏ”µÄÎļþ¼Ð£ºexec xp_cmdshell 'md d:\×ÊÁÏ', no_output
²é¿´Îļþ£ºexec xp_cmdshell 'dirÅÌ·û:\Îļþ¼ÐÃû³Æ'¡£ÀýÈ磺exec xp_cmdshell 'dir d:\×ÊÁÏ'
ÅжÏÊý¾Ý¿âÊÇ·ñ´æÔÚ£ºif exists(select * from sysdat ......
--Óï ¾ä¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT¡¡¡¡¡¡--ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE¡¡¡¡¡¡--¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE¡¡¡¡--´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER ......
update ×Ó±íÃû
set ÒªÐ޸ĵÄ×Ó±í×Ö¶Î=b.»ù±íÖÐÒªÌí¼Óµ½×Ó±íÖеÄ×Ö¶Î
from ×Ó±íÃû,(select ×Ó±íÃû.ÒªÐ޸ĵÄ×Ó±í×Ö¶Î,»ù±íÃû.Òª²Î¼Ó±È½ÏµÄ×Ö¶Î from ×Ó±íÃû,»ù±íÃû where »ù±íÃû.Òª²Î¼Ó±È½ÏµÄ×Ö¶Î=×Ó±íÃû.×Ó±íÖÐÒª²Î¼Ó±È½ÏµÄ×Ö¶Î)as b
where b.»ù±íÖÐÒª²Î¼Ó±È½ÏµÄ×Ö¶Î=×Ó±íÒª²Î¼Ó±È½ÏµÄ×Ö¶Î
Èç
update Ä£°å ......
1.×î»ù±¾µÄDBMS_OUTPUT.PUT_LINE()·½·¨¡£
¡¡¡¡Ëæ±ãÔÚʲôµØ·½£¬Ö»ÒªÊÇBEGINºÍENDÖ®¼ä£¬¾Í¿ÉÒÔʹÓÃDBMS_OUTPUT.PUT_LINE(output);È»¶øÕâ»áÓÐÒ»¸öÎÊÌ⣬¾ÍÊÇʹÓøú¯ÊýÒ»´Î×î¶àÖ»¿ÉÒÔÏÔʾ255¸ö×Ö·û£¬·ñÔò»º³åÇø»áÒç³ö¡£
¡¡¡¡´ËÍ⣬º¯ÊýDBMS_OUTPUT.ENABLE(20000)ÕâÖÖº¯Êý£¬½ö½öÊÇÉèÖÃÕû¸ö¹ý³ÌµÄÈ«²¿Êä³ö»º³åÇø´óС£¬¶ø·ÇDBM ......