Gabe T. (10/1/2013)

---

Hi SSC,

I've got a table with a clustered index which needs to be dropped and recreated to add an additional column to it. The table also has three...

mario17 (10/1/2013)

---

Hi,

I need to get column from JOINed table but its one to many so I need to select only single instance for c2 , to keep original...

SQL_FS (10/1/2013)

---

Sean Lange (10/1/2013)

---

This is NOT...

jcrawf02 (10/1/2013)

---

Grant Fritchey (10/1/2013)

---

jasona.work (10/1/2013)

---

Grant Fritchey (10/1/2013)

---

Please. For purposes of employment, some of us cannot comment on politics because no matter what side I argue for, I'll yack off a...

Stefan Krzywicki (10/1/2013)

---

jcrawf02 (10/1/2013)

---

Stefan Krzywicki (10/1/2013)

---

Brandie Tarvin (10/1/2013)

---

Yes. Yes it is. And you'll kick...

easy_goer (10/1/2013)

---

Hello. I ran the following script that too 3 hours 25 minutes to insert about 40,000 rows. Is there any logic that I can put into this...

Stefan Krzywicki (10/1/2013)

---

Sean Lange (10/1/2013)

---

haha. I picked the band, the food and the tuxedos....

haha. I picked the band, the food and the tuxedos. Other than that the...

--edit--

wrong post.

This is NOT ordering by ordinal...

T.Ashish (9/30/2013)

---

If ordinal position of column is used instead of column name, then a new programmer will always have to look into the table to find out which column is...

jpnasab 81740 (9/30/2013)

---

Create function [dbo].[AF_TableColumns](@table_name nvarchar(55))

returns nvarchar(4000) as

begin

declare @str nvarchar(4000)

select @str = cast(rtrim(ltrim(column_name)) as nvarchar(500)) + coalesce('' + @str , '')

from information_schema.columns

where table_name = @table_name

group by table_name, column_name, ordinal_position...

Do you not already backup the database??? All the procs will be in...

Faster yes...but truncate is a fully logged...

Cool glad we were...