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

SQlµÄexecute Óësp_executesql¡¡

SQLÓï¾äÀàËÆstring.Format()×é×°±äÁ¿µÄʹÓá£
Ò»°ãÀ´Ëµ£¬ÎÒÃÇ»áÔÚ³ÌÐòÔËÐÐÆÚ¼ä½«ËùÒªÔËÐеÄÃüÁîÓï¾ä×éºÏ³ÉÒ»¸ö×Ö·û´®£¬È»ºóʹÓÃEXECUTEÃüÁî»òϵͳ´æ´¢¹ý³Ì
@0sp_executesqlÀ´ÔËÐС£½ñÌ죬ÎÒÃǽ«À´Ïêϸ̽ÌÖÕâÁ½ÖÖ·½·¨¸÷×ÔµÄÓÅÁӵ㡣
(Ò») ʹÓÃEXECUTEÃüÁîÔËÐÐÃüÁî×Ö·û´®
ҪʹÓÃEXECUTEÃüÁîÀ´ÔËÐÐÒ»¸öÃüÁî×Ö·û´®µÄÓï·¨ÈçÏ£º
EXEC[UTE] ({@string_variable|[N] 'stql_string'} [+...n])
´ÓÓï·¨¿´³ö£¬¿ÉÒÔÏȽ«°üº¬ËùÒªÔËÐеÄÃüÁîµÄ×Ö·û´®¸³¸øÒ»¸ö¾Ö²¿±äÁ¿@string_variable£¬ÔÙʹÓÃEXECUTEÃüÁîÀ´ÔËÐУ¬»òÊÇÖ±½ÓʹÓÃEXECUTEÃüÁîÈ¥ÔËÐÐÒ»¸ö°üº¬ËùÒªÔËÐеÄÃüÁîÓï¾äµÄ×Ö·û´®¡£´ËÍ⣬ÄúÒ²¿ÉÒÔ½«¶à¸ö°üº¬ËùÒªÔËÐеÄÃüÁîÓï¾äµÄ×Ö·û´®Ïà¼ÓÔÚÒ»Æð£¬ÔÙ½»¸øEXECUTEÃüÁîÀ´Ò»´ÎÔËÐС£
ÔÚʹÓÃEXECUTEÃüÁîʱ±ØÐë×¢ÒâÒÔϼ¸µã£º
a¡¢ÔÚEXECUTEÃüÁîÖбØÐ뽫ÃüÁî×Ö·û´®°üº¬ÔÚÒ»¶ÔСÀ¨ºÅÖУ»
b¡¢¾Ö²¿±äÁ¿@string_variable¿ÉÒÔÊÇÊý¾ÝÀàÐÍchar¡¢varchar¡¢nchar»ònvarchar¡£Èç¹ûÄúÔÚ'stql_string'֮ǰ¼ÓÉÏÁË
´óдµÄN£¬´Ëʱ¸Ã×Ö·û´®½«±»½âÊÍΪnvarcharÊý¾ÝÀàÐÍ£»
½»¸øEXECUTEÃüÁîÔËÐеÄÃüÁî×Ö·û´®±ØÐëÈ«²¿ÊÇÓÉ×Ö·ûÊý¾Ý×é³É£¬Ò²¾ÍÊÇ˵Äú±ØÐë×ÔÐн«ËùÓеÄÊýÖµÊý¾Ýת»»³É×Ö·ûÊý¾Ý£»
d¡¢EXECUTEÃüÁîÔÊÐíÒÔǶÌ×·½Ê½Ê¹Óã»
e¡¢EXECUTEÃüÁî¿ÉÒÔʹÓÃǰËĸö×Ö·ûµÄËõд·½Ê½£¬¼´EXECUTEÓëEXEC¶¼ÊÇÕýÈ·µÄд·¨¡£
¾ÙÀýÈçÏ£º
declare @DBName varchar(20),
@Tbname varchar(20),
@SQLString1 varchar(100),
@SQLString2 varchar(100)
set @DBName='Northwind'
set @Tbname='Customers'
×éºÏ³öËùÐèÒªµÄÃüÁî×Ö·û´®
set @SQLString1='USE'+@DBName+char(13) --char(13)»»ÐÐ
×éºÏ³öËùÐèÒªµÄÃüÁî×Ö·û´®
set @SQLString2='select * from'+@Tbname
½«ÃüÁî×Ö·û´®°üº¬ÔÚÒ»¶ÔСÀ¨ºÅÖк󽻸øEXECÃüÁîÔËÐÐ
exec(@SQLString1+@SQLString2)
(¶þ) ʹÓÃϵͳ´æ´¢¹ý³Ìsp_executesqlÔËÐÐUnicodeÃüÁî×Ö·û´®
Óï·¨ÈçÏ£º
sp_executesql [@stmt=] stmt
{,[@params=]N'@parameter_namedata_type [,...n]'}
{,[@param1=] 'value' [,...n]}
 
˵Ã÷£º±ØÐëÏȽ«¸÷¸ö°üº¬ËùÒªÔËÐеÄÃüÁîÓï¾äµÄUnicode×Ö·û´®Ïà¼ÓÔÚÒ»Æð£¬ÔÙ½»¸øÏµÍ³´æ´¢¹ý³Ìsp_executesqlÀ´ÔËÐУ¬¶ø²»ÄÜÔÚsp_executesqlµÄÓï¾äÖÐÀ´Ïà¼Ó¸÷¸öÃüÁî×Ö·û´®¡£
¾ÙÀýÈçÏ£º
declare @DBName nvarchar(20),
@Tbname nvarchar(20),
@SQLString nvarchar(500)
set @DBName=N'Northwind'
set @Tbname=N'Customers'
set @SQLString


Ïà¹ØÎĵµ£º

PL/SQL developerÔ¶³Ì·ÃÎÊÊý¾Ý¿âÅäÖ÷½·¨

ʹÓÃPL/SQL developerÔ¶³Ì·ÃÎÊoracleÊý¾Ý¿âʱ£¬Ê×ÏÈҪȷ¶¨±¾»úÖÐ×°ÓÐoracle¿Í»§¶Ë¡£Ä¿Ç°»¹²»ÖªµÀÄÄÀïµ¥¶ÀµÄoracle¿Í»§¶Ë°²×°°ü¡££¨ÒòΪÎÒÓõÄÊÇoracle10g£¬oracle10g°²×°µÄ¹ý³ÌÖÐûÓÐÌØ¶¨µÄ¿Í»§¶ËÑ¡ÏËùÒÔÎÒÒ»°ã¶¼ÊÇÔÚ±¾»úÓð²×°oracleËùÓй¦ÄÜ£©
ÔÚ±¾»ú°²×°ºÃoracle¿Í»§¶Ëºó£¬ÎÒÃÇÔÚ±¾»ú(¼´¿Í»§¶Ë)µÄoracleµÄ°²×°Ä¿Â¼Ï ......

½â¾ö°²×°SQL Server2000 Îļþ¹ÒÆð

      1.²»ÓÃÍ˳öSQL2000°²×°³ÌÐò,Ö±½ÓÇл»µ½×ÀÃæ.
¡¡¡¡2.´ò¿ª×¢²á±í±à¼­Æ÷£¨ÔÚ“ÔËÐДÖÐÇÃÈë“regedit”Ö®ºó»Ø³µ¼´¿É£©£¬¶¨Î»µ½×¢²á±íµÄHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager½Úµã.
¡¡¡¡3.µ¥»÷“Session Manager”Õâ¸ö½Úµã£¬ ......

PL/SQL¿ª·¢

bulk collectÊÇ¿ÉÒÔ¿´×öÊÇÒ»ÖÖÅú»ñÈ¡µÄ·½Ê½£¬ÔÚÎÒÃǵÄplsqlµÄ´úÂë¶ÎÀï¾­³£×÷ΪintoµÄÀ©Õ¹À´Ê¹Ó᣶ÔÓÚselect id into v from .... ÊÇÒ»¸ö³£ÓõÄÓ÷¨¡£²»¹ýÕâÀïÖ»ÄÜÊÇ·µ»Øµ¥Ìõ¼Ç¼µÄʱºò£¬²ÅÄÜʹÓã¬Èç¹ûÊÇÓжàÌõ¼Ç¼ÎÒÃǾͲ»ÄÜÓÃÕâÑùµÄ·½Ê½£¬¶øÊÇʹÓÃfetchºÍÑ­»·µÄ·½Ê½£¬²»½öʹÓÃÂé·³£¬¶øÇÒÐÔÄÜÒ²µ×Ï£¬ÕâʱÎÒÃǵÄbulk coll ......

SQL Server 2005 EXCEPTºÍINTERSECTÔËËã·û


--> Title  : SQL Server 2005EXCEPTºÍINTERSECTÔËËã·û
--> Author : wufeng4552
--> Date   : 2009-10-30
 
(Ò»)¸ÅÄî
EXCEPTºÍINTERSECTÔËËã·ûʹÄú¿ÉÒԱȽÏÁ½¸ö»ò¶à¸öSELECTÓï¾äµÄ½á¹û²¢·µ»Ø·ÇÖØ¸´Öµ¡£
(¶þ)區別
EXCEPTÔËËã·û·µ»ØÓÉEXCEPTÔËËã·û×ó²àµÄ²éѯ·µ»Ø¡¢¶øÓÖ² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ