ÀûÓÃSQLÒƶ¯Ó²ÅÌÎļþ
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_movefile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_movefile]
GO
/*--Òƶ¯·þÎñÆ÷ÉϵÄÎļþ
²»½èÖú xp_cmdshell ,ÒòΪÕâ¸öÔÚ´ó¶àÊýʱºò¶¼±»½ûÓÃÁË
--×Þ½¨ 2004.08(ÒýÓÃÇë±£Áô´ËÐÅÏ¢)--*/
/*--µ÷ÓÃʾÀý
exec p_movefile 'd:\aa.txt','c:\'
--*/
create proc p_movefile
@s_file varchar(1000), --Ô´Îļþ
@d_file varchar(1000) --Ä¿±êÎļþ
as
declare @err int,@src varchar(255),@desc varchar(255)
declare @obj int
exec @err=sp_oacreate 'Scripting.FileSystemObject',@obj out --ÔÚ Microsoft? SQL Server? ʵÀýÉÏ´´½¨ OLE ¶ÔÏóʵÀý
if @err<>0 goto lberr
exec @err=sp_oamethod @obj,'MoveFile',null,@s_file,@d_file --µ÷Óà OLE ¶ÔÏóµÄ·½·¨
if @err<>0 goto lberr
exec @err=sp_oadestroy @obj --ÊÍ·ÅÒÑ´´½¨µÄ OLE ¶ÔÏó¡£
return
lberr:
exec sp_oageterrorinfo 0,@src out,@desc out --»ñÈ¡ OLE ×Ô¶¯»¯´íÎóÐÅÏ¢¡£
select cast(@err as varbinary(4)) as ´íÎóºÅ
,@src as ´íÎóÔ´,@desc as ´íÎóÃèÊö
go
Ïà¹ØÎĵµ£º
Ò»¡¢»ù´¡
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 ͨÅä·û¿ÉÒÔÌæ´úÒ»¸ö»ò¶à¸ö×Ö·û¡£
SQL ͨÅä·û±ØÐëÓë LIKE ÔËËã·ûÒ»ÆðʹÓá£
ÔÚ SQL ÖУ¬¿ÉʹÓÃÒÔÏÂͨÅä·û£º
ͨÅä·ûÃèÊö
%
Ìæ´úÒ»¸ö»ò¶à¸ö×Ö·û
_
½öÌæ´úÒ»¸ö×Ö·û
[charlist]
×Ö·ûÁÐÖеÄÈκε¥Ò»×Ö·û
[^charlist]
»òÕß
[!charlist]
²»ÔÚ×Ö·ûÁÐÖеÄÈκε¥Ò»×Ö·û
ÔʼµÄ±í (ÓÃÔÚÀý×ÓÖ ......
Àý×Ó1) Ò»¸ö±íTable_1 ÓÐÁ½¸ö×Ö¶Î
id number£¬
name varchar2£¨7£©
& ......
Çë½Ì´ó¼ÒÒ»¸öÓйØSQL½»×¤±¨±í²éѯÎÊÌ⣬»¶Ó¸÷λָ½Ì£¡
ÎÒÏë°Ñͼ1µÄʹÓÃÐÅÏ¢£¬Ê¹ÓÃSQLÓï¾ä£¬ÊµÏÖÈçͼ2µÄ½á¹û¡£
±íÃû
ÐòºÅ
×Ö¶ÎÃû
a
1
c
a
2
d
a
3
e
a
4
f
a
5
g
b
1
h
b
2
i
b
3
j
b
4
k
b
5
l
c
1
m
c
2
n
c
3
o
c
4
p
c
5
q
ͼ1
±íÃû
ÐòºÅ
1
2
3
4
5
......
Ò»°ãÓÃBCPÔÚ´¦ÀíÕâ¸öÊÂÇ飬µ«ÓÐʱҲÐèҪһЩÌØÊâµÄ´¦Àí£¬ÒÔÏÂÊÇÉú³É±íÖеÄһЩÊý¾Ý£¬´øÓÐwhereÌõ¼þµÄÑ¡ÔñÉú³ÉÊý¾Ý£¬ÊÇÎÒÒ»¸öͬÊÂÐ޸ĵģ¬Ö±½ÓÄùýÀ´ÓÃÁË£º
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Proc proc_insert_where (@tablename varchar(256),@where varchar(256 ......