RESTORE DATABASE [DBNAME] 
WITH RECOVERY 
GO

SELECT * FROM SYS.DATABASE_FILES

DBCC CHECKIDENT
( 'table_name'
    [ , { NORESEED | { RESEED [ , new_reseed_value ] } } ]
)
[WITH NO_INFOMSGS]

SELECT GETDATE()

SELECT YEAR(GETDATE())
SELECT MONTH(GETDATE())
SELECT DAY(GETDATE())

INSERT INTO TABLE2(COL1, COL2,...) SELECT COL1, COL2,... FROM TABLE1 WHERE CONDITION

SELECT <non-pivoted column>,  
    [first pivoted column] AS <column name>,  
    [second pivoted column] AS <column name>,  
    ...  
    [last pivoted column] AS <column name>  
FROM  
    (<SELECT query that produces the data>)   
    AS <alias for the source query>  
PIVOT  
(  
    <aggregation function>(<column being aggregated>)  
FOR   
[<column that contains the values that will become column headers>]   
    IN ( [first pivoted column], [second pivoted column],  
    ... [last pivoted column])  
) AS <alias for the pivot table>  
<optional ORDER BY clause>;

SELECT c.name,
       t.name,
       c.max_length,
       c.precision,
       c.scale
FROM   SYS.COLUMNS c
       JOIN SYS.TYPES t
         ON t.user_type_id = c.user_type_id
            AND t.system_type_id = c.system_type_id
WHERE  object_id = OBJECT_ID('TABLENAME/VIEWNAME')