¡¾×ª¡¿Sql½Å±¾ÃüÁîÖ´ÐÐ
ÎÒÃÇÐèÒª¶à´ÎÔËÐÐÒ»¸öÎļþ¼ÐÏÂËùÓеÄsql½Å±¾£¨¿ÉÄÜʱtxt»òÕßsqlµÈÎı¾Îļþ£©À´¸üÐÂSchema£¬Îļþ¶àµÄʱºòÐèÒª¶à´ÎÖ´ÐУ¬ÄÇô¿ÉÒÔʹÓöàÌõÓï¾äÀ´Ö´ÐÐsql½Å±¾¡£
--ÏÂÃæµÄ²éѯÓï¾äÔÚSQL QueryÖÐÔËÐУ¬½«Ö´ÐÐd:\vssÏÂÃæµÄÖ¸¶¨sql½Å±¾£¬ÕâЩ½Å±¾µÄºó׺¶¼ÊÇtxt
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\MSSchema.txt '
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\MSSchema_030311.txt '
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\MSSchema_030416.txt'
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\MSSchema_030417.txt'
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\MSSchema_030513.txt'
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\MSSchema_030613.txt'
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\MSSchema_031010.txt'
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\MSSchema_050810.txt'
exec master..xp_cmdshell 'isql -U sa -P 123 -i d:\vss\TaxInvoice.sql'
µ±È»£¬ÎÒÃÇÍêÈ«¿ÉÒÔ²»Ê¹Óô洢¹ý³Ì£¬¶øÖ»ÊÇÔÚÒ»¸öÅú´¦ÀíÎļþupdateschema.cmdÖÐÖ´ÐÐÕâЩÃüÁî,ÏÂÃæÊÇupdateschema.cmdµÄÄÚÈÝ:
;ÏÂÃæµÄÃüÁִÐÐd:\vssÏÂÃæµÄÖ¸¶¨sql½Å±¾£º
isql -U sa -P 123 -i d:\vss\MSSchema.txt
isql -U sa -P 123 -i d:\vss\MSSchema_030311.txt
isql -U sa -P 123 -i d:\vss\MSSchema_030416.txt
isql -U sa -P 123 -i d:\vss\MSSchema_030417.txt
isql -U sa -P 123 -i d:\vss\MSSchema_030513.txt
isql -U sa -P 123 -i d:\vss\MSSchema_030613.txt
isql -U sa -P 123 -i d:\vss\MSSchema_031010.txt
isql -U sa -P 123 -i d:\vss\MSSchema_050810.txt
×¢£º
1.execÓï¾äÓÃÀ´Ö´Ðд洢¹ý³Ì,xp_cmdshellÊÇmasterÊý¾Ý¿âÖеÄÒ»¸öÀ©Õ¹´æ´¢¹ý³Ì£¬¿ÉÒÔÓÃÀ´Ö´ÐÐϵͳÃüÁîµÄ×Ö·û´®£¬
±ÈÈçexec master..xp_cmdshell 'dir *.exe'²é¿´µ±Ç°Ä¿Â¼ÏÂËùÓеÄexeÎļþ¡£
2.isqlÊÇsql serverµÄÒ»¸öʵÓù¤¾ß£¬¿ÉÒÔÀí½â³ÌÒ»¸öÍⲿ³ÌÐò£¬Èç¹ûsqlʹÓõÄĬÈÏ°²×°£¬¿ÉÒÔÔÚC:\Program Files\Microsoft SQL Server\80\Tools\BinnĿ¼ÖÐÕÒµ½Õâ¸öisql.exeÎļþ£¬isql¿ÉÒÔÓÃÀ´Ö´ÐÐTransact-SQLÓï¾ä£¬´æ´¢¹ý³Ì£¬ÒÔ¼°½Å±¾Î
Ïà¹ØÎĵµ£º
-- MySQL dump 10.10
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 5.0.22-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*! ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
±ÈÈçÔÚNorthwindÊý¾Ý¿âÖÐ
ÓÐÒ»¸ö²éѯΪ
SELECT c.CustomerId, CompanyName
from Customers c
WHERE EXISTS(
SELECT OrderID from ......
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý£¨clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý£©ºÍ·Ç¾Û¼¯Ë÷Òý£¨nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý£©¡£ÏÂÃ棬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒÃǵĺºÓï×Öµäµ ......
ÎÒÏÈÅ×שÒýÓñ:
1. ¿ª·¢ÐÔ: SQLSERVER²»ÄÜ,ORACLEÄÜ×°ÔÚUNIXÉÏ
2. ·ÖÇø±í: SQLSERVER²»Ä ......