There isn't a native way to do that. Can be done through triggers pretty easily, but not through a login/account/group permission.

Tabs.

Spaces work just fine. Always have.

I have...

Testing, testing, 1 2 3:

;with CTE (Acct) as

(select '421-15960'

union all select '421-01824'

union all select '421-07417'

union all select '421-11222'

union all select '421-95138'

union all select '421-07565'

union...

Like I said, pick a standard and stick to it. In this case, that matters more than what the specifics of the standard are. The advantages/disadvantages to each...

Yep. Those are equivalent.

They might become different in a more complex query, but generally the engine will treat the two the same.

Where it matters more is outer joins, instead...

sqlguru (7/8/2009)

---

GSquared (7/8/2009)

---

No matter how you implement the pointers, there's going to be a need for some sort of physical storage. Most likely, the physical implementation will involve either...

Here's where I got that it might be deprecated: http://iablog.sybase.com/paulley/2009/01/more-transact-sql-features-bite-the-dust/

Here's the source for that: http://www.sqlmag.com/Articles/ArticleID/100697/pg/1/1.html (Subscription required)

But it's not on the official deprecations page, so far as I can find:...

Take a look at Scope_Identity in Books Online or on MSDN.

That makes sense. Good job on tracking it down.

No matter how you implement the pointers, there's going to be a need for some sort of physical storage. Most likely, the physical implementation will involve either a numeric...

Alvin Ramard (7/7/2009)

---

GSquared (7/7/2009)

---

The results were simply...

If by "audit", he means, "take an inventory of the state of affairs with regards to..." and that list, then what you would need to do is take that list...

sqlguru (7/7/2009)

---

GSquared (7/7/2009)

---

I voted for both.

Have to say that they strike me as "nice to have", not as crucial. I'd rate the first one as "nicer to have" than...

I don't use prefixes by choice. Current employer requires them, so I'm using them, but I dislike it.

I don't find that it adds anything useful. It's not like...