Çó½Ì·þÎñÆ÷É쵀 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
лл´ó¼ÒÁ˰¡
Ïà¹ØÎÊ´ð£º
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 ......
sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã
²»Ã÷°×~~~
Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹ÔÊý¾Ý¿â
Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......
ÎÒÒ»¸öÏîÄ¿ÀïÒªÁ¬½ÓSQLserverºÍORACLEÁ½¸öÊý¾Ý¿â£¬
·â×°ÀàÀïÃæÓõÄÊÇusing System.Data.OleDb; £¨±¾ÈËÓõÄÊÇC#£©
ÏëÄDzÙ×÷ÕâÁ½¸öÊý¾Ý¿âµÄÀà·â×°ÔÚÒ»Æð£¬ ÈçºÎ×öÄØ£¿ ÓÐûÄÄλÓÐдºÃÁ˵ģ¿
Óù¤³ ......
ÈçÌâ:
sqlserver 2005 Á½Ç§ÍòÌõÊý¾ÝÐÔÄÜÔõôÑù£¿
µÃ¿´ÄãµÄÊý¾Ý½á¹¹À´,Èç¹û²éѯʱȫÊÇLIKE Ö®Àà,ÄǾÍ..
×îºÃÓÅ»¯ ²»Ëãʲô
ºÜÕý³££¬²éѯµÄʱºò¶àÓÅ»¯£¬ÐÔÄÜ»¹ÊǺܺõÄ
sqlserver 2005 Á½Ç§ÍòÌõÊý¾Ý
Ö ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......