Discuss T-SQL 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. Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: […]
Category Archives: t Sql
T-SQL – Numeric Functions 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 ABS(-22) ACOS() Arc cosine value will […]
T-SQL – LIKE Clause The MS SQL Server LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator − The percent sign (%) The underscore (_) The percent sign represents zero, one, or multiple characters. The underscore represents a single […]