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 […]
Category Archives: t Sql
T-SQL – Create Tables Creating a basic table involves naming the table and defining its columns and each column”s data type. The SQL Server CREATE TABLE statement is used to create a new table. Syntax Following is the basic syntax of CREATE TABLE statement − CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ….. […]