User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 427,997 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,530 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Showing results 1 to 4 of 4
Search took 0.00 seconds.
Posts Made By: rado
Forum: ASP.NET May 21st, 2007
Replies: 0
Views: 515
Posted By rado
Connection mssql

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.
Forum: MS SQL May 21st, 2007
Replies: 12
Views: 15,358
Posted By rado
Re: how to delete duplicate record in a table by using SQL query

only remove duplicate records, select duplicated fields, and then apply group by

create table #temp same schema
INSERT INTO #temp SELECT field1,field2,field{n} FROM yourtable GROUP BY...
Forum: MS SQL May 16th, 2007
Replies: 1
Views: 3,398
Posted By rado
Re: Set Identity property on a column

i thing that is

SET IDENTITY ON
insert INTO tb (id,.....) values(1,...)
SET IDENTITY OFF

, then you can set ident same as previous data.
Forum: MS SQL May 16th, 2007
Replies: 5
Views: 904
Posted By rado
cross data please heslp

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:
Showing results 1 to 4 of 4

 
All times are GMT -4. The time now is 9:55 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC