ÇóÒ»ÌõSQLÓï¾ä - MS-SQL Server / »ù´¡Àà
±íÃû: teacher ×ֶηֱðÓÐ ÐòºÅ£¬ÐÕÃû£¬ÄêÁ䣬ÐÔ±ð£¬ÄêÊÕÈë¡¡¡¡
ÏÖÏëÇóÒ»ÌõSQLÓï¾äÊÇ ³ýÁË"ÐòºÅ"Õâ¸ö×ֶβ»ÏÔʾ,ÆäËû×ֶξùÏÔʾµÄÓï¾ä£¬ ²¢·Ç select ÐÕÃû£¬ÄêÁ䣬ÐÔ±ð£¬ÄêÊÕÈë¡¡¡¡
from teacher ÕâÌõÓï¾ä(ÒòΪ×ֶμÙÉèÓÐ30¶à¸ö»áдËÀÈ˵Ä)лл£¡
Óö¯Ì¬SQL
SQL code:
DECLARE @s VARCHAR(8000)
SELECT @s = ISNULL(@s+',', '')+name
from syscolumns
WHERE id = OBJECT_ID('teacher')
AND name<>'ÐòºÅ'
EXEC ('SELECT '+@s+' from teacher')
²Î¿¼:
SQL code:
µÃµ½±íÖгýCol1¡¢Col2µÄËùÓÐÁÐ
ÀýÈ磺userno_fm¡¢userno_to
create table test(
num int identity(1,1),
userno_fm varchar(10),
userno_to varchar(10),
username varchar(10))
select * from test
declare @sql varchar(8000)
select @sql=''
select @sql=@sql+','+[name] from
(select [name] from syscolumns where object_id(N'[test]')=[id] and [name] not in ('userno_fm','userno_to')) A
set @sql='select '+stuff(@sql,1,1,'')+' from [test]'
--print @sql
exec (@sql)
drop table test
SQL code:
declare @sql varchar(8000)
select @sql=''
select @sql=@sql+','+[name] from
(selec
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......