T-SQL – SELECT Statement SQL Server SELECT statement is used to fetch the data from a database table which returns data in the form of result table. These result tables are called result-sets. Syntax Following is the basic syntax of SELECT statement − SELECT column1, column2, columnN FROM table_name; Where, column1, column2…are the fields of […]
Author Archives: user
T-SQL – Drop Tables The SQL Server DROP TABLE statement is used to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table. Note − You have to be careful while using this command because once a table is deleted then all the information available in the table would […]
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 approved by ISO (International Standards Organization). SQL is a structure […]