Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the difference between data length and length in
SQL Server-2008?

Answer Posted / sapthagiri

LEN
Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks.

DATALENGTH
Returns the number of bytes used to represent any expression.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql server profiler trace data file?

1109


What are different replication agents and what's their purpose? : sql server replication

1012


How do you know if sql server is running on your local system?

1039


What are the common performance issues in sql server?

923


what stored procedure can you use to display the current processes? : Sql server administration

1008


Explain “row_number()” in sql server with an example?

998


What are the triggers in sql?

1098


What is resource governor in sql server?

989


What are constraints in microsoft sql server?

1124


How to transfer data from a cursor to variables with a "fetch" statement?

1094


Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1049


What is buffer cash in sql server?

1152


Explain primary key and foreign key constraints?

1029


How would you add a section to a table?

1029


What is the purpose of a table?

959