t-sql functions

SQL vs. PL/SQL vs. T-SQL SQL is a standard query language of the database. Where the PL/ SQL stands for “Procedural Language…

T-SQL LIKE Operator In Transact-SQL, The LIKE operator is used to search the pattern specified in the column with WHERE clause. The…

T-SQL Numeric function In T-SQL, a Numeric function is applied to numeric data and returns digital data. The types of Numeric function…

T-SQL ORDER BY ORDER BY Clause sorts the database in increasing or decreasing order. To sort multiple columns at once, separate the…

T-SQL Pivot and UnPivot Pivot and Unpivot in Transact SQL are the relational operators. They transform one table into another to achieve…

T-SQL SELECT STATEMENT In T-SQL, the SELECT statement is used to fetch the data from the database table that returns the data…

Data types T-SQL Data type in SQL server is an attribute, which generates the data of the object. Each variable, column, and…

T-SQL Stored Procedures The Stored procedure in Transact SQL is used to save time to write the code, again and again. It…

T-SQL Create Table In T-SQL, we create a table, which has the name of the table and defines the columns and data…

T-SQL String Function In T-SQL, String function is applied on string value and returns the numeric data or the string value. Type…