Thanks for the links. I actually did find both of those in my searching the other day, and part of the reason I thought it might exist in some...

Paul White NZ (3/28/2010)

---

Lynn Pettis (3/26/2010)

---

nitinkumar_tss (3/26/2010)

---

I want to get the rowid internally generated at table level in sql server. Because I need to perform some task according to the...

Paul White NZ (3/27/2010)

---

Jeff Moden (3/27/2010)

---

And now we know why I've gotten in the habit of aliasing all column names. Out of habit, it's even bled over into queries...

I'm almost inspired to create a whole database with "picture text" table names like >^.^< and <('.'<).

...

Almost.

That one can be nasty. There's a very similar version that can bite you as well.

Windowed functions are definitely high on my list, but I think I'd have to go with DMV's for the win.

I think I've got you beat Bob. This is pretty performant... runs in well under a second.

CREATE TABLE #Test(

nvcnvarchar(MAX))

CREATE TABLE #Output(

nvcoutnvarchar(MAX))

INSERT INTO #Test(nvc)

SELECT REPLICATE(N'A',500) UNION ALL

SELECT REPLICATE(N'B',600)

-- Declare Variables

DECLARE...

Michael Meierruth (3/26/2010)

---

DakotaPaul,

The WITH statement is the best thing that came out with SS2005.

And there is no need to wrap your head around it. It's really simple!

It's like preparing your...

kramaswamy (3/26/2010)

---

@Dixie Flatline, that's pretty much spot on. The issue of the tables being badly designed / indexed is a major issue, but it's not something we can just drop...

It seems like Oracle uses something like this that you can access, but unfortunately MS SQL does not. If you can give more details on your goal, it's possible...

If I understand this correctly, you're saying that it's failing even when you're not attempting to select from the table that you don't have rights to.

I tried to duplicate this...

No problem with the skepticism, I'm still running 2000 in my environment here, and these work fine (with the versioning restriction on fn_get_sql that I mentioned above, you need that...

What are you trying to achieve? I know you want to get those columns... but for what purpose, what are you going to do with the info? I...

Here's another snippet for working with fn_get_sql that might be helpful.

CREATE TABLE #C(dbid smallint, objectid int, number smallint, encrypted bit, [text] text)

DECLARE @handle binary(20),@textptr binary(16),

...

You should be able to use DBCC INPUTBUFFER(@@SPID) and ::fn_get_sql (The second one only works if you have SP3, or more specifically the patch that added this and the sql_handle...