SQLSERVERÊý¾Ýµ¼³öµ½Access
Sqlserver±í½á¹¹
Create table test
(
int parentID primary key identity(1,1),
int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
1
2 1
5 2
20 1
...
ÈçºÎ½«ÉÏÈçÉϸñʽÊý¾ÝÒÆÖ²µ½Access
ÒªÇóÒÆÖ²ºóÊý¾Ý¹ØÁªÖµ²»±ä
to:josy
·Ç³£¸Ðл£¬¸Õ²âÊÔºóÈç¹ûAccess²»ÉèÖÃ×Ô¶¯Ôö³¤Êý¾ÝÄܳɹ¦µ¼È룬ÄÇÎÒÐèÒª»Ö¸´Access parentIDµÄ×Ô¶¯Ôö³¤ÓÐʲô·½·¨Ã»ÓУ¬ÒòΪAccessÊý¾Ý¿âºóÆÚÐèÒª×ö²åÈë²Ù×÷
to:Happy_Stone
Êý¾Ý±íʵÔÚÊÇÌ«¶àÁË£¬ºÃ¶àÓû§µÄºÃ¶à±í¡£¡£¡£
ÏÖÔÚµÄÎÊÌâ×Ô¶¯Ôö³¤Õâ¸ö×Ö¶ÎÅÂÊÇÄÑÒѽâ¾ö£¬»¹ÆÚ´ý¸ßÊÖÃÇ°ïÖú
Ïà¹ØÎÊ´ð£º
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
ÔÚÊý¾Ý¿âÖÐÈÕÆÚÈçÏÂÏÔʾ£º2009-2-27 9:40:47
Õâ¸ö²»ÊÇÎÒÏëÒªµÄ£¬ÎÒÐèÒªÔ·ݺÍʱ¼äÓÃÁ½Î»Êý±íʾ£¬ÉÏÃæµÄÓ¦¸Ãת»»Îª;2009-02-27 09:40:47
ÇëÎÊ
1¡¢ÈçºÎ¶ÔÏÖÓÐÈÕÆÚ½øÐÐת»»£¨Êý¾Ý¿âÖÐÒÑ´æÔÚÐí¶àÀàËƵÄÖµ£¬ÎÒÐèÒª½«Æä ......
asp.net²éѯSqlServer2005ÖÐtextÀàÐÍÊý¾Ý³£³£¶ªÊ§£¬Ìí¼ÓÊý¾Ýµ½textÀàÐÍÖп´Ò³ÃæÉÏ¿ÉÒÔ£¬ÓиöÒ»Á½Ì죬¾Í¿ÉÄÜ»á³öÏÖtext
Êý¾Ý´æµÄÊý¾ÝȱÉÙÒ»²¿·Ö£¬ÎªÊ²Ã´°¡£¡Çë´ó¼Ò°ï°ïæ°¡£¡
Óöþ½øÖÆ´æ·ÅËãÁË
²»Ã÷°×£¬ÄÜ×Ðϸ ......