How's this?

DECLARE @L_ZERO INT

SELECT @L_ZERO = ISNULL(IdMyTable,0) FROM MyTable WHERE ColumnRef = 1000

SELECT @L_ZERO

Thank-you, for the nice & easy question. For me, the week generally goes good if the start is good 🙂

I have strongly believed that if users are not supposed to...

Nice, easy question to end the week.

@hugo: Completely agree on your point about the issue with the explanation.

Very good question! The question proves that the devil is in the details! The question teaches everyone a lot of things.

Thank-you!

Looks like there is an issue with one or your aliases (maybe a table alias is being used but is not defined).

The way I interpreted the question was:

1. Database is in full-recovery mode

2. User foresees bulk-operations (i.e. to be performed sometime in the future)

3. User therefore changes the database to bulk-logged...

Nice question, Thank-you, Steve! Learnt something new.

Look specifically at the full error message:

select * from sys.messages where message_id = '18452' and language_id = 1033

Login failed. The login is from an untrusted domain and cannot be used...

And some test data showing what's wrong.

If you are able to get to your server by searching for the network instances, is there a specific need as to why you need to connect using the IP?

In...

This needs more information. Please refer the post: Forum Etiquette: How to post data/code on a forum to get the best help[/url] that describes the bare minimum requirements before we...

Does this work for you?

USE tempdb

GO

DECLARE @testDate DATETIME = '2012-03-27 12:57:21.097'

SELECT DATEADD(HH,DATEPART(HH,@testDate),CAST(CAST(@testDate AS DATE) AS DATETIME)) AS StrippedDate

/*------------------------

-----------------------

StrippedDate

-----------------------

2012-03-27 12:00:00.000

------------------------*/

Perhaps the major reason I hate tabs in code is that tabs are not interpreted in the same way on all systems - some may have 4 spaces, others may...

Nice and easy question to get the week started. Thank-you, Steve!

Everyone: Have a great week ahead!

I believe the reason would be because OPEN queries require that Adhoc queries be enabled on the SQL Server, which, depending upon the environment and the situation, might be considered...