±È½ÏÁ½¸öSQLµÄÖ´ÐÐʱ¼ä
±È½ÏÁ½¸öSQLµÄÖ´ÐÐʱ¼ä
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PROC_SQL_COMP]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PROC_SQL_COMP]
GO
/*--²âÊÔÁ½×éSQLµÄƽ¾ùʱ¼ä
ÀûÓÃosql.exeÀ´²âÊÔÁ½×é SQL Óï¾äµÄÖ´ÐÐʱ¼ä
²âÊԵĴ洢¹ý³ÌÖÐ,µ÷ÓÃÁËÊÂÎñ´¦Àí,ËùÒÔÈç¹û²âÊÔµÄSQLÓï¾äÓÐÊý¾ÝÐÞ¸ÄÐÐΪ
»áÔÚµ÷ÓýáÊøºó×Ô¶¯»Ø¹öÊÂÎñ,È·±£²âÊÔ²»»áÐÞ¸ÄÊý¾Ý
ÒÑÖªµÄÎÊÌâ:
1.ÓÉÓÚ osql µ÷Óò»ÔÊÐíʹÓöàÐÐ,ËùÒÔ´æ´¢¹ý³ÌÖлá°Ñ»Ø³µ»»ÐÐÌæ»»³É¿Õ¸ñ
¶ÔÓÚ SQL ×Ö·û´®ÖеĻسµ»»ÐÐ,Ò»Ñù»á±»Ìæ»»,ËùÒÔ¶ÔÓÚ×Ö·û´®Öаüº¬»Ø
³µ»»ÐÐµÄ SQL Óï¾ä,¿ÉÄÜ»á²úÉúÎÊÌâ,³ý·Ç»Ø³µ»»Ðв»¶Ô SQL Óï¾ä²úÉúÓ°Ïì
2.ÓÉÓÚÊǵ÷Óà xp_cmdshell À´Ö´ÐÐ osql,ËùÒÔÒªÇóÓÐϵͳ¹ÜÀíÔ±µÄȨÏÞ(±ÈÈçsa)
3.µ÷Óà osql ʹÓÃÁËwindowsÉí·ÝÑéÖ¤,ÕâÑùÊ¡È¥ÁËÖ¸¶¨Óû§Ãû¼°ÃÜÂëµÄÂé·³
µ«Èç¹ûÄãµÄ sql server ½ûÓÃÁËwindowsÉí·ÝÑéÖ¤,ÔòÐèÒªÐ޸Ĵ洢¹ý³ÌµÄ osql µ÷ÓÃ
--×Þ½¨ 2004.08(ÒýÓÃÇë±£Áô´ËÐÅÏ¢)--*/
/*--µ÷ÓÃʾÀý
exec dbo.PROC_SQL_COMP
'select top 1 * from sysobjects a,sysobjects b',
'select re=''1''
union all select 2'
--*/
create proc dbo.PROC_SQL_COMP
@sql1 varchar(7000), --²âÊԵĵÚÒ»¸ösqlÓï¾ä
@sql2 varchar(7000), --²âÊԵĵڶþ¸ösqlÓï¾ä
@t int=3 --²âÊÔ´ÎÊý
as
set nocount on
declare @s1 varchar(8000),@s2 varchar(8000),@tt varchar(20),@head varchar(8000)
declare @tb sysname
set @tb='tempdb.dbo.[temp_'+cast(newid() as varchar(36))+']'
exec('create table '+@tb+'(id int identity(0,1),m int)')
select @s1=replace(replace(@sql1,'''',''''''''''),char(13)+char(10),' ')
,@s2=replace(replace(@sql2,'''',''''''''''),char(13)+char(10),' ')
,@tt=cast(@t as varchar)
,@head='exec master..xp_cmdshell ''osql /E /d"'+db_name()+'"'
--ʹÓÃÁËwindowsÉí·ÝÑéÖ¤,Èç¹û²»Ö§³Ö,Ôò¸Ä /E Ϊ /U"sa" /P"ÃÜÂë"
exec(@head+' /Q"set xact_abort on;declare @i int,@a datetime;set @i=0;while @i<'
+@tt+' begin select @i=@i+1,@a=getdate();begin tran;exec('''''+@s1
Ïà¹ØÎĵµ£º
½éÉÜ
ÎÒÃÇÒ»ÆðÀ´×ö¸öʾÀý£¬ÔÚ.NETÖÐн¨Ò»¸öÀ࣬²¢ÔÚÕâ¸öÀàÀïн¨Ò»¸ö·½·¨£¬È»ºóÔÚSQL ServerÖе÷ÓÃÕâ¸ö·½·¨¡£°´ÕÕ΢ÈíËùÊö£¬Í¨¹ýËÞÖ÷ Microsoft .NET Framework 2.0 ¹«¹²ÓïÑÔÔËÐпâ (CLR)£¬SQL Server 2005ÏÔÖøµØÔöÇ¿ÁËÊý¾Ý¿â±à³ÌÄ£ÐÍ¡£ ÕâʹµÃ¿ª·¢ÈËÔ±¿ÉÒÔÓÃÈκÎCLRÓïÑÔ£¨ÈçC#¡¢VB.NET»òC++µÈ£©À´Ð´´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ºÍÓ ......
Ò»¡¢»ù´¡
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¡¢Ëµ ......
SQL*LOADERÊÇORACLEµÄÊý¾Ý¼ÓÔع¤¾ß£¬Í¨³£ÓÃÀ´½«²Ù×÷ϵͳÎļþǨÒƵ½ORACLEÊý¾Ý¿âÖС£SQL*LOADERÊÇ´óÐÍÊý¾Ý
²Ö¿âÑ¡ÔñʹÓõļÓÔØ·½·¨¡£
¡¡¡¡ÔÚNTÏ£¬SQL*LOADERµÄÃüÁîΪSQLLDR£¬ÔÚUNIXÏÂÒ»°ãΪsqlldr/sqlload¡£
¡¡¡¡ÈçÖ´ÐУºd:\oracle>sqlldr
SQL*Loader: Release 8.1.6.0.0 - Production on ÐÇÆÚ¶þ 1ÔÂ 8 11:06:42 2 ......
×î½ü¼¸ÖÜÒ»Ö±ÔÚ½øÐÐÊý¾Ý¿âÅàѵ£¬ÀÏʦ¾«Õ¿µÄ¼¼ÊõºÍÉú¶¯µÄ½²½âʹÎÒÊÜÒæ·Ëdz¡£ÎªÁËÈøü¶àµÄÐÂÊÖÊÜÒ棬ÎÒ³é¿Õ°ÑSQLÓï¾äÓÅ»¯²¿·Ö½øÐÐÁËÕûÀí£¬Ï£Íû´ó¼ÒÒ»Æð½ø²½¡£¡¡¡¡
¡¡¡¡Ò»¡¢²Ù×÷·ûÓÅ»¯¡¡¡¡
¡¡1¡¢IN ²Ù×÷·û ¡¡¡¡
¡¡¡¡ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊÇ±È½Ï ......