¼±£¬sqlserver½ø²»È¥ÁË£¿[
ûÁ¬½ÓÍøÏߣ¬ÎÒÔÚ±¾»úÉϰ²×°µÄsqlserver2008¾Í½ø²»È¥ÁË¡£Ôõô½â¾öÄØ£¿
±¾µØ²»ÄܵǼÂð£¿.......
ÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄ
Óà windowsÉí·ÝÒ²²»ÄܵǼÂð£¿
ÄãÁ¬½ÓµÄÊý¾Ý¿âÊÇÕą̂µçÄÔ
»¹ÊÇÆäËüµçÄÔ£¿£¿
Ìáʾʲô£¿ÊÇûÆô¶¯»¹ÊÇÎÞ·¨Á¬½ÓÉÏ£¿
·þÎñÊÇ·ñ¿ªÆô£¿
¶Ë¿ÚÊÇ·ñ´ò¿ª£¿
Ó¦¸ÃÊǰ²×°ÎÊÌâ°É£¡£¡£¡
ûÓдíÎóÌáʾÂð£¿
ÔÚ¡°ÅäÖùÜÀíÆ÷¡±ÆôÓÃÁË¡°¹²ÏíÄڴ桱ÐÒéÁËÂð£¿
¹À¼ÆÊǹ²ÏíÄÚ´æÃ»ÓÐÆôÓ㬿ÉÒÔ´ò¿ªSQL serverÅäÖùÜÀíÆ÷²é¿´Ò»Ï¡£
°²×°°æ±¾²»¶Ô¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÎÒÔÚ±¾»úÉϰ²×°µÄsqlserver2008¾Í½ø²»È¥ÁË¡£Ôõô½â¾öÄØ£¿
Ìáʾʲôѽ,
¼ì²éһϠSQL Server µÄ´íÎóÈÕÖ¾£¨Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG£©ÖÐÓÐʲô´íÎóÏûÏ¢¡£
http://yk216.blog.51cto.com/252445/119131
ÏȲο¼ÉÏÃæµÄ,
²éÒ»ÏÂϵͳÈÕÖ¾,¿´É¶´íÎóÀ´×Å
SQL code:
»»¸ö°²×°ÅÌ£¬ÖØÐ°²×°Ò»ÏÂ...
ͨ¹ý»¹Ôϵͳ½â¾öÁË£¬µ±È»Ò»Ð©Êý¾Ý¿âÒ²¶ªÊ§ÁË¡£
Ïà¹ØÎÊ´ð£º
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃ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ʧ°Ü¡£
Ϊʲô» ......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
asp.net²éѯSqlServer2005ÖÐtextÀàÐÍÊý¾Ý³£³£¶ªÊ§£¬Ìí¼ÓÊý¾Ýµ½textÀàÐÍÖп´Ò³ÃæÉÏ¿ÉÒÔ£¬ÓиöÒ»Á½Ì죬¾Í¿ÉÄÜ»á³öÏÖtext
Êý¾Ý´æµÄÊý¾ÝȱÉÙÒ»²¿·Ö£¬ÎªÊ²Ã´°¡£¡Çë´ó¼Ò°ï°ïæ°¡£¡
Óöþ½øÖÆ´æ·ÅËãÁË
²»Ã÷°×£¬ÄÜ×Ðϸ ......