SQL SERVER DATALENGTH FUNCTION

SQL SERVER DATALENGTH FUNCTION

/*DATALENGTH FUNCTION IS SQL SERVER SSMS*/

--ALRIGHT, WE WILL BE LOOKING AT THE DATA LENGTH FUNCTION IN SSMS

--WHICH TELLS YOU HOW MANY CHARACTERS HAVE BEEN USING IN EACH FIELD

--FIRST WE START WITH THE KEYWORD, SELECT

-- FOLLOWED BY THE FUNCTION NAME DATALENGTH(

SELECT DATALENGTH(A.AccountDescription)
FROM DimAccount AS A;

--THE THEORY IS

-- SELECT DATALENGTH(COLUMN NAME)

-- FROM TABLE NAME AS AN ALIAS NAME OF A

-- HIGHLIGHT CODE AND CLICK EXECUTE OR (F5)

-- AS YOU CAN SEE THE AMOUNT OF CHARACTERS USED UP IN EACH FIELD DIFFERS FROM ROW TO ROW

-- THAT IS IT