SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL-DMO Reference
Methods (SQL-DMO)
E (SQL-DMO Methods)
EnableAgentOffload Method
EnableFullTextCatalogs Method
EnableMergeSubscription Method
EnableTransSubscription Method
EnumAccountInfo Method
EnumAgentErrorRecords Method
EnumAgentParameters Method
EnumAgentProfiles Method
EnumAlerts Method
EnumAllSubscriptions Method
EnumAllSubsetFilters Method
EnumAlternatePublishers Method
EnumAvailableMedia Method
EnumCandidateKeys Method
EnumCollations Method
EnumColumns Method
EnumConflictTables Method
EnumCustomResolvers Method
EnumDatabaseMappings Method
EnumDatabaseRoleMember Method
EnumDataSourceNames Method
EnumDependencies Method
EnumDirectories Method
EnumDistributionAgentSessionDetails Method
EnumDistributionAgentSessionDetails2 Method
EnumDistributionAgentSessions Method
EnumDistributionAgentSessions2 Method
EnumDistributionAgentViews Method
EnumDistributionAgentViews2 Method
EnumErrorLogs Method
EnumFileGroups Method
EnumFiles Method (Database)
EnumFiles Method (FileGroup)
EnumFixedDatabaseRolePermission Method
EnumFullTextLanguages Method
EnumGeneratedSubsetFilters Method
EnumHistory Method
EnumIdentityRangeInfo Method
EnumInitialAccesses Method
EnumJobHistory Method
EnumJobInfo Method
EnumJobNotifications Method
EnumJobs Method
EnumLastStatisticsUpdates Method
EnumLocks Method
EnumLoginMappings Method
EnumLogReaderAgentSessionDetails Method
EnumLogReaderAgentSessionDetails2 Method
EnumLogReaderAgentSessions Method
EnumLogReaderAgentSessions2 Method
EnumLogReaderAgentView Method
EnumLogReaderAgentViews Method
EnumMatchingSPs Method
EnumMergeAgentSessionDetails Method
EnumMergeAgentSessionDetails2 Method
EnumMergeAgentSessions Method
EnumMergeAgentSessions2 Method
EnumMergeAgentViews Method
EnumMergeAgentViews2 Method
EnumMiscellaneousAgentViews Method
EnumNotifications Method
EnumNTDomainGroups Method
EnumNTGroups Method
EnumObjects Method
EnumOutputs Method
EnumParameters Method
EnumProcesses Method
EnumPublicationAccesses Method
EnumPublicationArticles Method
EnumPublicationReferences Method
EnumPublications Method
EnumPublications2 Method
EnumQueueReaderAgentSessionDetails Method
EnumQueueReaderAgentSessions Method
EnumQueueReaderAgentView Method
EnumQueueReaderAgentViews Method
EnumReferencedKeys Method
EnumReferencedTables Method
EnumReferencingKeys Method
EnumReferencingTables Method
EnumServerAttributes Method
EnumServerRoleMember Method
EnumServerRolePermission Method
EnumSnapshotAgentSessionDetails Method
EnumSnapshotAgentSessionDetails2 Method
EnumSnapshotAgentSessions Method
EnumSnapshotAgentSessions2 Method
EnumSnapshotAgentView Method
EnumSnapshotAgentViews Method
EnumStatistics Method
EnumSubscriptions Method
EnumSubscriptionViews Method
EnumSubscriptionViews2 Method
EnumSubSystems Method
EnumTables Method
EnumTargetServers Method
EnumThirdPartyPublications Method
EnumThirdPartyPublications2 Method
EnumThirdPartyVendorNames Method
EnumUsers Method
EnumVersionInfo Method
ExecuteImmediate Method (Database, SQLServer)
ExecuteImmediate Method (LinkedServer, RemoteServer)
ExecuteWithResults Method
ExecuteWithResultsAndMessages Method
ExecuteWithResultsAndMessages2 Method
ExportData Method
Expand Minimize
This topic has not yet been rated - Rate this topic

ExecuteImmediate Method (Database, SQLServer)

SQL Server 2008 R2

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ExecuteImmediate method submits a Transact-SQL command batch on a connection, and directs execution or batch interpretation as specified by the application.

Copy 

object
.ExecuteImmediate(
Command 
, [ ExecutionType ] 
, [ Length ] )
object

Expression that evaluates to an object in the Applies To list.

Command

String that specifies a Transact-SQL command batch.

ExecutionType

Optional. Long integer that controls statement batch execution as described in Settings.

Length

Optional. Long integer that indicates the statement batch length.

Copy 
HRESULT ExecuteImmediate(
SQLDMO_LPCSTR Command,
SQLDMO_EXEC_TYPE ExecType = SQLDMOExec_Default,
long lLength CPPDEFAULT(= 0));

Set the ExecutionType argument using these values.

Constant

Value

Description

SQLDMOExec_ContinueOnError

2

Batch execution continues on any error that does not break the connection.

SQLDMOExec_Default

0

No statement execution options set.

SQLDMOExec_/NoCommandTerm

1

Ignore the command terminator in the script. Execute as a single batch.

SQLDMOExec_NoExec

4

Execute SET NOEXEC ON prior to batch execution. Execute SET NOEXEC OFF after batch execution.

SQLDMOExec_ParseOnly

8

Execute SET PARSEONLY ON prior to batch execution. Execute SET PARSEONLY OFF after batch execution.

SQLDMOExec_QI_ON

16

Execute SET QUOTED_IDENTIFIER ON prior to batch execution. Execute SET QUOTED_IDENTIFIER OFF after batch execution.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.