Çó½Ì·þÎñÆ÷É쵀 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
лл´ó¼ÒÁ˰¡
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿ÀïÒªÁ¬½Ó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
......
СµÜ֨װSQLServer·þÎñÆ÷£¬»¹ÔMasterÊý¾ÝÆô¶¯ºó±¨´íERROR 17750£¬ERROR 8355¡£
´íÎóÐÅÏ¢ÈçÏ£º
ERROR 17750
Could not load the DLL LEServer.dll, or one of the DLLs it references. Reason: 126(error ......
ÈçÌâ:
sqlserver 2005 Á½Ç§ÍòÌõÊý¾ÝÐÔÄÜÔõôÑù£¿
µÃ¿´ÄãµÄÊý¾Ý½á¹¹À´,Èç¹û²éѯʱȫÊÇLIKE Ö®Àà,ÄǾÍ..
×îºÃÓÅ»¯ ²»Ëãʲô
ºÜÕý³££¬²éѯµÄʱºò¶àÓÅ»¯£¬ÐÔÄÜ»¹ÊǺܺõÄ
sqlserver 2005 Á½Ç§ÍòÌõÊý¾Ý
Ö ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......