Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


лл´ó¼ÒÁ˰¡



Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

Ö±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð

sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã

²»Ã÷°×~~~

Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹Ô­Êý¾Ý¿â

Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......

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

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

sqlserver 2005 Á½Ç§ÍòÌõÊý¾ÝÐÔÄÜÔõôÑù£¿

ÈçÌâ:
sqlserver 2005 Á½Ç§ÍòÌõÊý¾ÝÐÔÄÜÔõôÑù£¿
µÃ¿´ÄãµÄÊý¾Ý½á¹¹À´,Èç¹û²éѯʱȫÊÇLIKE Ö®Àà,ÄǾÍ..

×îºÃÓÅ»¯ ²»Ëãʲô

ºÜÕý³££¬²éѯµÄʱºò¶àÓÅ»¯£¬ÐÔÄÜ»¹ÊǺܺõÄ

sqlserver 2005 Á½Ç§ÍòÌõÊý¾Ý
Ö ......

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

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

identity?ɶÒâ˼£¿

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