Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çó½Ì·þÎñÆ÷É쵀 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 µ¼³ö ´óÎļþ µ½¾ÖÓòÍøÄڵĵçÄÔ

Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£

ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......

ÈçºÎÔÚÒ»¸öÏîÄ¿Àï¼ÈÁ¬½ÓSQLserverÓÖÁ¬½ÓORACLE

ÎÒÒ»¸öÏîÄ¿ÀïÒªÁ¬½ÓSQLserverºÍORACLEÁ½¸öÊý¾Ý¿â£¬
·â×°ÀàÀïÃæÓõÄÊÇusing System.Data.OleDb;  £¨±¾ÈËÓõÄÊÇC#£©
ÏëÄDzÙ×÷ÕâÁ½¸öÊý¾Ý¿âµÄÀà·â×°ÔÚÒ»Æ𣬠ÈçºÎ×öÄØ£¿  ÓÐûÄÄλÓÐдºÃÁ˵ģ¿
Óù¤³ ......

sqlserver ´æ´¢¹ý³ÌÈçºÎ¶¯Ì¬µÄÉùÃ÷ ±äÁ¿

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°²×°³ÌÐòÒâÍâʧ°Ü¡£

SQL Server °²×°³ÌÐòÒâÍâʧ°Ü¡£ÓйØÏêϸÐÅÏ¢£¬Çë²é¿´....../Summary.txt ÖеݲװժҪÈÕÖ¾Îļþ¡£
ÀïÃæµÄÄÚÈÝÊǺÃÏñûʲô¿É¿´µÄ£¬¾ÍдÁËһЩÐÅÏ¢£¬Ã»Ð´Ô­Òò¡£¶øÇÒÎÒ×°µÄÊǹÙÍøÏÂÔصÄExpress°æ£¬»ù±¾Éϲ»Ó¦¸Ã³öÏÖÊ ......

sqlserverÖбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈµÄº¬Òå

sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É

identity?ɶÒâ˼£¿

IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ