To calculate the lenght of a TEXT field the LEN function used to calculate the length of VARCHAR fields won’t work.
You need to use the DATALENGTH T-SQL function:
SELECT DATALENGTH(myTextField) AS lengthOfMyTextField
To calculate the lenght of a TEXT field the LEN function used to calculate the length of VARCHAR fields won’t work.
You need to use the DATALENGTH T-SQL function:
SELECT DATALENGTH(myTextField) AS lengthOfMyTextField
To create a full database backup using Transact-SQL
Execute the BACKUP DATABASE statement to create the full database backup, specifying:
Example
BACKUP DATABASE
AdventureWorks
TO DISK =
'C:BackupsAdventureWorks.BAK'