sql query proble [modified]
-
hi everybody i am using sql 2000 server and facing syntax error. plz correct and reply. query is below but that is script of sql 2005 and i am using this on sql 2000 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductCategory]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[ProductCategory]( [ProductCategoryID] [int] IDENTITY(1,1) NOT NULL, [ProductCategoryName] [text] NOT NULL, CONSTRAINT [PK_ProductCategory] PRIMARY KEY CLUSTERED ( [ProductCategoryID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO
rajeev kumar sharma vri software pvt. ltd. new delhi India
modified on Thursday, January 31, 2008 2:06:42 AM
-
hi everybody i am using sql 2000 server and facing syntax error. plz correct and reply. query is below but that is script of sql 2005 and i am using this on sql 2000 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductCategory]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[ProductCategory]( [ProductCategoryID] [int] IDENTITY(1,1) NOT NULL, [ProductCategoryName] [text] NOT NULL, CONSTRAINT [PK_ProductCategory] PRIMARY KEY CLUSTERED ( [ProductCategoryID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO
rajeev kumar sharma vri software pvt. ltd. new delhi India
modified on Thursday, January 31, 2008 2:06:42 AM
RajeevKumarSharma wrote:
i am using sql 2000 server and facing syntax error.
What is the error? Did you check what the error message means before posting? If you can't be bothered to do a little investigation yourself, I can't be bothered to help you :|
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
-
RajeevKumarSharma wrote:
i am using sql 2000 server and facing syntax error.
What is the error? Did you check what the error message means before posting? If you can't be bothered to do a little investigation yourself, I can't be bothered to help you :|
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
i tryed to solve that but i am unable to solve that problem is Server: Msg 170, Level 15, State 1, Line 9 Line 9: Incorrect syntax near '('.
Rajeev Kr. Sharma VRI Software Pvt.Ltd. New Delhi India HumOnline.com Stay Connected