Database

-- =============================================<br />
-- Create database template<br />
-- =============================================<br />
USE master<br />
GO<br />
<br />
-- Drop the database if it already exists<br />
IF  EXISTS (<br />
	SELECT name <br />
		FROM sys.databases <br />
		WHERE name = N'<Database_Name, sysname, Database_Name>'<br />
)<br />
DROP DATABASE <Database_Name, sysname, Database_Name><br />
GO<br />
<br />
CREATE DATABASE <Database_Name, sysname, Database_Name><br />
GO

Krishnatv wrote:

how do i read data from log file when i failed to create a database in sql server.

Krishnatv wrote:

how do i know what is the error which is cause to fail my table creation.

SELECT
        CompanyName, 
        SUM(CASE WHEN [Year] = 1997 THEN [Total Sales] ELSE 0 END) AS [1997],
        SUM(CASE WHEN [Year] = 1998 THEN [Total Sales] ELSE 0 END) AS [1998]
FROM MyTable
GROUP BY CompanyName