SqlSelect-在查询结果前面加一列序号列

select id= identity(int,1,1) , comp_name into #temp from tbl_company
select * from #temp
posted @ 2007-09-11 14:35  yellowwood  阅读(1017)  评论(0)  编辑  收藏  举报
Never Give UP