You cant do 0000-00-00 in any date field, if thats what you need I suggest CHAR(10)

If you need it in a DATE datatype column the lowest value you can do...

Not an Oracle guy myself, but I am guessing its something to do with "true" needing to be 'Y' or 'N', guessing Oracle isn't converting true to Y as its...

As per a different post, putting functions around columns in a where clause makes...

itumelengd (10/1/2015)

---

DECLARE @bestdatum DATETIME

SET @bestdatum = '2015-09-21 15:49:28'

SELECT YEAR(@bestdatum) Year

,MONTH(@bestdatum) Month

,DAY(@bestdatum) Day

...

Explicit

What do you mean by change the database?

Is this going to go into a stored proc?

Is this a one off ad-hoc query?

A backup is not an mdf its a bak.

If you need the mdf, restore the database and detach it from the server and point to the restored mdf file.

Out of...

Sounds like a kerberos issues.

Are all the servers in question running their services via AD service accounts? If so have they all been trusted for delegation?

You have not qualified your string on the @firstname as nvarchar when passing it to the stored proc

EXEC@return_value = [dbo].[SelectPerson ]

@First = N'??',

@Last = NULL,

@Address= NULL

Also take a look at...

I was also looking at https://msdn.microsoft.com/en-GB/library/gg492084.aspx which disproves the answer.

Brew

Pitcher

Take a look at DATEPART

tequila

Sunset