Receiving an syntax error

Question

Post reply

Receiving an syntax error

Viewing 15 posts - 31 through 45 (of 67 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

just paste something like that for each table.

create table #granted(grantedid int,grantedname varchar(30) )

insert into #granted(grantedid,grantedname) values (1,'Lowell')

insert into #granted(grantedid,grantedname) values (2,'Remi')

insert into #granted(grantedid,grantedname) values (3,'Frank')

insert into #granted(grantedid,grantedname) values (4,'Noel')

then repost the current results and the expected results.

BuilderBits SSCertifiable Points: 6071 More actions · Answer 2

I thought about that after i typed it, haha, then i thought, i bet he thinks i am loco.. anywany,

here you go....

=====================------------------Categories

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Product_Categories]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[Product] DROP CONSTRAINT FK_Product_Categories

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Categories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Categories]

GO

CREATE TABLE [dbo].[Categories] (

[ProductCategoryID] [int] IDENTITY (1, 1) NOT NULL ,

[ProductCategoryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CategoryTypeID] [int] NULL

) ON [PRIMARY]

GO

=====================Company================

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Products_Company]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[Product] DROP CONSTRAINT FK_Products_Company

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Company]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Company]

GO

CREATE TABLE [dbo].[Company] (

[CompanyID] [int] NOT NULL ,

[DepartmentID] [int] NOT NULL ,

[CompanyName] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyLogo] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyAddress] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyCity] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyProvince] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyCountry] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyZipCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyFax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyEmail] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyRep] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyRepPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyRepEmail] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyWebMaster] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyWebmasterPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyWebMasterEmail] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyDateEnter] [datetime] NULL ,

[CompanyUserName] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyPassword] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyPhoto] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CompanyShortDescription] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

======================Product----------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Product]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Product]

GO

CREATE TABLE [dbo].[Product] (

[ProductID] [int] IDENTITY (1, 1) NOT NULL ,

[ProductName] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ProductCategoryID] [int] NOT NULL ,

[CompanyID] [int] NULL ,

[ModelName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ProductImage] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ProductDescription] [nvarchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ProductActive] [bit] NULL ,

[ProductFeatured] [bit] NULL ,

[ProductFeaturedStart] [datetime] NULL ,

[ProductFeaturedEnd] [datetime] NULL ,

[ProductSaleStart] [datetime] NULL ,

[ProductSaleEnd] [datetime] NULL ,

[ProductSalePrice] [money] NULL ,

[UnitCostPerFoot] [money] NULL ,

[UnitCostPerSection] [money] NULL ,

[UnitCostPerPiece] [money] NULL ,

[BulkCost] [money] NULL ,

[BulletOne] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BulletTwo] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BulletThree] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BulletFour] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BulletFive] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BulletSix] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BulletSeven] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BulletEight] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[BulletNine] [varchar] (3800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

Dam again!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

And the insert statements??

we must use the same data as you have to recreate the problem.

insert statements please. I'm not typing all type by hand.

BuilderBits SSCertifiable Points: 6071 More actions · Answer 4

Ok hold on, I have another one to hit you with.

How do i generate the insert statements?

Dam again!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

Something like this :

Create table demo

(

a varchar(10) not null,

b int not null

)

insert into demo (a, b) values ('test', 0)

insert into demo (a, b) values ('asdf', 3)

insert into demo (a, b) values ('hfe43', 5)

Select 'insert into demo (a, b) values (''' + a + ''', ' + cast(b as varchar(10)) + ')' as InsertQry from dbo.demo

/*

InsertQry

---------------------------------------------------------

insert into demo (a, b) values ('test', 0)

insert into demo (a, b) values ('asdf', 3)

insert into demo (a, b) values ('hfe43', 5)

*/

drop table demo

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Make sure you retest the insert statement to be certain that there's no syntax error. It's much easier to correct them on your end.

I'll worry about the identity inserts .

BuilderBits SSCertifiable Points: 6071 More actions · Answer 7

You are going to have to hold my hand on this one

Dam again!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

What are you not understanding? This is simple concatenation.

Didn't you run my demo step by step?

BuilderBits SSCertifiable Points: 6071 More actions · Answer 9

I did not give you the correst information last time.

This should be the right stuff.

=======================----Product

CREATE TABLE [Product] (