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 3 years, 2 months ago by rajemessage 14195.
• This reply was modified 3 years, 2 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 3 years, 2 months ago by rajemessage 14195.

that i will read, but can i get a rough idea.

like first login i created has public server role , and database role i have given in db_creator as i...

has google cloud got any service equivelent ot aws rds or azure MI, where i can take full bakup, which i should be able to get to my laptop to...

Does that mean , I  can not take full backup and restore it to my laptop to check some issues or do some R and D work.

I want to put my production database at azure MI , where people will do the entry , then want a copy of the  database "on premises "

so that i...

i have production database on aws rds, where customer is entering data, i need a replica at customers siteoffice where he can see his reports offline and online also, but...

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

i know this one.

the situation is little bit different.

so the query is can we use "with cte" or recursion  inside following clauses like  exists  or cross apply or outer apply...

one more thing does deterministic encryption type supports order by because this article says https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-enclaves?view=sql-server-ver15

"

Deterministic encryption supports the following operations involving equality comparisons:

= (Equals) in point lookup, searches, and joins

IN

SELECT -...

is it possible to run Always Encrypted with secure enclaves on windows 10 pro with sqlserver express 2019,

as i noticed in this link they said u need "The HGS computer...

hi,

it is not clear that in this link https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver15

what they mean by writing following

"Queries on columns encrypted by using randomized encryption can't perform operations on any of those columns"

i have rephrased the question

DECLARE @s-2 VARCHAR(MAX)= 'r1,r2'

SELECT PATINDEX('%[^A-Za-z0-9-())![]]%',@s)

DECLARE @S1 VARCHAR(MAX)= 'X1;r2'

SELECT PATINDEX('%[^A-Za-z0-9-())![]]%',@s1)

i need to get first text string  before first comma or semicolan ex "r1" and "x1" respectivily . which is...

xml solution and function solution ex, calling scalar funtion i had . apart from these if any thing is there then pls tell me so that i stop finding and...

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

we tried to upgrade to 2019, but unfortunately, MS has put some restrictions like they have converted scalar functions to inline function by default and that throws an error, so...