ºÙ£¬Ðֵܰ¡£¬ÕâÊÇÔõô»ØÊ£¿£¿£¿£¿
ÄãµçÄÔ±¾µØµÄͼƬ¿´²»µ½
http://d:/ÎÒµÄÎĵµ/My%20Pictures/sql%20server%20²Ù×Ýʧ°Üͼ/Database%20weihu
ºìXX
ÔõôÔÚÕâÑùµÄÂÛ̳ÉÏ·¢·Å½ØÍ¼°¡£¬ÄǸö¡®²åÈëͼƬ¡¯µÄ¹¦ÄÜÒªÊäÈëͼƬµØÖ·¿ÉÊÇÊäÁË£¬Í¼Æ¬Ã»·¨ÏÔʾզ°ì°¡£¬¼±ËÀÁË.................
ÎÒ°ÑͼƬ·ÅÔÚÕâ¶ù£ ......
SQL code:
CREATE TABLE aa(
[id] int IDENTITY (1,1) NOT NULL,
[name] varchar(100) NULL,
[pass] varchar(100) NULL,
PRIMARY KEY (id)
)
GO
http://www.cnblogs.com/iinsnian/archive/2008/06/06/1214796.html
SQL code:
--Ϊ×Ö¶Îa1Ìí¼ÓÃèÊöÐÅÏ¢
EXECUTE sp_addextendedproperty N ......
ÓÐÒ»¸ö±íTB1µÄ½á¹¹ÈçÏÂ(ÆäÖÐAAA+CCCÊÇÖ÷¼ü, AAA+BBBÊÇÔ¼ÊøË÷Òý):
AAA BBB CCC DDD
----------------------------------------------------
DA10058159 , 0   ......
±ÈÈç˵ÎÒÓÐINSERT £¬UPDATE £¬DELETE £¬SELECT Óï¾ä¸÷1000ÌõÒªÖ´ÐÐ,ÿÌõÖ´ÐеÄÊý¾ÝÁ¿¶¼ÔÚ1WÐÐÒÔÉÏ£¬Èç¹û°ÑÕâ4000ÌõÓï¾äÖ±½ÓÖ´ÐУ¬»á³öÏÖϵͳ±ÀÀ£
ÎÒÏÖÔÚÊÇÏëÒªÖ±½ÓÖ´ÐÐÕâ4000ÌõÓï¾ä£¬È»ºóÓÖ¿ÉÒÔµÈÉÏÒ»ÌõÖ´ÐÐÍê³öÏÖ½á¹ûºóÔÙÖ´ÐÐÏÂÒ»Ìõ£¬½á¹û¿ÉÊÓ£¬Ä¿Ç°ÎҵIJÙ×÷ÊÇÖðÌõÊÖ¹¤Ö´ÐÐ
ÎÒÏëÎʵÄÊÇÓÐûÓа취²»ÓÃÿ ......
select * from cpxx where cplbsz="+n+" order by quan desc
Õâ¾ä»° È¡³öÀ´µÄ ÄÚÈݰ´Ê²Ã´ÅÅÁÐ
ÊÇÏȰ´QUAN×Ö¶Î ´Ó´óµ½Ð¡ÅÅ µ«ÎÒµÄQUAN×Ö¶ÎÀï ¾Í¼¸¸ö¸ø¸¶ÖµÁË ÆäËûµÄ¶¼ÊÇĬÈÏÖµ0
ÄÄÆäËûµÄÄÚÈÝ Êǰ´Ê²Ã´ÅÅÁеÄÄØ
ÎÒÊä³ö³öÀ´ ÅÅÁеĺÃÂÒ Ò²²»Êǰ´ÐÞ¸Äʱ¼ä Ò²²»ÊÇÖ÷¼ü ÇëÎÊ ËûÅÅÁÐÓÐ¹æ¾ØÂð
ÐèÒ ......
Óбía ½á¹¹ÈçÏÂ
pid pnum sid
1 10 01
1 12 02
2 8 &nb ......