|
|
|
|
|
|
|
 |
|
|
|
|
|
|
|
Tech Blog
|
 |
|
Jan
11
Written by:
host
1/11/2011 1:14 PM
;WITH DuplicateTable AS
(
SELECT ROW_NUMBER() OVER(PARTITION BY DuplicateCloumnName ORDER BY TablePrimaryKeyCloumnName ) AS
rn, *
FROM TableName
)
delete From TableName
where TablePrimaryKeyCloumnName in(
select TableId from DuplicateTable
WHERE rn > 1)
Tags:
|
|
|
|
|
|
|
|
 |
|
 |
 |
MCTS: Gain Microsoft Certified Technology Specialist - Wednesday, February 18, 2009
Aspnet Tradingpost V1.1 is Working with MS SQL 2008 and IIS7 - Tuesday, November 04, 2008Aspnet Tradingpost V1.1 is Working with MS SQL 2008 and IIS7
Aspnet Tradingpost V1.1 is Working under Windows Server 2008 and IIS7 beta - Friday, November 16, 2007Aspnet Tradingpost V1.1 is Working under Windows Server 2008 and IIS7 beta.
Aspnet Tradingpost V1.1 New Feature: - Thursday, August 30, 20071. Support Upload multiple files at once by ctrl/shift-selecting in dialog (AJAX)
2. Enter Multiple track number For a Order (AJAX)
3. Support Send Email After record Order track number
4. Support Product List sorting No page reloads necessary (AJAX)
5. Display Shipping cost in product Detail Page
6. Calculating Freight in Shopping Cart Page, No page reloads necessary (AJAX)
7. Customise Order Status
Demo Site On Live! - Wednesday, March 07, 2007
Aspnet Tradingpost V1.0 Released - Monday, March 05, 2007Aspnet Tradingpost V1.0 Released. Support Asp.net 2.0. SQL 2000 or 2005. IIS 5 or 6. Visual Studio.net 2005.
Please review all the feature in the Feature Summary Page.
Download page: Go to Download -> Aspnet Tradingpost V1.0
|
|
|
|
|
 |
 |
 |
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|