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 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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.