Geek asks and answers

DbCommand cannot run multiple SQL commands in one ExecuteNonQuery ()

Hello, I have the following problem and I can not solve it.

C DbCommandI'm trying to execute this SQL statement

Dim strCommnad As String = 
"CREATE DEFAULT [dbo].[DOMAIN_XLibPKID_D] AS (0);" + Environment.NewLine +                                 
"CREATE TYPE [dbo].[XLibPKID] FROM BIGINT NOT NULL;" + Environment.NewLine +
"EXEC sp_bindefault 'DOMAIN_XLibPKID_D', 'XLibPKID';"

command.CommandText = strCommnad              
command.CommandType = CommandType.Text                
command.ExecuteNonQuery()

but I always get this error message

Incorrect syntax next to the keyword 'CREATE'.

But when I run each command from strCommandautonomously, then everything works fine.

I am using VS 2010 Professional and SQL Server 2008 R2 Express.

Thanks for any help.

+3
source share
2 answers

I'm not quite sure what you are trying to do, but your approach seems too complicated ...

, DEFAULT XLibPKID - ? ALTER TABLE :

command.CommandText = 
   "ALTER TABLE [dbo].[DOMAIN_XLibPKID_D]  " +
   "    ADD CONSTRAINT DF_XLibPKID DEFAULT (0) FOR XLibPKID";
command.ExecuteNonQuery()

DEFAULT CONSTRAINT .

+1

GO :

Dim strCommnad As String =  "CREATE DEFAULT [dbo].[DOMAIN_XLibPKID_D] AS (0);" + Environment.NewLine +
"GO; CREATE TYPE [dbo].[XLibPKID] FROM BIGINT NOT NULL;" + Environment.NewLine + 
"GO; EXEC sp_bindefault 'DOMAIN_XLibPKID_D', 'XLibPKID';"
-2

More articles:


All Articles