立即结贴给分,数据库中取值的问题 alter table add cid int identity(1,1)select * from table where cid=2alter table drop column cid 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select identity(int,1,1) id,* into #temp from tableselect * from #temp where id=2 I WILL TRY IT.IF IT CAN BE RUN,I WILL GIVE YOUR POINTS. orselect top 1 * from #temp where begindate in (select top 2 begindate from #temp order by begindate)order by begindate desc select IDENTITY(int, 1,1) AS ID_Num,* into #temp from tableselect * from #temp where ID_Num = 2drop table #temp 怎样快速,1个月有多少天? --有挑战! 关于sql的安装问题 如何替换某表某列里面的内容 存储过程,请大家帮忙。(在线等) 这个触发器怎么写呢?在线等…… 40分改为100分,怎样给帖子加分? 有关数据导出的问题? 关于Sqlserver的计算列 持久化 是不是高难度:用SELECT一次就取出我的试题库中随机的20道数学题,10道语文题,15道英语题? LDF文件北删除是不是一定无法恢复数据库数据了? 有关ODBC的配置 异地备份怎么做?谢谢!
select * from #temp where id=2
IF IT CAN BE RUN,I WILL GIVE YOUR POINTS.
(select top 2 begindate from #temp order by begindate)
order by begindate desc
select * from #temp where ID_Num = 2
drop table #temp