Çó½Ì·þÎñÆ÷É쵀 sqlserverÊý¾Ý¿âµÄ±¸·ÝºÍ»¹Ô
¼ÙÉèÎÒµÄÊý¾Ý¿âÊÇ·ÅÔÚµçÄÔAÀ¶øÍøÕ¾·ÅÔÚµçÄÔBÀÄÇÎÒÏÖÔÚÒªÊÇÏ뱸·ÝµçÄÔAÉϵÄÊý¾Ý¿âµ½µçÄÔBµÄ´ÅÅÌÀÎÒ¸ÃÔõô×ö£¿Ï£Íû´ó¼Ò¸ø°ï°ï棬×îºÃÄܸø¸ödemo¡£ÎÒÓÊÏäÕ˺ţº952378159@qq.com ÏÈлл¸÷λÁË°¡£¡
ÓкܶàÖÖ·½·¨È磺
1. ÓÃSQLMD object backup your A.DB to a bak file
2. Copy bak file to B.directory
лл´ó¼ÒÁË°¡
Ïà¹ØÎÊ´ð£º
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
ÎÒÒ»¸öÏîÄ¿ÀïÒªÁ¬½ÓSQLserverºÍORACLEÁ½¸öÊý¾Ý¿â£¬
·â×°ÀàÀïÃæÓõÄÊÇusing System.Data.OleDb; £¨±¾ÈËÓõÄÊÇC#£©
ÏëÄDzÙ×÷ÕâÁ½¸öÊý¾Ý¿âµÄÀà·â×°ÔÚÒ»Æ𣬠ÈçºÎ×öÄØ£¿ ÓÐûÄÄλÓÐдºÃÁ˵ģ¿
Óù¤³ ......
create procedure test
as
declare @var_0 varchar(100)
declare @cc int
set @cc=0
exec('select @var_'+@cc +'=fullName from contact')
go
exec test
......
SQL Server °²×°³ÌÐòÒâÍâʧ°Ü¡£ÓйØÏêϸÐÅÏ¢£¬Çë²é¿´....../Summary.txt ÖеݲװժҪÈÕÖ¾Îļþ¡£
ÀïÃæµÄÄÚÈÝÊǺÃÏñûʲô¿É¿´µÄ£¬¾ÍдÁËһЩÐÅÏ¢£¬Ã»Ð´ÔÒò¡£¶øÇÒÎÒ×°µÄÊǹÙÍøÏÂÔصÄExpress°æ£¬»ù±¾Éϲ»Ó¦¸Ã³öÏÖÊ ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......