Examples of using Transact-sql in English and their translations into Greek
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Financial
-
Official/political
-
Computer
Querying with Transact-SQL.
You can use Transact-SQL or SMO to issue backup and restore commands.
The name must not be a Transact-SQL keyword.
Membalas thread forum How to match two tables the best way? dalam Forum Transact-SQL.
The syntax for Transact-SQL also supports alternative formats for specifying comments.
General information about sp_trace_setevent(Transact-SQL).
For information about Transact-SQL keywords, see the SQL Server Books Online.
For more information,see sys. stats(Transact-SQL).
For example, you can run the following Transact-SQL scripts to exclude system databases.
This course is designed to introduce students to Transact-SQL.
You can use the DBCC OPENTRAN Transact-SQL reference to identify the oldest non-replicated transaction.
TSQL-SQL: BatchCompleted- captures all other Transact-SQL queries.
When Transact-SQL statement is processed, the database engine query processor determines which resources are to be accessed.
For more information, see DBCC SHOW_STATISTICS(Transact-SQL).
For information about Transact-SQL keywords, see the Transact-SQL Reference in the Microsoft Access Help or in SQL Server Books Online.
For more information,see Access FILESTREAM Data with Transact-SQL.
This occurs most frequently when an application issues a CANCEL or a Transact-SQL KILL command without a corresponding ROLLBACK command.
With ANSI_WARNINGS set on, SQL Server issues warning messages for conditions that violate ANSI rules but do not violate the rules of Transact-SQL.
The stored procedure then parses the string through extensive use of Transact-SQL string manipulation functions like CHARINDEX or PATINDEX.
FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000.
Dm_exec_query_plan dynamic management function to return a Showplan in XML format for a Transact-SQL batch:"A system assertion check has failed".
You can use the DBCC OPENTRAN Transact-SQL reference to verify that there is an active transaction in a database at a particular time.
In this release, backups to Microsoft Azure Blob storage are supported by using Transact-SQL and Server Management Objects(SMO).
The following Transact-SQL examples illustrate creating a credential, doing a full database backup and restoring the database from the full database backup.
You can create a subscription using the New Subscription Wizard,RMO, or Transact-SQL stored procedures on a new instance of SQL Server Express.
In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:Querying Data with Transact-SQL(M20761).
Connect to SQL Server by using Query Analyzer, andthen run the following Transact-SQL commands for the specific database files that you want to shrink.
Sp_spaceused- Transact-SQL stored procedure displays the number of rows, disk space reserved, and disk space used by a table, indexed view, SQL Server 2005 Service Broker queue in the current database.
You cannot create a subscription on the upgraded instance using Replication Management Objects(RMO) or Transact-SQL stored procedures if the subscription is enabled for Windows Synchronization Manager.