Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

·ÀÖ¹SQL×¢Èë

Ò»¡¢Ê¹ÓòÎÊý»¯ÊäÈë¡£´æ´¢¹ý³ÌÀᄀÁ¿±ÜÃâÓï¾äÆ´½Ó¡£
¶þ¡¢¶ÔÓÚһЩÊý¾Ý¿â£¬±ØÐëÉèÖÃȨÏÞ£¬ÉõÖÁÉèÖõ½×ֶΡ£
Èý¡¢Ê¼ÖÕͨ¹ý²âÊÔÀàÐÍ¡¢³¤¶È¡¢¸ñʽºÍ·¶Î§À´ÑéÖ¤Óû§ÊäÈë¡£
ËÄ¡¢¹ýÂËÃô¸Ð×Ö·û¡£
Function ReplaceStr(Str)
Str=Trim(Str)
Str=Replace(Str,"'","'")
Str=Replace(Str,";",";")
Str=Rep ......

sql serverÒ»¸öʹÓÃÓαêµÄʵÀý

--´´½¨Óαê
DECLARE Cursor1 CURSOR FOR
SELECT NODE_NO,NODE_VALUE,SUM(RESALE_SUM-RESALERETU_SUM+SALE_SUM-SALERETU_SUM) sale_sum,
SUM(STORE_SUM) sum_store,SUM(STORE_SUM) store_sum,
sum(RESALE_PROFIT-RESALERETU_PROFIT+SALE_PROFIT-SALERETU_PROFIT-ADJUST_PROFIT) sale_profit
from ......

SQLÌæ»»Ö¸¶¨ÁÐ×Ö·û´®

 -- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comm ......

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


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

sqlÖ®×óÁ¬½Ó¡¢ÓÒÁ¬½Ó¡¢È«Á¬½Ó

ÎÒÃǽéÉÜÁ˱íÁ¬½Ó£¬¸üÈ·ÇеÄ˵ÊÇinner joins內Á¬½Ó¡£內Á¬½Ó½öÑ¡³öÁ½ÕűíÖл¥ÏàÆ¥ÅäµÄ¼Ç¼£®Òò´Ë£¬Õâ»áµ¼ÖÂÓÐʱÎÒÃÇÐèÒªµÄ¼Ç¼ûÓаüº¬½øÀ´¡£
Ϊ¸üºÃµÄÀí½âÕâ¸ö¸ÅÄÎÒÃǽéÉÜÁ½¸ö±í×÷ÑÝʾ¡£ËÕ¸ñÀ¼Òé»áÖеÄÕþµ³±í(party)ºÍÒéÔ±±í(msp)¡£
 
party(Code,Name,Leader)
Code: Õþµ³´úÂë
Name: Õþµ³Ãû³Æ
Le ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ