GenerateSQL Method (Backup, Restore)
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The GenerateSQL method returns a string that contains a Transact-SQL command batch used to perform the Microsoft SQL Server database backup or restore operation defined by the SQL Distributed Management Objects (SQL-DMO) object.
Sintaxis
object.GenerateSQL( )asString
Parts
- object
Expression that evaluates to an object in the Applies To list.
Prototype (C/C++)
HRESULT GenerateSQL(SQLDMO_LPBSTR pRetVal);
[!NOTA]
SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.
Returns
A Transact-SQL command batch as a string.