如何求出数据库中,最后三个字段的字段名? select top 10 name from syscolumns where id=object_id('ta')order by colid desc? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select top 3 * from syscolumns where id=object_id(表名)order by colid desc select A.name colname,B.name tbname from syscolumns A,sysobjects B where A.id = B.id and B.type ='U' and B.name = 'tbname' and A.colid >7 select top 3 name from syscolumns where id=object_id('表名t_user') order by colid desc select top 3 name from syscolumns where id=object_id('表名t_user') order by colid desc select name from (select top 3 name,colid from syscolumns where id=object_id('你的表名') order by colid desc) as a order by colid select top 3 * from syscolumns where id=object_id('表名') order by colid desc sys.objectssysobjects----------表列---sys.columnssyscolumns 一个产品多个单位 好头晕啊 SQL 赋值问题 一个房产管理程序,如何递归? 请问:我想把表中重复了的数据行全部删除应该怎么操作? SQL语句问题,急! 删除、修改作业时报错,求救! 我的数据被谁动了? 现在有一个SQL实例,创建了两个数据库,如何生成一个脚本文件? 关于存储过程 sqlserver2005高级编程 求助 [讨论] 用过程模拟MDX的报表效果. 数据库的问题 ~~~~请教高手 50分献上
order by colid desc
where A.id = B.id and B.type ='U' and B.name = 'tbname' and A.colid >7
select top 3 name from syscolumns where id=object_id('表名t_user')
order by colid desc
order by colid desc
select name from (
select top 3 name,colid from syscolumns where id=object_id('你的表名')
order by colid desc) as a order by colid
sysobjects
----------表列---
sys.columns
syscolumns