What am I misunderstanding when I read this (https://msdn.microsoft.com/en-us/library/ms176105.aspx)

Returns information about schema-scoped objects in the current database. For a list of schema-scoped objects, see sys.objects (Transact-SQL). This...

???

https://msdn.microsoft.com/en-us/library/cc645993.aspx

???

A Man of few words speaks too much.

That was EYE opening - http://www.sqlservercentral.com/Forums/Skins/Classic/Images/MessageIcons/W00t.gif

I have often wondered of the (Effects?) of ANSI_NULLS, and now I have a slightly clearer understanding.

By changing SET ANSI_NULL to...

Eirikur Eiriksson (11/20/2016)

Quick questions, can you use Table Variable Parameter? How wide are the largest values passed? How many values at...

WOW!!!

So very many possibilities, and so much to consider..

Eric M Russell (11/18/2016)

Budd (11/18/2016)

DECLARE @PARAM1 VARCHAR(2000) = 'Tom','JOE','BUDD','TIM' --< Obviously this wont work

Select...

Thank you BOTH!!

Hi, Try something like this.

SELECT DbBsName = mf.name

,PhysicalName = mf.physical_name

,LogicalName = db.name

FROM sys.master_files mf

JOIN sys.databases db ON db.database_id=mf.database_id

WHERE db.state = 0

AND mf.file_id = 1

Nice Start, however.

SELECT TOP(1)

-- Get the path location by trimming the file name and file extension.

LEFT(physical_name,LEN(physical_name) - (LEN([name]) + 4) )

FROM sys.database_files

WHERE...

While an ORDER BY clause will guarantee an order of results, I thought I read somewhere (long ago) that with out ORDER BY, the order or results can be influenced...

Interesting Question, but you can't say that

NULL

0

1

2

NULL

is a wrong answer.

I tested this using SSMS 2016, and 2008R2 and both provided the same order of results. Perhaps the...

Thanks very much Drew.

In regards to my collation usage, and the COALESCE in the WHERE clause you are so right !! This was written Months ago and I didn't even...

Very interesting.

A little additional research shows that the 3rd parameter can be anything other than the default of zero will cause the round function to truncate at the location specified...

Thank you Alan.

"Not Replicating Triggers" the trigger itself, or the results after a triggered event?

I have just completed the install of my 2 test servers SQL 2016 DEV, Will I...