Monday, March 19, 2012

All Data Type and View in ONE SCREEN

for Default.aspx page:
=======================

and the sqlscript file is:
===========================
/****** Object: Table [dbo].[MovieTable] Script Date: 03/19/2012 12:48:17 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MovieTable]') AND type in (N'U'))
DROP TABLE [dbo].[MovieTable]
GO
/****** Object: Table [dbo].[MovieTable] Script Date: 03/19/2012 12:48:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MovieTable]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[MovieTable](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Title] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_MovieTable] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
SET IDENTITY_INSERT [dbo].[MovieTable] ON
INSERT [dbo].[MovieTable] ([Id], [Title], [Name]) VALUES (1, N'English', N'DDLg')
INSERT [dbo].[MovieTable] ([Id], [Title], [Name]) VALUES (2, N'Hindi', N'Sanam')
INSERT [dbo].[MovieTable] ([Id], [Title], [Name]) VALUES (3, N'Urdu', N'HAHK')
INSERT [dbo].[MovieTable] ([Id], [Title], [Name]) VALUES (4, N'Malayalam', N'Lholiy')
SET IDENTITY_INSERT [dbo].[MovieTable] OFF

No comments:

Post a Comment

Don't judge me like you know me.Don't talk to me if you don't like me. I am my own person and If you don't like that i don't give a f***