Where Clause

Discuss T-SQL

Discuss T-SQL Advertisements Previous Page Next Page   T-SQL (Transact-SQL) is an extension of SQL language. This tutorial covers the fundamental concepts of T-SQL such as its various functions, procedures, indexes, and transactions related to the topic. Each topic is explained using examples for easy understanding. Previous Page Print Next Page   Advertisements T-SQL –…

T-SQL – Quick Guide

T-SQL – Quick Guide Advertisements Previous Page Next Page   T-SQL – Overview In 1970’s the product called ‘SEQUEL’, structured English query language, developed by IBM and later SEQUEL was renamed to ‘SQL’ which stands for Structured Query Language. In 1986, SQL was approved by ANSI (American national Standards Institute) and in 1987, it was…

T-SQL – Useful Resources

T-SQL – Useful Resources Advertisements Previous Page Next Page   The following resources contain additional information on T-SQL. Please use them to get more in-depth knowledge on this. Useful Links on T-SQL T-SQL Wiki − Wikipedia Reference for T-SQL. Useful Books on T-SQL To enlist your site on this page, please drop an email to…

T-SQL – Date Functions

T-SQL – Date Functions Advertisements Previous Page Next Page   Following is the list of date functions in MS SQL Server. GETDATE() It will return the current date along with time. Syntax Syntax for the above function − GETDATE() Example The following query will return the current date along with time in MS SQL Server….

T-SQL – Numeric Functions

T-SQL – Numeric Functions Advertisements Previous Page Next Page   MS SQL Server numeric functions can be applied on numeric data and will return numeric data. Following is the list of Numeric functions with examples. ABS() Absolute value will come as output for numeric expression. Example The following query will give the absolute value. Select…