62,242
社区成员
发帖
与我相关
我的任务
分享
...全文
请发表友善的回复…
发表回复
saucer 2003-07-05
- 打赏
- 举报
it is your problem, since you didn't assign a unique key to the table, suggestion: add an identity column
comy 2003-07-04
- 打赏
- 举报
此问无解?
batisituta 2003-07-04
- 打赏
- 举报
Oracle的表里好像也有一个类似SQL的identity属性，叫什么忘记了。
comy 2003-07-02
- 打赏
- 举报
for example
two rows like this
col1 col2
1 2
1 2
this table has more than two rows,but i can only get two of them .if i can't get a column which can identify the location of it.I will have no way to know which row user selected.so the way which u said above is not valid.
two rows like this
col1 col2
1 2
1 2
this table has more than two rows,but i can only get two of them .if i can't get a column which can identify the location of it.I will have no way to know which row user selected.so the way which u said above is not valid.
saucer 2003-07-02
- 打赏
- 举报
update yourtable set col1='newcol1',col2='newcol2',....
where col1='oldcol1' and col2='oldcol2' and col3='oldcol3' ....
where col1='oldcol1' and col2='oldcol2' and col3='oldcol3' ....
comy 2003-07-02
- 打赏
- 举报
my question is how to get the row in the table exactely.cause i want to update or delete the row which user selected,but if the row has no primary key I'll can't decided which row i can update or delete.
waiting for ur help.......
waiting for ur help.......
saucer 2003-07-02
- 打赏
- 举报
the answer is no, but you can simulate it in SQL Server
select identity(int,1,1) as RowID, * into #temp from yourtable
select * from #temp
or if you are using databinding, for datagrid/datalist/repeater, you can use Container.ItemIndex
select identity(int,1,1) as RowID, * into #temp from yourtable
select * from #temp
or if you are using databinding, for datagrid/datalist/repeater, you can use Container.ItemIndex
