Database

8. DBCC log
This command is used to view the transaction log for the specified database.

Syntax:
DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] )
PARAMETERS: 
   Dbid or dbname - Enter either the dbid or the name of the database
                    in question.

      type - is the type of output:

      0 - minimum information (operation, context, transaction id)

      1 - more information (plus flags, tags, row length, description)

      2 - very detailed information (plus object name, index name,
          page id, slot id)

      3 - full information about each operation

      4 - full information about each operation plus hexadecimal dump
          of the current transaction log's row.

     -1 - full information about each operation plus hexadecimal dump
          of the current transaction log's row, plus Checkpoint Begin,
          DB Version, Max XDESID

by default type = 0
To view the transaction log for the master database, run the following command:

DBCC log (master)

1. Two SQL Server databases on the same server instance
2. Two SQL Server databases on two different server instances
3. Not SQL Server at all?

SELECT SUM(Amount) 
FROM Sales
WHERE 
   StoreID > 0 AND 
   StoreID = 
      CASE
         WHEN @StoreID > 0 THEN @StoreID
         ELSE StoreID
      END

SELECT customer, sum(value1)<br />
FROM my_table<br />
GROUP BY customer

SELECT customer, sum(value1)<br />
FROM my_table<br />
WHERE customer IN ('1111', '9999')<br />
GROUP BY customer

<br />
Select e.Event_ID, e.Event_Date, p.Prod_Name from EVENT e, PRODUCT p, EVENTS_PRODUCTS eps<br />
where e.Event_ID = eps.Event_ID and eps.Prod_ID = p.Prod_ID<br />
order by e.Event_ID p.Prod_Name DESC, e.Event_Date DESC<br />