Windows LiveWindows Live™
 
 
jose's profileSQL Server 2005 blogsBlogLists Tools Help

Blog
    June 18

    Restoring Selected tables from a full database backup

    SQL server does not have any feature to achieve a solution to a scenario where only some of the database tables needs to be restored from a full database backup. The only avaialble solution is placing the selected tables on different filegroups then restoring the filegorups.

     

    These problems can be solve however by thinking out of the box. It can be achieved by   restoring the full backup to a different database and then copying the desired tables through bulk copy, DTS, or SSIS

    8:17 AM | Add a comment | Read comments (3) | Permalink | Blog it
    June 17

    Something is new on Top

    One of the new cool enhancements in SQL2k5 is the new syntax and feauture of the TOP clause.
    Top clause now supports the TOP N feature where N is a variable. See the example below.
     
     
    USE AdventureWorks ;
    GO
    DECLARE @p AS int
    SET @p='10'
    SELECT TOP(@p)*
    FROM HumanResources.Employee;
    GO
     
     
    Other cool feature of the TOP clause is that it now supports and can now be used with  insert, update and delete statement
     
    10:41 AM | Add a comment | Read comments (3) | Permalink | Blog it