I see how using sys.languages lets you determine the default datefirst given the default language, ... but that raises the question, how does one find the default language for this...

Please consider all the advice given here by others.

That being said, you were very close.

with SalTest as 
( select

-- Putting * here includes all fields including Name
*,

--...

Fun fact:  Your article reveals an error in how SQL Server casts numeric to float.

STR(.922337203685477580,19,19)   should end in 776, but it ends with 777.

Further investigation shows that cast(.922337203685477580 to float)...

There's something missing that I don't see in your article nor the Microsoft website.

If you convert bigint value 9223372036854775807 to float, the exact value of the result is 9223372036854775808.  This...

This is the question that appeared to me:

What is the maximum relational database size of the SQL Server 2014 edition can grow to?

What does 2mld mean?

I would try something like this:

update a set did='z' where lid in

( select lid from b where uid in

( select uid from c where type='c') )

I too thought it would return 'this'.

I've read the documentation about 'sp_' and system stored procedures but I've always misunderstood until now.

The documentation doesn't really make clear what is a...

I would just like to point out that if any of your filenames has a ']' in it, your code will fail.

Let's think about what might be going on inside when those concatenations are being done.

I can't say that I know how this is implemented in this particular case, but...

I'm not familiar with the keyword "decrypt". I'm guessing it's something that works in

much older versions of SQL Server.

Even if that fragment of code is not being...

Why not create your own?

create function dbo.SUBSTRING_TO_ENDPOS ( @string varchar(8000),

...

When you specify two filter conditions with AND, it's up to the SQL Server to decide the order in which to apply the conditions.

Consider this code:

create table test (...

Might this be what you're looking for?

SELECT

CASE WHEN ROUND(18.00,2) = CONVERT(INT,18.00) THEN

convert(float,CONVERT(INT,18.00) )

ELSE

convert(float,18.00 )

END

SELECT

CASE WHEN ROUND(18.01,2) = CONVERT(INT,18.01) THEN

convert(float,CONVERT(INT,18.01))

ELSE

convert(float,18.01)

END

A case...

If I understand your question:

You are saving a copy of an Excel spreadsheet (or Word document) to the database.

You then open that Excel spreadsheet, make no changes to it,...