Creating a table in SQL Server
Now we create a table named employee.
Create table EmployeeTable
insert into employeeTable values('1','Smith','200000','Mrs. Smith has worked in Infosys since 22/7/2010')
Select * from employeeTable
The following is the sample data for the employee Table.
The ReadText statement is used to read or retrieve text data instead of the select statement. The general syntax of the ReadText statement is:
pointer_name offset size