13-Oct-03 (Created: 13-Oct-03) | More in 'CS-SQLServer'

A sample sql server view


SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[view_name_view]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[view_name_view]
GO

create view dbo.view_name_view 
as
/***************************************************************************
* Comment block
* (view name)
*
* (view summary)
*
* 
* Change history
* ****************
* Update:
* by: 
* On:
*
***************************************************************************
*/
(select statement)
go

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO