Personally, I wouldn't use UDF for the requested task, even it's look neater, it will be slower than just doing it in-line...

However, if you will go into using UDF, remember...

Jeff Moden (8/15/2010)

---

jeff.mason (8/9/2010)

---

Yep, this is why I NEVER use PRIMARY KEY CLUSTERED even IF I intend to cluster on that column. I am willing to burn the index...

Sorry, mate, but placing such code into trigger, is not very good design move.

If you need to use atrigger, you should try making it as lightweight as possible. Systems where...

DROP INDEX ...

Strange, requirement. Why you want disable index? What is you trying to do? Single update/insert/delete? Batch process?

Aspg (8/13/2010)

---

...

I was posting these posts while at work and gave you the wrong data

...

Can anybody tell me how to do this update using loop ,or cursor or...

Next time, please supply DDL of your objects and some test data (as per link found in the bottom of my signature).

You will need to change you table-valued function to...

Actually, the posted query need more work, as it should count concurrent sessions only within the same hour... (check one for 12)

I'm not sure if the following will be fast enough for you, bt it should do what you're asking for. Note: next time, please follow the advise which will be...

I hope you understand the differnece between your two examples.

The first one tells to SQLServer to recompile query which is executed by sp_executesql. You can use this option for some...

Wrong wording used: MS will cash anything it possibly can.:-D

Ok, SQLServer will cache the...

DataDog (8/12/2010)

---

I'd like to know how the server handles large quantities of distinct SQL statements with SP_EXECUTESQL

seems to me that all those cached plans will end up pushing out plans...

Mike Nuessler (8/12/2010)

---

Nothing fancy there it evaluates the conditions in order.

So the first condition (a=0) of the OR is evaluated and it will not look at second condition...

This...

Actually, the data modifications is much rare form of SQL Injection used by hackers. Mostly they whould be interesting just in basic selects...

For example: calssical injecting of "1=1; select *...

Endless loop in...