Search results for query: *

Hello: I have row number with more than 400 rows. I use select into statement. It only allow 175 rows to get copied into Tem_Table. How to get all rows copied when create new table? select id, code into Tem_table from Name where code = '11' Your help is highly appreciated.

Hello: I need to get table_name, column_name, Data_type, and the lenght of the data string is more than 1000 char together. How to get it? SELECT datalength(blah) FROM YourTable only could get the length of the data string, but how to get table_name, column_name together? Do you have...

Hello: Thanks for the help. I do not need LEN(column_name). I need to find the lenght of data string. Thanks

Hello: Thanks for the message. For example, here is some of my table. TableOne Column Name: Id DescriptionOne TitleOne Datatype: int ntext char Data 1 abcbdddd....>3000 char TableTwo Column Name: Id DescriptionTwo TitleTwo...

Hello: I would like to check all usertable to find the field datatype is ntext and the length of this field is more than 1000 char. I need to get tabel_name, column_name, Data_type, and the lenght of the field is more than 1000 char. Do you have the sample for this? Thanks, SS

Hello: I have a field which is varchar. I would like to calculate how many character in that field. How to do it. Thanks, Snow