No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Re:
how to delete duplicate record in a table by using SQL query |
|
i have table (id1,id2) 1.row [1,2] 2.row [2,1] 3.row [3,4] 4.row [4,3] 5.row [5,6] 6.row [6,5] i want to get result: 1.row [1,2] 3.row [3,4] 5.row [5,6] or 2.row [2,1] 4.row [4,3] 6.row [6,5] i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you … |
|
I need to create connection pool i think shared connections and controlled through semaphores. or its only on connections string level? , i saw code in java but NET nothing. |
|
Re:
hello, I have a table with int Primary key. Is there a way to set identity property on this field w/o dropping/recreating the table? Thank you. |