Column doesnt create - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Column doesnt create

Author

Topic

thendraljazz
Starting Member

26 Posts

Posted - 2012-04-28 : 01:50:50

Hi

I have a table with 175 columns.i need to create more columns but it was not created.I am facing the issue in windows server 2003 but its working in local system.

Can anyone tell me the issue?
How can i rectify this?What can i do to create more columns?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-04-28 : 01:57:15

What is the error message you get? Any warnings?

How does your query look like to create the new column?

N 56°04'39.26"
E 12°55'05.63"

thendraljazz
Starting Member

26 Posts

Posted - 2012-04-28 : 02:04:40

i didnt get any error in sql server.first time it is created but it was changed once i debug the application and i got invalid columns error in my application side.

this is my query

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[merchantlists](
[updateddate1] [datetime] NULL,
[MPN1] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant1] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice1] [decimal](15, 2) NULL,
[Shipping1] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax1] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice1] [decimal](15, 2) NULL,
[updateddate2] [datetime] NULL,
[MPN2] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant2] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice2] [decimal](15, 2) NULL,
[Shipping2] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax2] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice2] [decimal](15, 2) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

likewise i created upto 175 columns.now i need to add more columns in that query.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-04-28 : 02:37:45

If you don't show us the code that triggers the error, we can't help you.
You ARE aware that the total storage size cannot exceed 8060 bytes for an entire row?

N 56°04'39.26"
E 12°55'05.63"

thendraljazz
Starting Member

26 Posts

Posted - 2012-04-28 : 02:44:38

i didnt get any error.if i modify the table it will create the columns but
it was removed once i close the table and open.

thendraljazz
Starting Member

26 Posts

Posted - 2012-04-28 : 02:57:13

i got Sql execution error

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-04-28 : 05:55:16

So... What is the code you use to create the column?

N 56°04'39.26"
E 12°55'05.63"

YazanAllahham
Starting Member

2 Posts

Posted - 2012-04-29 : 08:56:29

What is the new column datatype? and what is the name of the new column?
did you try to use another name for the column? if you any spaces in the name of the column please use brackets [column name]

try another datatype and see if the problem is still appearing?

change the table name in the query and run it then see if new table is created and the new column is added.

it would be very great if you post here the creation script so we can try to figure the problem.

Regards

-----------------------------------------------------------------
Being a computer software developer doesn't mean you can fix a TV

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources