It's very hard to tell without table scripts, indexes script and actual execution plan.

Can you post the above?

If in doubt, you can check this article[/url] to see how to gather...

Quicker than #sqlhelp!

:hehe:

Wrap it inside parenthesis:

declare @i int = (select count(*) from sys.columns)

works for me.

Hope this helps

Nah... I have nothing against Larry.

Those who buy...

WayneS (7/20/2011)

---

Anyone here have experience with Oracle? I'm looking for some data that demonstrates a need to use the RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW part of the OVER...

Gianluca Sartori (7/20/2011)

---

However, just to make my point again.... http://wp.me/p1gueM-3N...

Jeff Moden (7/20/2011)

---

It's always been a problem of mine. :blush:

Use EXEC:

DECLARE @sql nvarchar(max)

SET @sql = N'

create view vwTest

as

select * from non_existence_table'

BEGIN TRY

EXEC(@sql)

END TRY

BEGIN CATCH

PRINT 'Oh no!'

END CATCH

Lynn Pettis (7/19/2011)

---

I have to admit that working at Honeywell and with Oracle has taken me away from what I truely love, SQL Server and the awesome community that comes...

Jeff Moden (7/19/2011)

---

Good golly, Miss Molly! I just looked back at how many posts there are about my nomination. Thanks, Gianluca, for bringing it up. I'm at...

Nice catch, Lynn. I suppose this is due to some...

I don't see anything evil here (except the NOLOCK hint: seriously, get rid of that thing).

Can you post the estimated execution plan for both versions?

Also, can you post DDL for...

I tried reproducing the behaviour you describe, but I'm getting the same query plans for both statements.

-- SETUP

-- CREATE TABLE

CREATE TABLE testTable (

Id int identity(1,1),

dateColumn datetime

)

-- POPULATE TABLE

INSERT INTO testTable...

Mike01 (7/19/2011)

---

You should be very careful when using Table valued functions. It can cause huge performance problems. What does the function look like? How often is it...

Did you see any difference in the actual execution plans?