i think information schema is better because col_length is a function call and finally it would go to sys.objects or all_objects or information schema it self.

We do not want to change the script, as there are many stored procedures and functions.

if anything is there at system databases, or server level setting for databases, that would...

The situation is, the table is small, we do not have indexes or relevant stats, and we want to loop, and there are no joins.

In this situation what would be...

well , there must be some thumb of rule  , i think that can be answered.

well , there must be thumb of rule  , i think that can be answered.

like [ \t]  is used for spaces and tabs, is there anything for finding carriage return in TSQL

ex

where Result =

'Uwon'

thank u,

on more concern i have used utf8 ,becuase i wanted to use Unicode(multilingual) so i have used Modern_Spanish_100_CI_AS_SC_UTF8

in this I have used SC also I think this combination will...

my second question is unanswered

1. changing in structure is quite easy , it can be done in stmt so i did not mention.
2. Instead of varchar(max) if i just double or triple it like...

thanks , Has SSDT got any transfer feature?

thank u,

One more clarification , i have seen collation does not affect nvarcahr, but according to me the style part of collation that is" _CP1_CI_AS" affects nvarchar( i am not...

• This reply was modified 3 years, 1 month ago by rajemessage 14195.

"do you need code that will try one table first, then another if it doesn't exist? "

yes almost,

we want to login using login/user "login1" which has got tables in schema...

• This reply was modified 3 years, 2 months ago by rajemessage 14195.

why its geting data from dbo table but not from user1?