Introduction of Transact-SQL
In this article I am going to explain about Transact-SQL.
Transact-SQL (T-SQL) is Structured Query Language and it is Microsoft's and Sybase's proprietary. Transact-SQL is originally developed by IBM for querying, altering and defining relational database. Transact SQL is also known as T-SQL. T-SQL supports many feature like variables, loops, conditions and exceptions.
T-SQL provide the fallowing feature
- Stored Function
- Stored procedure
T-SQL provide the programming concept. It also provide a wide variety of data types for variables and constants. SQL provide limited support for advance programming and T-SQL fill this gap.
@emp_id int = 200,
if(@emp_id>0 and @emp_id<100)
print (' Name and salary ' )
select name,salary from mcnemp where id = @emp_id
print('employee id is not correct')