Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Download
Faster access than browser!
 

Transact-SQL

Index Transact-SQL

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. [1]

56 relations: At sign, BBEdit, Bulk insert, Call graph, Comment (computer programming), Comparison of C Sharp and Visual Basic .NET, Comparison of documentation generators, Comparison of programming languages (string functions), Comparison of programming languages (syntax), Data Access Language, Database administrator, Embedded SQL, Flyway (software), Glob (programming), Hekaton (database), History of Microsoft SQL Server, Indentation style, InterSystems Caché, Is functions, ISO 6346, Kiuwan, Language Integrated Query, List of programming languages, List of tools for static code analysis, Microsoft Data Access Components, Microsoft SQL Server, Microsoft Visual Studio, NDoc, Nested set model, Null (SQL), Null coalescing operator, Object-PL/SQL, Outline of software engineering, Parameter (computer programming), PL/SQL, Power Pivot, Printf format string, Remote Data Services, Sigil (computer programming), SQL, SQL Anywhere, SQL Server Agent, SQL Server Compact, SQL Server Notification Services, SQL Server Pro, SQL/PSM, Sqsh, Stored procedure, Sybase, Tilde, ..., Universally unique identifier, Upsizing (database), Visual Expert, Wildcard character, XLeratorDB, .NET Framework version history. Expand index (6 more) »

At sign

The at sign, @, is normally read aloud as "at"; it is also commonly called the at symbol or commercial at.

New!!: Transact-SQL and At sign · See more »

BBEdit

BBEdit is a proprietary text editor made by Bare Bones Software, originally developed for Macintosh System Software 6, and currently supporting macOS.

New!!: Transact-SQL and BBEdit · See more »

Bulk insert

A Bulk insert is a process or method provided by a database management system to load multiple rows of data into a database table.

New!!: Transact-SQL and Bulk insert · See more »

Call graph

A call graph (also known as a call multigraph) is a control flow graph, which represents calling relationships between subroutines in a computer program.

New!!: Transact-SQL and Call graph · See more »

Comment (computer programming)

In computer programming, a comment is a programmer-readable explanation or annotation in the source code of a computer program.

New!!: Transact-SQL and Comment (computer programming) · See more »

Comparison of C Sharp and Visual Basic .NET

C# and Visual Basic.NET are the two primary languages used to program on the.NET Framework.

New!!: Transact-SQL and Comparison of C Sharp and Visual Basic .NET · See more »

Comparison of documentation generators

The following tables compare general and technical information for a number of documentation generators.

New!!: Transact-SQL and Comparison of documentation generators · See more »

Comparison of programming languages (string functions)

String functions are used in computer programming languages to manipulate a string or query information about a string (some do both).

New!!: Transact-SQL and Comparison of programming languages (string functions) · See more »

Comparison of programming languages (syntax)

This comparison of programming languages compares the features of language syntax (format) for over 50 computer programming languages.

New!!: Transact-SQL and Comparison of programming languages (syntax) · See more »

Data Access Language

Data Access Language, or simply DAL, was a SQL-like language and application programming interface released by Apple Computer in 1990 to provide unified client/server access to database management systems.

New!!: Transact-SQL and Data Access Language · See more »

Database administrator

Database administrators (DBAs) use specialized software to store and organize data.

New!!: Transact-SQL and Database administrator · See more »

Embedded SQL

Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL.

New!!: Transact-SQL and Embedded SQL · See more »

Flyway (software)

Flyway is an open source database migration tool.

New!!: Transact-SQL and Flyway (software) · See more »

Glob (programming)

In computer programming, glob patterns specify sets of filenames with wildcard characters.

New!!: Transact-SQL and Glob (programming) · See more »

Hekaton (database)

Hekaton (also known as SQL Server In-Memory OLTP) is an in-memory database for OLTP workloads built into Microsoft SQL Server.

New!!: Transact-SQL and Hekaton (database) · See more »

History of Microsoft SQL Server

The history of Microsoft SQL Server begins with the first Microsoft SQL Server product - SQL Server 1.0, a 16-bit server for the OS/2 operating system in 1989 - and extends to the current day.

New!!: Transact-SQL and History of Microsoft SQL Server · See more »

Indentation style

In computer programming, an indentation style is a convention governing the indentation of blocks of code to convey program structure.

New!!: Transact-SQL and Indentation style · See more »

InterSystems Caché

InterSystems Caché is a commercial operational database management system from InterSystems, used to develop software applications for healthcare management, banking and financial services, government, and other sectors.

New!!: Transact-SQL and InterSystems Caché · See more »

Is functions

The Is functions (also known as data information functions, data inspection functions, or data-testing functions) are a set of functions in Microsoft's Visual Basic 6, Visual Basic for Applications, VBScript, and Visual Basic.NET.

New!!: Transact-SQL and Is functions · See more »

ISO 6346

ISO 6346 is an international standard covering the coding, identification and marking of intermodal (shipping) containers used within containerized intermodal freight transport.

New!!: Transact-SQL and ISO 6346 · See more »

Kiuwan

Kiuwan is a software as a service (SaaS) static program analysis multi-technology software for software analytics, quality and security measurement and management.

New!!: Transact-SQL and Kiuwan · See more »

Language Integrated Query

Language Integrated Query (LINQ, pronounced "link") is a Microsoft.NET Framework component that adds native data querying capabilities to.NET languages.

New!!: Transact-SQL and Language Integrated Query · See more »

List of programming languages

The aim of this list of programming languages is to include all notable programming languages in existence, both those in current use and historical ones, in alphabetical order, except for dialects of BASIC, esoteric programming languages, and markup languages.

New!!: Transact-SQL and List of programming languages · See more »

List of tools for static code analysis

This is a list of tools for static code analysis.

New!!: Transact-SQL and List of tools for static code analysis · See more »

Microsoft Data Access Components

Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store.

New!!: Transact-SQL and Microsoft Data Access Components · See more »

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

New!!: Transact-SQL and Microsoft SQL Server · See more »

Microsoft Visual Studio

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft.

New!!: Transact-SQL and Microsoft Visual Studio · See more »

NDoc

NDoc is a code documentation generator for the Common Language Infrastructure created by Jason Diamond, Jean-Claude Manoli and Kral Ferch.

New!!: Transact-SQL and NDoc · See more »

Nested set model

The nested set model is a particular technique for representing nested sets (also known as trees or hierarchies) in relational databases.

New!!: Transact-SQL and Nested set model · See more »

Null (SQL)

Null (or NULL) is a special marker used in Structured Query Language to indicate that a data value does not exist in the database.

New!!: Transact-SQL and Null (SQL) · See more »

Null coalescing operator

The null coalescing operator (called the Logical Defined-Or operator in Perl) is a binary operator that is part of the syntax for a basic conditional expression in several programming languages, including C#, Perl as of version 5.10, Swift, and PHP 7.0.0.

New!!: Transact-SQL and Null coalescing operator · See more »

Object-PL/SQL

Object-PL/SQL (Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of using the Oracle Corporation's procedural extension language for SQL and the Oracle relational database.

New!!: Transact-SQL and Object-PL/SQL · See more »

Outline of software engineering

The following outline is provided as an overview of and topical guide to software engineering: Software engineering – application of a systematic, disciplined, quantifiable approach to the development, operation, and maintenance of software; that is the application of engineering to software.

New!!: Transact-SQL and Outline of software engineering · See more »

Parameter (computer programming)

In computer programming, a parameter (often called formal parameter or formal argument) is a special kind of variable, used in a subroutine to refer to one of the pieces of data provided as input to the subroutine.

New!!: Transact-SQL and Parameter (computer programming) · See more »

PL/SQL

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.

New!!: Transact-SQL and PL/SQL · See more »

Power Pivot

Power Pivot is a feature of Microsoft Excel.

New!!: Transact-SQL and Power Pivot · See more »

Printf format string

Printf format string refers to a control parameter used by a class of functions in the input/output libraries of C and many other programming languages.

New!!: Transact-SQL and Printf format string · See more »

Remote Data Services

Remote Data Services (RDS, formerly known as Advanced Data Connector or ADC) is a Microsoft technology used in conjunction with ActiveX Data Objects (ADO) that allowed the retrieval of a set of data from a database server, which the client then altered in some way and then sent back to the server for further processing.

New!!: Transact-SQL and Remote Data Services · See more »

Sigil (computer programming)

In computer programming, a sigil is a symbol attached to a variable name, showing the variable's datatype or scope, usually a prefix, as in $foo, where $ is the sigil.

New!!: Transact-SQL and Sigil (computer programming) · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: Transact-SQL and SQL · See more »

SQL Anywhere

SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP.

New!!: Transact-SQL and SQL Anywhere · See more »

SQL Server Agent

SQL Server Agent is a component of Microsoft SQL Server which schedules jobs and handles other automated tasks.

New!!: Transact-SQL and SQL Server Agent · See more »

SQL Server Compact

Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.

New!!: Transact-SQL and SQL Server Compact · See more »

SQL Server Notification Services

SQL Server Notification Services is a platform developed by Microsoft for the development and deployment of notification applications based on SQL Server Technology and the Microsoft.NET Framework.

New!!: Transact-SQL and SQL Server Notification Services · See more »

SQL Server Pro

SQL Server Pro is a trade digital publication and website owned by Penton serving the information needs of IT Professionals in various fields including data processing, database administration, database development, computer-related consulting, and many other areas.

New!!: Transact-SQL and SQL Server Pro · See more »

SQL/PSM

SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.

New!!: Transact-SQL and SQL/PSM · See more »

Sqsh

Sqsh (pronounced skwish), short for SQSHell (pronounced s-q-shell), is an open source substitute for isql, the interactive SQL client supplied with Sybase's Adaptive Server Enterprise (ASE) relational database management system.

New!!: Transact-SQL and Sqsh · See more »

Stored procedure

A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS).

New!!: Transact-SQL and Stored procedure · See more »

Sybase

Sybase was an enterprise software and services company that produced software to manage and analyze information in relational databases.

New!!: Transact-SQL and Sybase · See more »

Tilde

The tilde (in the American Heritage dictionary or; ˜ or ~) is a grapheme with several uses.

New!!: Transact-SQL and Tilde · See more »

Universally unique identifier

A universally unique identifier (UUID) is a 128-bit number used to identify information in computer systems.

New!!: Transact-SQL and Universally unique identifier · See more »

Upsizing (database)

Upsizing is the term coined by Microsoft to describe the process of upgrading Microsoft Access Database to a Microsoft SQL Server.

New!!: Transact-SQL and Upsizing (database) · See more »

Visual Expert

Visual Expert is a static program analyzer, extracting design and technical information from software source code by reverse-engineering, used by programmers for software maintenance, modernization or optimization.

New!!: Transact-SQL and Visual Expert · See more »

Wildcard character

In software, a wildcard character is a kind of placeholder represented by a single character, such as an asterisk, which can be interpreted as a number of literal characters or an empty string.

New!!: Transact-SQL and Wildcard character · See more »

XLeratorDB

XLeratorDB is a suite of database function libraries that enable Microsoft SQL Server to perform a wide range of additional (non-native) business intelligence and ad hoc analytics.

New!!: Transact-SQL and XLeratorDB · See more »

.NET Framework version history

Microsoft started development on the.NET Framework in the late 1990s originally under the name of Next Generation Windows Services (NGWS).

New!!: Transact-SQL and .NET Framework version history · See more »

Redirects here:

T-SQL, T-sql, TSQL, Transact SQL.

References

[1] https://en.wikipedia.org/wiki/Transact-SQL

OutgoingIncoming
Hey! We are on Facebook now! »