Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
parveen
Starting Member
4 Posts |
 Posted - 2006-09-18 : 23:52:04
|
| Hello Friends, Can you please help me in , How to find length of text datatype ?ThanksParveen. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-19 : 00:27:34
|
| Check out Books Online, but it can be any length up to 2GB IIRC.I would only use it if there were no other option, mainly because they are difficult to handle. |
 |
|
|
aida
Starting Member
5 Posts |
Posted - 2006-09-19 : 00:33:27
|
| try to use this syntax:sp_help M_MemberTable Name: M_MemberIf u have no idea how's the output, plese run the query in the SQL query analyzer |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-19 : 00:58:12
|
use datalength()
KH |
|
|
|
|
|
|
Length Of Text Datatype