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 2 years, 2 months 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 2 years, 4 months ago by  rajemessage 14195.

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

Because I have one product whose code is common for all projects which come to us, so we have to keep one database for one project.

and now we want to...

i understood in case of storedporcedure , but in case of  the function.

I logged in  using  the user  "login s2" then executed the function "s1.xyz" which is in schema "s1"...

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

Understanding that is, schema name is required for calling scalar functions. i have changed my requirement.

i made three schemas s1 s2 s3, then i made s1 as public , so...

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