ÏîÄ¿Æô¶¯ SQLServer±¨´í
ÔÚÏîÄ¿Æô¶¯µÄʱºò SQLServer±¨´íÁË
ϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ
£ºMicrosoft.DataTransformationServices.VsIntegration
²»ÖªµÀʲôÔÒò µÈ´ý¸ßÊÖ½â´ð ¼±ÓÃ
´óÏÀÃÇ Çë¿ìÀ´½â´ð ¼±ÓÃ
ÄÇÇëÎÊÏÂSQLServerÓÐûÓÐ×Ô´øµÄ Îļþ»Ö¸´¹¤¾ß£¿£¿£¿
ûÓÐ ÓùâÅÌÐÞ¸´ºÜ¿ìµÄ
Õâ¸ö±¨´íÊÇÒòΪÎļþÆÆ»µÁËÂ𣿣¿£¿
Á˽âÁË Ð»Ð»
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
sqlserver 2005
ÏûÏ¢ 8152£¬¼¶±ð 16£¬×´Ì¬ 14£¬µÚ 1 ÐÐ
½«½Ø¶Ï×Ö·û´®»ò¶þ½øÖÆÊý¾Ý¡£
Óï¾äÒÑÖÕÖ¹¡£
ÎÒÈ·¶¨²åÈëµÄÊý¾Ý¶¼·ûºÏÒªÇó ÒòΪÎÒÔÚjspÒ³Ãæ ÓÃÏàͬµÄÊý¾ÝÌá½»³É¹¦µ½Êý¾Ý¿â ¶øÎÒÔÚÊý¾Ý¿âдinser ......
ÏÖÔÚÓÉÓÚÐÂÊÖÎó²Ù×÷£¬ÏÖÔÚֻʣÏÂÈÕÖ¾ÎļþÁË£¬ÇëÎʸßÊÖÄܲ»Äָܻ´£¬Ð»Ð»£¡
SQL code:
ÊDz»ÊÇÍêÕû»Ö¸´Ä£Ê½??
ʹÓÃLog Explorer²é¿´ºÍ»Ö¸´Êý¾Ý
Log Explorer 4.1.¿ÉÓÃÓÚSQL Server2005µÄÈÕÖ¾²é¿´¹¤¾ß
ÏÂÔØµØÖ·:
......