execute sql query from c# code for creating new sql table

Question

I am trying to execute a sql query which will create a new table in sql database. When I am doing this:

string queryString = @"
CREATE TABLE [dbo].[peep_searchresults_live](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [SKU] [varchar](150) NULL,
    [ManufacturerBrand] [varchar](150) NULL,
);

The query gets executed just fine and the table gets created in the database.

But when I am trying this:

string queryString = @"
            SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[peep_searchresults_live](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [SKU] [varchar](150) NULL,
    [ManufacturerBrand] [varchar](150) NULL,            
 CONSTRAINT [PK_peep_searchresults_live] PRIMARY KEY CLUSTERED 
(
    [id] 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
GO";

I am receiving error like this one:

enter image description here

what function are you using in the c# code? ExecuteNonQuery? — Hector Sanchez
– Hector Sanchez, Commented Mar 1, 2012 at 20:27

James Hill · Accepted Answer · 2012-03-01 20:27:15Z

3

SQL server doesn't understand what GO is - only the query analyzer knows (eg. SSMS).

If you need to execute multiple commands, simply execute them in the proper order, one at a time.

answered Mar 1, 2012 at 20:27

James Hill

62.2k22 gold badges150 silver badges166 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pearcewg · Accepted Answer · 2012-03-01 20:29:51Z

0

GO statements are not valid in ADO.net

Do you need all of those other qualifying statements?

You can break each into a separate command, and execute each command in turn with a single connection.

answered Mar 1, 2012 at 20:29

pearcewg

9,61923 gold badges82 silver badges126 bronze badges

1 Comment

Laziale Over a year ago

I am trying to set primary key on ID field, is there other way how I can do via the code?

TheRealTy · Accepted Answer · 2012-03-01 20:31:58Z

0

You cannot use go, you need to split the command in to multiple sets.

http://social.msdn.microsoft.com/Forums/ar/csharpgeneral/thread/2907541f-f1cf-40ea-8291-771734de55f2

answered Mar 1, 2012 at 20:31

TheRealTy

2,4293 gold badges22 silver badges32 bronze badges

Collectives™ on Stack Overflow

execute sql query from c# code for creating new sql table

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related