3-4-2009 12:27:17
Anh em dùng câu lệnh gen bảng sau nhé. Nguyên nhân sinh lỗi có thể là do anh em chưa đặt cái ID = identity nên nó không insert vào DB được.
----------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[News_Category]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[News_Category]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[News_News]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[News_News]
GO
CREATE TABLE [dbo].[News_Category] (
[CatID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[CatName] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ParentID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lang] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Description] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[OrderNumber] [int] NULL ,
[DesktopListID] [int] NULL ,
[DesktopViewID] [int] NULL ,
[NewsID] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[News_News] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[CatID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Headline] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Description] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ImageUrl] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Source] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AllowComment] [bit] NULL ,
[Published] [bit] NULL ,
[CreatedDate] [datetime] NULL ,
[CreateID] [int] NULL ,
[ModifyDate] [datetime] NULL ,
[ModifyID] [int] NULL ,
[TotalView] [int] NULL ,
[Content] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[News_Category] WITH NOCHECK ADD
CONSTRAINT [PK_News_Category] PRIMARY KEY CLUSTERED
(
[CatID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[News_News] WITH NOCHECK ADD
CONSTRAINT [PK_News_News] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
---
Coding for food
http://yenbai.awas.vnhttp://tknd.vn