Hi Bhanu,

This is somewhat built-up (I am sure it needs refactoring), but you will be better doing that:

declare @country varchar(max) = 'china or...

Hi,

There is a class called DacServices (in Microsoft.SqlServer.Dac namespace). It has a Publish method. Does it serve your purpose?
Do you want both Publish and deploy...

That means VARCHAR(MAX) I guess.

See here for details,
https://www.sqlservercentral.com/Forums/Topic647815-145-1.aspx

Hi,

You can try like below (note the inline comments):

declare @lat1 as float
declare @long1 as float
declare @lat2 as float
declare @long2 as float

Couple of things that I observed in the stored procedure:
1. There are a DISTINCT clauses in two places. This should be avoided as it is expensive and if your...

In my opinion, if you do proper checking (e.g. checking for '0' for the denominator in a division and negativity of a SQRT function), that will do.

Thanks Scott for the reference.

Also, please be mindful about the usage of SQRT function (so that the parameter doesn't become negative) apart from division by zero. In this...

That doesn't seem to be a HEX value. Is it?

Hi,

When I tried to execute the expression at my end the expression inside the SQRT function returned negative values for me. Just check the value of

You can use CONVERT function like this:


SELECT CONVERT(DECIMAL, CONVERT(INT, 0x0010))          // This will return 16


Yes, actually WITH(NOLOCK) hint may return incorrect result sometimes by showing data from other uncommitted transactions (possibly by other users). So, to get a consistent view of the current data,...

Thanks Eirikur for pointing that out.
We can remove the WITH(NOLOCK) hint if execution speed is not a concern. This will give a consistent result.

Sure!
Basically, I am taking Customer table as the base table here and then gradually I am drilling down to the details about the order details. In that process, I...

Hi,

I hope this will be of help for you:

IF EXISTS(SELECT NULL FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'GetCustomerDetails'
         AND ROUTINE_TYPE = 'PROCEDURE')

Hi,

This is a probable but not so elegant way. Does this give any hint to you?

DECLARE @TestValue VARCHAR(MAX) = '[{"Code":"001", "Valeur":"AAA"}, {"Code":"002",...