Creating a table in SQL Server
Now we create a table named employee.
Create table EmployeeTable
(
EmpID int,
EmpName varchar(30),
EmpSalary int,
EmployeeFile Text
)
Go
insert into employeeTable values('1','Smith','200000','Mrs. Smith has worked in Infosys since 22/7/2010')
Go
Select * from employeeTable
The following is the sample data for the employee Table.
ReadText statement
The ReadText statement is used to read or retrieve text data instead of the select statement. The general syntax of the ReadText statement is:
Syntax
READTEXT table_name.col_name
pointer_name offset size
[HOLDLOCK]