Redian新闻
>
Help!!!! How to synchronized the data in SQL server
avatar
Help!!!! How to synchronized the data in SQL server# Database - 数据库
f*f
1
What I want to do is something like that:
declare @id
select @id=max(id) from mytable
if(@id is null)
@id=0
else
@[email protected]+1
insert into mytable(@id,'aa','bbb')
But How to synchronized it when multiple connetions access database.
I use JDBC..
Thank you
avatar
B*z
2
I think you are trying to generate sequence for primary key for mytable
you can just declare the id column as identity. when you insert into
you just values('aa','bb')

【在 f*******f 的大作中提到】
: What I want to do is something like that:
: declare @id
: select @id=max(id) from mytable
: if(@id is null)
: @id=0
: else
: @[email protected]+1
: insert into mytable(@id,'aa','bbb')
: But How to synchronized it when multiple connetions access database.
: I use JDBC..

avatar
f*f
3
Thank you. I got it.

【在 B**z 的大作中提到】
: I think you are trying to generate sequence for primary key for mytable
: you can just declare the id column as identity. when you insert into
: you just values('aa','bb')

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。