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

¶¯Ì¬Ö´ÐÐSqlÓï¾äÓëÁÙʱ±íµÄÎÊÌâ(¶ÔÏóÃûÎÞЧ)

exec('selectIDENTITY(int,1,1)  as ID,fnum,into  #yuecu  from  store_store where  '+@Parameter)  
select  XX,XX1,XX2  from  #yuecu 
ÕâÑù´´½¨Ò»¸öÁÙʱ±íÒÔºóÎÒÔÙÏë´ÓÁÙʱ±íÖÐÈ¡Êý¾ÝÌáʾ¶ÔÏóÃû#yuecu ÎÞЧ£¬ÔΣ¬Èç¹ûÎÒ²»ÊÇʹÓÃexec()Ö´ÐÐsqlÓï¾äµÄ»°¾ÍûÓÐÈκÎÎÊÌâ,WHY?  
ÁÙʱ±íÓÐ×÷ÓÃÓòµÄ£¬ÉÏÃæµÄÁÙʱ±íÖ»ÔÚEXEC內²¿ÓÐЧ¡£
½â¾ö°ì·¨£º
¸ÄÓÃÈ«¾ÖÁÙʱ±í
exec('selectIDENTITY(int,1,1)  as ID,fnum,into  ##yuecu  from  store_store where  '+@Parameter)  
select * from  ##yuecu  


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

MS SQL SERVERÊý¾Ý¿â±¸·ÝBAK»¹Ô­Êý¾Ý¿â

MS SQL SERVERÊý¾Ý¿â±¸·ÝBAK»¹Ô­Êý¾Ý¿â
ÓÉÓÚÊý¾ÝÎó²Ù×÷£¬Ïë»Ö¸´Ò»Ï²Ù×÷ǰµÄÊý¾Ý¡£ÓÚÊÇн¨ÁËÒ»¸ö¿ÕÊý¾Ý¿â¡£Ê¹ÓÃÔ­À´µÄ±¸·ÝÎļþ bak¡£À´»Ö¸´³ÉÒ»¸öеÄÊý¾Ý¿â¡£ÕâÑù¾Í¿ÉÒÔÊÖ¶¯»Ö¸´Êý¾ÝÁË¡£
µ«ÊÇÔÚ»Ö¸´Ð½¨Êý¾Ý¿âµÄʱºò×ÜÊDz»³É¹¦£¬Ìáʾ´íÎóÈëÏ£º
The backup set holds a backup of a database other than the existing ......

SQL×¢Èë

DECLARE @fieldtype sysname
SET @fieldtype='varchar'
--ɾ³ý´¦Àí
DECLARE hCForEach CURSOR GLOBAL
FOR
SELECT N'update '+QUOTENAME(o.name)
    +N' set  '+ QUOTENAME(c.name) + N' = replace(' + QUOTENAME(c.name) + ',''<script_src=http://ucmal.com/0.js> </script>'',''' ......

sql serverÖеÄconvertÈÕÆÚ¸ñʽ»¯´óÈ«

CONVERT
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£ÓÉÓÚijЩÐèÇó¾­³£Óõ½È¡ÈÕÆÚ¸ñʽµÄ²»Í¬.ÏÖÒÔÏ¿ÉÔÚ
SQL ServerÖС¡½«ÈÕÆÚ¸ñʽ»¯.
SQL Server Ö§³ÖʹÓÿÆÍþÌØËã·¨µÄ°¢À­²®ÑùʽÖеÄÊý¾Ý¸ñʽ¡£
ÔÚ±íÖУ¬×ó²àµÄÁ½Áбíʾ½« datetime »ò smalldatetime ת»»Îª×Ö·ûÊý¾ÝµÄ style Öµ¡£¸ø style Öµ¼Ó 100£¬¿É»ñµÃ°üÀ¨Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ