johnsonchase7 (9/15/2015)

---

Thanks for the responses. You make a great point about just grouping it. The issue however is that since the sproc is so huge, the text data is an...

drew.allen (9/15/2015)

---

I'm not sure whether the parameters are displayed in the proc definition order or the call order. If it's the proc definition order, then you do not need...

Town

Traffic

Vacuum

Yeah, I didn't quite get it either. I think there will likely be some lively debate on this one.

If your DateDetailDisposed column is a datetime data type, you might run into a performance problem here. Applying a function to...

Lynn Pettis (9/14/2015)

---

Ed Wagner (9/14/2015)

---

Will this work for you?

SELECT so.name table_name, sc.name column_name, fk.name fk_name, so_fk.name references_table, sc_fk.name referenced_column

FROM sys.objects so

INNER JOIN sys.columns sc...

Heh - I've never seen that one before. Very nice. 😉

yb751 (9/14/2015)

---

Although similar the other post asks about information regarding Foreign Keys while this thread asks for Columns Data Type and Size....

Duplicate post. Direct replies to http://www.sqlservercentral.com/Forums/Topic1719361-2799-1.aspx

Will this work for you?

SELECT so.name table_name, sc.name column_name, fk.name fk_name, so_fk.name references_table, sc_fk.name referenced_column

FROM sys.objects so

INNER JOIN sys.columns sc on sc.object_id = so.object_id

...

ScottPletcher (8/25/2015)

---

I think you can combine the two queries, possibly if will perform better, esp. if the joins are a lot of overhead. As to the joins, they seem...

The ROW_NUMBER() function is valid on SQL 2012. I would check to make sure you have the comma before it.

One thing that's been missed is that if you remove...

Inspire