Xin Full Query TVWeb_v1.85 dùng cho mọi Database

[thientruongdx]

Như tiêu đề Topic bạn nào có Full Query TVWeb_v1.85 dùng cho mọi Database thì cho mình xin

[godhoang]

cái này ông pm thẳng cha TV đi :|
chả ai có query này đâu
hy vọng bác thecong share ;))
Mà định làm ss2 à :D

[thientruongdx]

Đã giải quyết xong....................

[ngocanh87]

Bạn share được không, cũng đang cần

[hoangtu_eck94]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CardPhone]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CardPhone];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Card_Vpoint]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Card_Vpoint];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Character_back]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Character_back];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DaiLy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DaiLy];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DoanhThu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DoanhThu];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RegVIP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RegVIP];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopMonth]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TopMonth];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XoSoData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[XoSoData];
CREATE TABLE [dbo].[CardPhone] (
[stt] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[Name] [varchar] (10) COLLATE Latin1_General_CI_AS NULL ,
[menhgia] [int] NULL ,
[card_type] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[card_num] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[card_serial] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[ngay] [smalldatetime] NULL ,
[status] [tinyint] NULL ,
[addvpoint] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[timenap] [int] NULL ,
[timeduyet] [int] NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[Card_Vpoint] (
[Name] [int] NOT NULL ,
[accdl] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[menhgia] [int] NULL ,
[card_num] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[card_serial] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[time_create] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[accused] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[time_nap] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[status] [tinyint] NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[Character_back] (
[AccountID] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[Name] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[LevelUpPoint] [int] NULL ,
[Class] [tinyint] NULL ,
[Leadership] [smallint] NULL ,
[Resets] [int] NOT NULL ,
[Relifes] [int] NOT NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[DaiLy] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[accdl] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[vpoint] [int] NOT NULL ,
[status] [tinyint] NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[DoanhThu] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[year] [int] NOT NULL ,
[month] [int] NOT NULL ,
[money] [int] NOT NULL ,
[card_type] [varchar] (20) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[RegVIP] (
[AccountID] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
[timedk] [int] NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[TopMonth] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[stt] [int] NOT NULL ,
[acc] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[Name] [varchar] (10) COLLATE Latin1_General_CI_AS NULL ,
[resets] [int] NOT NULL ,
[Month] [int] NOT NULL ,
[Year] [int] NOT NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[XoSoData] (
[Account] [varchar] (10) NOT NULL ,
[Num1] [int] NULL ,
[Num2] [int] NULL ,
[Num3] [int] NULL ,
[Num4] [int] NULL ,
[Num5] [int] NULL ,
[Num6] [int] NULL ,
[Num7] [int] NULL ,
[Num8] [int] NULL ,
[Num9] [int] NULL ,
[Num10] [int] NULL
) ON [PRIMARY];
ALTER TABLE [dbo].[Card_Vpoint] WITH NOCHECK ADD CONSTRAINT [DF__Card_Vpoin__Name__1AA9E072] DEFAULT (0) FOR [Name];
ALTER TABLE [dbo].[Character_back] WITH NOCHECK ADD CONSTRAINT [DF__Character__Level__15E52B55] DEFAULT (0) FOR [LevelUpPoint],CONSTRAINT [DF__Character__Leade__16D94F8E] DEFAULT (0) FOR [Leadership],CONSTRAINT [DF__Character__Reset__17CD73C7] DEFAULT (0) FOR [Resets],CONSTRAINT [DF__Character__Relif__18C19800] DEFAULT (0) FOR [Relifes];
ALTER TABLE [dbo].[DaiLy] WITH NOCHECK ADD CONSTRAINT [DF__DaiLy__vpoint__1D864D1D] DEFAULT (0) FOR [vpoint];
ALTER TABLE [dbo].[DoanhThu] WITH NOCHECK ADD CONSTRAINT [DF__DoanhThu__year__1F6E958F] DEFAULT (2008) FOR [year],CONSTRAINT [DF__DoanhThu__month__2062B9C8] DEFAULT (1) FOR [month],CONSTRAINT [DF__DoanhThu__money__2156DE01] DEFAULT (0) FOR [money];
ALTER TABLE [dbo].[TopMonth] WITH NOCHECK ADD CONSTRAINT [DF__TopMonth__stt__24334AAC] DEFAULT (0) FOR [stt],CONSTRAINT [DF__TopMonth__resets__25276EE5] DEFAULT (0) FOR [resets],CONSTRAINT [DF__TopMonth__Month__261B931E] DEFAULT (0) FOR [Month],CONSTRAINT [DF__TopMonth__Year__270FB757] DEFAULT (0) FOR [Year];
thử đi :D.........................