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

Æ´½ÓSQLÓï¾äµÄÎÊÌâ

SQL code:

declare @topCount int
select @topCount=10

declare @sql nvarchar(400)

set @sql=N'select top @topCount * from tb_company'
exec sp_executesql @sql





Incorrect syntax near '@topCount'.

Õâ¸öÎÊÌâÒªÔõô½â¾ö
Êä³ö²ÎÊýÐÎʽ
ÓÃSP_EXECUTESQLÖ´ÐÐ


SQL code:
declare @topCount int
select @topCount=10

declare @sql nvarchar(400)

set @sql=N'select top '+@topCount+' * from tb_company'
exec sp_executesql @sql


ÒýÓÃ
Êä³ö²ÎÊýÐÎʽ
ÓÃSP_EXECUTESQLÖ´ÐÐ

Ū´í

SQL code:
declare @topCount int
select @topCount=10

declare @sql nvarchar(400)

set @sql='select top '+@topCount+' * from tb_company'
exec (@sql)



SQL code:
set @sql=N'select top '+@topCount+' * from tb_company'


ÒýÓÃ
SQL codedeclare@topCountintselect@topCount=10declare@sqlnvarchar(400)set@sql=N'select top +ltrim(@topCount)+'*from tb_compa


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

sql´ïÈËÈ룬ÇóÒ»¾äsql£¬»òÕ߸ø³öÏàÓ¦µÄ½â¾ö·½°¸



±ía

Ïß·´úÂë Ïß·Ãû³Æ  Main_ID 
cir11    cirA        1
cir21    cirB        1
cir13    ......

¹ØÓÚDelphiʹÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿âµÄÎÊÌâ

СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ