请问大家怎样取得自增ID??

Arraywaterfish8

exec sp_addlinkedserver  \'srv_lnk\',\'\',\'SQLOLEDB\',\'192.168.106.15
        exec sp_addlinkedsrvlogin \'srv_lnk\',\'false\',null,\'sa\',\'123456\'
insert srv_lnk.ssWeb.dbo.t_hotsubject (tittle,description,picmark,picposition,attachmark,creatoronip,creator,deptno,orderno) values(\'tt\',\'test\',\'0\',\'0\',\'0\',\'0\',\'0\',10000,1)

select srv_lnk.ssWeb.@@IDENTITY

这样执行总是提示 \'@@IDENTITY\' 附近有语法错误。请问我要取得自增ID要怎么写？？

mywisidom

if not exists (select * from dbo.sysobjects where id = object_id(N\'[UserScore]\') and OBJECTPROPERTY(id, N\'IsUserTable\') = 1)
Create Table UserScore(Rid int identity(1,1),UserId int ,Score int)
insert UserScore (userid,score) values(2,200)
print scope_identity()
print ident_current(\'userscore\')
print @@identity
不会有问题啊

waterfish8848

看清楚没有，不是在同一服务器上的