The same question was posted here:

http://www.sqlservercentral.com/Forums/Topic639228-145-1.aspx

You responded to that post also.

Another alternative to the ISNULL function is the COALESCE function; both will work. In addition, COALESCE will also work with both DB2 and Oracle.

Do everything you can to avoid a cursor in a cursor for your process. Two-layered cursors yield dreadful, loathesome performance. You might be almost as well off having...

One of the conversations that I have had a number of times was to ask what kind of teeth I was going to have as a dba -- was I...

I would say that biggest source of the problems that I've seen over the years are design problems. In many cases I run into developers that put the code...

The problem I've seen is that once you start doing these kinds of "dirty tricks" that the dirty tricks eventually become seen as acceptable when really they never should be....

Bingo. That is the same reason that makes the workaround a very bad idea. Thank you, Barry. 🙂

There is a workaround in which you can use OPENROWSET to call a stored procedure from a function; however, this is in general a bad idea and should be avoided.

I have also seen this as a "feature" on many code generators similar to what was previously described. Having the "where 1=1" stub provides a post from which you...

Please give this page a look:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=273443

If this is something that you like please comment on it and I will also do the same.

Paul:

The "short" answer to your question is that MS SQL Server does not presently support that kind of alias. A work around such as the previous post is required...

It is a bit clunky and I might not understand the problem correctly; however, you might be able to start with something like this and refine it as needed:

/*

create procedure...

I am not sure if I understand your question, but you might want to give a look at the OUTPUT clause for the UPDATE statement in books online.

One method is to use the OPENROWSET command to read the data and then filter the records out of this query. Another alternative that you don't seem to want...

Since the aim of your question is at "efficient" I would suggest that (1) scalar functions and (2) multi-line table value functions will add "drag" to your views and will...