• Microsoft Sql Server Online
• Sql Server 2005 Express Download
• Sql Server 2005 Sp4 Download
• Sql Server 2005 Standard Download

Posted Jan 4, 2006

codeDECLARE @Sample TABLE (ID INT) INSERT @Sample SELECT 2 UNION ALL SELECT 11 UNION ALL SELECT 234 UNION ALL SELECT 4534- SQL Server 2005 and later. Acronis License Server Does Not Accept Serial Numbers for Acronis Recovery for MS Exchange and Acronis Recovery for MS SQL Server This is normal behavior. Enter the serial number directly in the Acronis Agent installation assistant.

By Muthusamy Anantha Kumar aka The MAK

As we all know, SQL Server 2005 has new features whencompared to SQL Server 2000. One of the features that we are going to discussin this article is the Row_Number() function. SQL Server Database administratorsand developers have been longing for this function for a long time--now thewait is over.

Traditionally developers and Database administrators usedtemporary tables and co-related sub-queries to generate calculated row numbersin a query. Now SQL Server 2005 provides a function, which replaces all of theadditional resources we used to generate row numbers.

Let us assume that we have the following database[EMPLOYEE TEST] and the following table [EMPLOYEE] in the database. You can usethe below query to create the database, table and all the corresponding rows.

Let usbrowse the table Employee by using the following SQL Query.

Theresults of the above query look like illustration 1.0.

Traditionallyin SQL Server 2000, in order to create row numbers based on the rows availablein a table, we used to use the following query.

Thisquery created a new table using the identity function in order to generate RowId.

Let usquery the table by using the following query.

Theresults of the above query would look like illustration 1.1.

In thisillustration it is clear that the table has a duplicate row with EMPID =2021110.

To deletethe duplicate row with EMPID = 2021110, we have to delete the row in employee2table and I cannot delete the duplicate row directly from the Employee table.

SQLServer 2005 provides a new function, Row_Number(), for generating row numbers.In order to delete the duplicate row from the original table we can use thefeatures, Common Table Expression and Row_Number() together.

Microsoft Sql Server Online

Let usgenerate the ROWID using the Row_Number() function based on EMPID.

Theresults of the above query would look like illustration 1.2.

In thisresult set, we can identify the duplicate row for the EMPID 2021110.

Let usdisplay the duplicate row using the Common Table expression and Row_Number()function by using the following query.

Theresults of the above query would look like illustration 1.3.

Thisduplicate row can be deleted using the Common Table expression and Row_Number()function by using the following query.

Let usquery the table using the following query.

Theresults of the above query would look like illustration 1.4.

In this illustration,we can see that the duplicate row has been deleted.

Conclusion

In thisarticle, we have discussed the new features of Row_Number() function and CommonTable Expression and used both the features together to delete duplicate rows.

»See All Articles by ColumnistMAK

Using DataNumen SQL Recovery to Recover Corrupt SQL Server Databases

When your SQL Server MDF files are corrupt or damaged and you cannot open them normally, you can use DataNumen SQL Recovery to scan the MDF files and recover as much data from them as possible.

Start DataNumen SQL Recovery.

Note: Before recovering any corrupt or damaged MDF files with DataNumen SQL Recovery, please close any other applications that may modify the MDF files.

Select the corrupt or damaged MDF file to be repaired.

You can input the MDF file name directly or click the button to browse and select the file. You may also click the button to find the MDF file to be repaired on the local computer.

If there are one or multiple NDF files associated with the damaged MDF file, then you can add them as well:

If you know the format of the source damaged MDF file, then you can specify it:

If you do not specify the format, then by default, DataNumen SQL Recovery will try to analyse the source MDF file and determine the format automatically.

Sql Server 2005 Express Download

By default, DataNumen SQL Recovery will save the fixed MDF file into a new file named xxxx_fixed.mdf, where xxxx is the name of the source MDF file. For example, for source MDF file Damaged.mdf, the default name for the fixed file will be Damaged_fixed.mdf. If you want to use another name, then please select or set it accordingly:

You can input the fixed file name directly or click the button to browse and select the fixed file.

After the recovery process, you can start SQL Server Management Studio and access the corresponding recovered database.

Click the button, DataNumen SQL Recovery will prompt a 'Connect to SQL Server' dialog box, as below:

You need to set the Server Name and Authentication for the SQL Server instance on the local or remote computer, then click the 'OK' button. Then DataNumen SQL Recovery will start scanning and repairing the source MDF file. Progress bar

Sql Server 2005 Sp4 Download

will indicate the recovery progress.

After the recovery process, if the source MDF file can be recovered successfully, you will see a message box like this:

Sql Server 2005 Standard Download

Now you start SQL Server Management Studio and access the data in the recovered MDF database.