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

SQLÎļÓÃÜ

use Tempdb
go
if object_ID('fn_ACITEncryption') is not null
drop function fn_ACITEncryption
go
create function fn_ACITEncryption
(
@Str nvarchar(4000),--¼ÓÃܵÄ×Ö·û´®
@Flag bit=1,--1¡¢¼ÓÃÜ 0¡¢½âÃÜ
@Key nvarchar(50)--ÃÜÎÄ
)
returns nvarchar(4000)--這Àï¿É轉換³É¶þ進ÖÆ
with Encryption
as
begin
Declare @LenStr int,@i int,@Str2 nvarchar(4000),@Split nvarchar(2),@LenKey int
select @Str=@Str+'A',@LenStr=len(@Str),@i=1,@Str2='',@LenKey=Len(@Key+'A')-1
while @i<@LenStr
select @Split=substring(@Str,@i,1),
@Split=nchar((unicode(@Split)+case @Flag when 1 then unicode(substring(@Key+'A',@i%@LenKey+1,1))-1
when 0 then 65535-unicode(substring(@Key+'A',@i%@LenKey+1,1))
else 0 end)%65535+cast(@Flag as int)),
@Str2=@Str2+@Split,@i=@i+1
return @Str2
end
go
select dbo.fn_ACITEncryption(N'Roy',1,'123') as ¼ÓÃܺó×Ö·û´®
/*
¼ÓÃܺó×Ö·û´®
------------------------------
㢻
(1 個資ÁÏÁÐÊܵ½Ó°響)
*/
select dbo.fn_ACITEncryption(N'„¢ª',0,'123') as ½âÃܺó×Ö·û´®
/*
½âÃܺó×Ö·û´®
--------------------------
Roy
(1 個資ÁÏÁÐÊܵ½Ó°響)
*/


Ïà¹ØÎĵµ£º

Interbase/FirebirdµÄSQLÓï·¨(ÊÕ²Ø)

×î½üÔÚȺÀï´ó¼ÒͻȻÌÖÂÛÏÂfb(firebird)À´ÁË£¬ºÇ£¬¿´ÁËһЩ×ÊÁÏ£¬Í»È»·¢¾õÕâ¸ö¶«Î÷Ò²ÂùºÃÍæµÄ£¬ÓÚÊÇ¿ªÊ¼´óÁ¿µÄ²éÕÒÓйصÄ×ÊÁÏ£¬ÏÂÃæÊÇÒ»
ЩfbϵÄsqlд·¨£¬×ª×ÔÍøÉÏ£¬¸÷λÅóÓѽ«¾ÍЩ¿´¿´°É£¬¹ý¼¸ÌìżÕûÀíºÃ.netÏÂʹÓÃfbµÄdemoÉÏÀ´¸ø´ó¼Ò¿´¿´°É£¬µ½Ê±Ö§³ÖÖ§³Ö°É£¬ºÇºÇ
Ò»¡¢·Öҳд·¨Ð¡Àý£º
  SELECT FIRST
10 templa ......

MyEclipse5.5ÏÂÁ¬½ÓSql Server 2008µÄ·½·¨

ÏÂÃæÊÇÖ¸µ¼Îĵµ¡£Çë¸ú×ÅÒ»²½²½µÄ×ö¡£¾ÍÄܳɹ¦Á¬½ÓÉÏsql server 2008
 
javaÖÐÁ¬½Ósql server 2008µÄ×¢ÒâÊÂÏ
2000£¬2005µÄÊý¾Ý¿âÇý¶¯ÀàµÄд·¨ÊÇ£º
com.microsoft.jdbc.sqlserver.SQLServerDriver
URLµÄд·¨ÊÇ£º¼ÙÉèÊý¾Ý¿âÊÇnews
jdbc:microsoft:sqlserver://localhost:1433;databaseName=news
 
µ«ÊÇ20 ......

SQL SERVER¿ç·þÎñÆ÷²éѯ(SQL SERVER DBLINK)

--¿ç·þÎñÆ÷²éѯÈçÏ£º
SELECT a.*,b.stor_Name
from OPENROWSET('MSDASQL',
   'DRIVER={SQL Server};SERVER=tom;UID=sa;PWD=123',
   pubs.dbo.authors) AS a,stores b
ORDER BY a.au_lname, a.au_fname
--ÆäÖУ¬tomΪԶ³Ì·þÎñÆ÷Ãû£¬stores ÊDZ¾»úÊý¾Ý¿âpubsÖеıí
--ÐèҪעÒâµÄÊÇÈô¶þ¸ö±íÖÐµÄ ......

pl/sql±¨ora 12154£ºTNS:ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó·ûÎÊÌâ

½â¾ö·½·¨Ò»
ÔÚoraDb10g_home->ÅäÖúÍÒÆÖ²¹¤¾ß->net Manager
      ÔÚ±¾µØÖÐн¨Ò»¸ö·þÎñÃüÃû
Õâ¸öÍøÂç·þÎñÃû¾ÍÊǵǽʱµÄÊý¾Ý¿âÃû
Íê³ÉÕâЩ²Ù×÷ºó£¬Ñ¡Ôñ²Ëµ¥ÖÐÎļþ->±£´æÍøÂçÅäÖþÍokÁË¡£
½â¾ö·½·¨¶þ
´ò¿ª°²×°Ä¿Â¼Ï·þÎñÆ÷¶ËµÄtnsnames.ora£¬±ÈÈçÎÒµÄÍêÕûĿ¼ÊÇE:\oracle\product\ ......

sql serverÇå³ýÈÕÖ¾

1: ɾ³ýLOG (ɾ³ýlogÎļþ£¬¸½¼Óʱ×Ô¶¯Öؽ¨logÎļþ£¬ÒÔ´Ë·½Ê½À´Çå¿ÕÈÕÖ¾)
    1) ·ÖÀëÊý¾Ý¿â  ÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾·ÖÀëÊý¾Ý¿â
    2) ɾ³ýLOGÎļþ
    3) ¸½¼ÓÊý¾Ý¿â  ÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾¸½¼ÓÊý¾Ý¿â
´Ë·¨Éú³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ