Problem To generate Insert Statement

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)

Problem To generate Insert Statement

Author

Topic

dilip.aim11
Starting Member

4 Posts

Posted - 2012-02-21 : 01:25:32

Hello
I m using Sqlserver 2005

I m trying to generate insert statement from table

for this i used this link

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53420
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23133
http://vyaskn.tripod.com/code/generate_inserts.txt
but all this working when table have less number of column...

My table structure is ..

USE [TigerERP]
GO
/****** Object: Table [dbo].[Tbl_NominalAC] Script Date: 02/21/2012 11:53:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tbl_NominalAC](
[AccountID] [bigint] IDENTITY(1,1) NOT NULL,
[CategoryID] [bigint] NULL,
[RootID] [bigint] NULL,
[TRNType] [varchar](1) NULL,
[AcType] [varchar](2) NULL,
[AcName] [nvarchar](50) NULL,
[CrDr] [varchar](2) NULL,
[Active] [int] NULL,
[Sort_Order] [int] NULL,
[HasParent] [varchar](1) NULL,
[Descr] [varchar](max) NULL,
[account_Code] [varchar](5) NULL,
[IsTaxExempt] [bit] NULL,
[PostingType] [varchar](50) NULL,
[isReconcile] [bit] NULL,
[Bank_Name] [varchar](150) NULL,
[Sort_Code] [varchar](50) NULL,
[Account_number] [varchar](150) NULL,
[company_ID] [int] NULL,
CONSTRAINT [PK_Tbl_NominalAC] PRIMARY KEY CLUSTERED
(
[AccountID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

i m getting error

Msg 451, Level 16, State 1, Line 1
Cannot resolve collation conflict for column 1 in SELECT statement

Please Help Me For this Topic..

Thanks..

dilip

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-21 : 14:40:06

for varchar columns add COLLATE database_default to avoid it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources