Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql server2000ÖÐÔõô¶Ô´æ´¢¹ý³Ì½øÐмÓÃܺͽâÃÜ

 1. >>¼ÓÃÜ
from the Books Online:
Use the WITH ENCRYPTION option:
IF EXISTS (SELECT name from sysobjects
WHERE name = 'encrypt_this' AND type = 'P')
DROP PROCEDURE encrypt_this
GO
USE pubs
GO
CREATE PROCEDURE encrypt_this
WITH ENCRYPTION
AS
SELECT *
from authors
GO
EXEC sp_helptext encrypt_this
2. ¹Ø¼ü×Ö ×Ö½Ú²»ÊÜÏÞÖÆ,±ÈSQLexplorer°²È«,²é¿´ËùÓÐSYSCOMMENTSÄÚ¼ÓÃܵĴúÂë 
create PROCEDURE sp_decrypt(@objectName varchar(50))
AS
begin
set nocount on
--CSDN£ºj9988 copyright:2004.01.05
--V3.1
--ÆÆ½â×Ö½Ú²»ÊÜÏÞÖÆ£¬ÊÊÓÃÓÚSQLSERVER2000´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬´¥·¢Æ÷
--·¢ÏÖÓÐ´í£¬ÇëE_MAIL£ºCSDNj9988@tom.com
begin tran
declare @objectname1 varchar(100),@orgvarbin varbinary(8000)
declare @sql1 nvarchar(4000),@sql2 varchar(8000),@sql3 nvarchar(4000),@sql4 nvarchar(4000)
DECLARE @OrigSpText1 nvarchar(4000), @OrigSpText2 nvarchar(4000) , @OrigSpText3 nvarchar(4000), @resultsp nvarchar(4000)
declare @i int,@status int,@type varchar(10),@parentid int
declare @colid int,@n int,@q int,@j int,@k int,@encrypted int,@number int
select @type=xtype,@parentid=parent_obj from sysobjects where id=object_id(@ObjectName)
create table #temp(number int,colid int,ctext varbinary(8000),encrypted int,status int)
insert #temp SELECT number,colid,ctext,encrypted,status from syscomments WHERE id = object_id(@objectName)
select @number=max(number) from #temp
set @k=0
while @k<=@number
begin
if exists(select 1 from syscomments where id=object_id(@objectname) and number=@k)
begin
if @type='P'
set @sql1=(case when @number>1 then 'ALTER PROCEDURE '+ @objectName +';'+rtrim(@k)+' WITH ENCRYPTION AS '
else 'ALTER PROCEDURE '+ @objectName+' WITH ENCRYPTION AS '
end)
if @type='TR'
set @sql1='ALTER TRIGGER '+@objectname+' ON '+OBJECT_NAME(@parentid)+' WITH ENCRYPTION FOR INSERT AS PRINT 1 '
if @type='FN' or @type='TF' or @type='IF'
set @sql1=(case @type when 'TF' then
'ALTER FUNCTION '+ @objectName+'(@a char(1)) returns @b table(a varchar(10)) wi


Ïà¹ØÎĵµ£º

ÖÕ¼¶½â¾öSQL Server 2005 δÕý³£Ð¶ÔØ£¬ÖØÐ°²×°ÎÊÌâ

 ÔÚÐ¶ÔØVisual Studio 2008 ʱ£¬Ìí¼Ó/ɾ³ý³ÌÐò ÀïÃæÓÐÐí¶àµÄ°²×°Îļþ£¬´ËʱÈç¹ûûÓÐÏÈÐ¶ÔØSQL Server 2005 £¬
¶øÏÈÐ¶ÔØ.Net Framework£¨Ìáʾ£ºÐ¶ÔØ.net FrameworkµÄµÃ°²°æ±¾´Ó¸ßµ½µÍµÄ˳Ðò£©£¬
ÕâʱSQL Server 2005¾ÍÎÞ·¨Ð¶ÔØ,ɾ³ýProgram files ÏÂÃæµÄ Microsoft SQL Server Îļþ¼ÐҲûÓÐ×÷Óá£
ÖØÐ°²×°ÌáʾÊý¾Ý¿ ......

SQL Server 2000µÄ°²È«ÅäÖÃ

 
SQL Server 2000µÄ°²È«ÅäÖÃ
¡¡
¡¡SQL Server 2000µÄ°²È«ÅäÖÃÔÚ½øÐÐSQL Server
2000Êý¾Ý¿âµÄ°²È«ÅäÖÃ֮ǰ£¬Ê×ÏÈÄã±ØÐë¶Ô²Ù×÷ϵͳ½øÐа²È«ÅäÖ㬱£Ö¤ÄãµÄ²Ù×÷ϵͳ´¦ÓÚ°²È«×´Ì¬¡£È»ºó¶ÔÄãҪʹÓõIJÙ×÷Êý¾Ý¿âÈí¼þ£¨³ÌÐò£©½øÐбØÒªµÄ°²
È«ÉóºË£¬±ÈÈç¶ÔASP¡¢PHPµÈ½Å±¾£¬ÕâÊǺܶà»ùÓÚÊý¾Ý¿âµÄWEBÓ¦Óó£³öÏֵݲȫÒþ»¼£ ......

SQLÓï¾ä½Ì³Ì

ÔÚÕâÒ»Ò³ÖУ¬ÎÒÃÇÁгöËùÓÐÔÚÕâ¸öÍøÕ¾ÓÐÁгö SQL Ö¸ÁîµÄÓï·¨¡£ÈôÒª¸üÏ꾡µÄ˵Ã÷£¬ÇëµãѡָÁîÃû³Æ¡£
ÕâÒ»Ò³µÄÄ¿µÄÊÇÌṩһ¸ö¼ò½àµÄ SQL Óï·¨×öΪ¶ÁÕ߲ο¼Ö®Óá£ÎÒÃǽ¨ÒéÄúÏÖÔھͰ´ Control-D ½«±¾Ò³¼ÓÈëÄúµÄ¡ºÎÒµÄ×î°®¡»¡£
Select
SELECT "À¸Î»" from "±í¸ñÃû"
Distinct
SELECT DISTINCT "À¸Î»"
from "±í¸ñÃû"
Where
......

ʹÓÃSQLʱ±ØÐ뿼ÂǵÄÎå¸ö¹Ø¼üÒòËØ

 Ê¹ÓÃSQLʱ±ØÐ뿼ÂǵĹؼüÒòËØ
Ò»£¬»ñµÃ½á¹û¼¯ËùÐè·ÃÎʵÄÊý¾ÝÁ¿£¬ÔÚûÓÐÈ·¶¨Ä¿±êÈÝÁ¿Ö®Ç°£¬ºÜÄѶ϶¨²éѯִÐеÄЧÂÊ£»
¶þ£¬¶¨Òå½á¹û¼¯ËùÐèµÄ²éѯÌõ¼þ£¬Ò²¾ÍÊÇÈçºÎÏÞ¶¨½á¹û¼¯£¬ÈçºÎºÏÀíµÄʹÓÃsql×Ӿ䣻
Èý£¬½á¹û¼¯µÄ´óС£¬È¡¾öÓÚ±íµÄ´óСºÍ¹ýÂËÌõ¼þµÄϸ½Ú£¬µ«²»¶¼ÊÇÕâÑù£¬µäÐ͵ÄÇé¿öÊÇ£¬Èô¸É¸ö¶ÀÁ¢Ê¹ÓÃʱЧÂʲ»¸ßµÄÌõ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ