ÏîÄ¿Æô¶¯ SQLServer±¨´í
ÔÚÏîÄ¿Æô¶¯µÄʱºò SQLServer±¨´íÁË
ϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ
£ºMicrosoft.DataTransformationServices.VsIntegration
²»ÖªµÀʲôÔÒò µÈ´ý¸ßÊÖ½â´ð ¼±ÓÃ
´óÏÀÃÇ Çë¿ìÀ´½â´ð ¼±ÓÃ
ÄÇÇëÎÊÏÂSQLServerÓÐûÓÐ×Ô´øµÄ Îļþ»Ö¸´¹¤¾ß£¿£¿£¿
ûÓÐ ÓùâÅÌÐÞ¸´ºÜ¿ìµÄ
Õâ¸ö±¨´íÊÇÒòΪÎļþÆÆ»µÁËÂ𣿣¿£¿
Á˽âÁË Ð»Ð»
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃ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Öж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
һ̨SqlServer·þÎñÆ÷ winxp
һ̨oracle·þÎñÆ÷ windows 2003
ÏëÔÚoracle·þÎñÆ÷ÀûÓÃ͸Ã÷Íø¹ØÁ¬½Óµ½SqlServer¡£
ÅäÖÃ͸Ã÷Íø¹ØµÄ²ÎÊýÎļþinitXXXXX.oraµÄʱºò£¬
1¡¢ÉèÖà HS_FDS_TRANSA ......