[转帖]在sybase中使选出的结果前添加一个行标识

chj3851

免费乐捐，感谢支持

select id0=identity(10),* into #temp from tablename

ehxz

好东东，简单有效[em01]

chj3851

我昨天发了几个东东，能加个精不

[em02]

ehxz

加了一个，不过以后希望多发原创的啊，呵呵！[em01]

chj3851

[em07] OK. 有好东东会拿出来跟大家分享地~~~

JohnPhan

select id0=identity(10),*  from tablename 却不行:

The IDENTITY function should be used only when the SELECT statement has an INTO clause.

chj3851

要加上 into #temp 啊，不加当然执行不掉啦。插入temp后再select * from #temp就ok了