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 2 years, 7 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...

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...

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 ....

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 2 years, 11 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...

in the 2 solution: pass means, in with cte, first, it goes to a temp table then it is read again which is second pass and then where clause is...

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

both are working, the only thing is first they multiply by using cross apply, that takes one pass, then where clause is applied to fillter, that makes the second pass.

in...

ya, I have checked, I will update with an example why they do not fit into.

primarily they do not give result in one go,

first they find the small and big...