If you want to make this super-robust a guard that tests if sys.dm_exec_describe_first_result_set_for_object can determine the metadata could be worthwhile. For example, using this technique for sp_who2 does not...

[Flag] [decimal](20,0) is not the right data type choice. It is a 4-byte int https://msdn.microsoft.com/en-us/library/ms680832(v=vs.85).aspx

Again I wonder how they choose a "Featured Script". Is this "featured" as an anti-pattern? I guess that I assume something is featured to show a best practice....

Useful for a number of reasons. Most I can think of don't need a survey like this. However, off the top of my head, if you are deciding...

I typically put an existence guard when I do a DROP TABLE: IF OBJECT_ID('tempdb..#tblHOLD') IS NOT NULL DROP TABLE #tblHOLD

Even for temp tables, I would use meaningful names, especially...

I don't know how "Featured Scripts" are chosen. As LuckyNickyBoy observed the procedure is inefficient as it executes 4 tests where 2 are needed. Also, it uses the...

shivaram challa (10/29/2013)

---

Hi gshouse,

Actually, this script will work for 2000, 2005, 2008 and hopefully 2012. I dont know if this will work for 6.5 though.

The reason is sys tables...

shivaram challa (10/29/2013)

---

I have updated the script to get data for SQL Server 2008(tested) and SQL Server 2012(not tested). Once it gets published, you can get the script from the...

Dohsan (2/28/2013)

---

I believe the algorithm for calculating the check digit takes the difference between the 'weighted sum' and the nearest multiple of 10 that is equal or higher.

if the sum...

Me have mud.

Me have stick.

What more me need?

We're DINKS so I have some time & money.

My desktop has 1TB, raw 500 GB net in 4 drives.  The system mirror has an XP, Vista, and Ubuntu boot partition. ...

Is this what you are looking for:

create procedure uspNest

as

 select top 10 uid, status

 from model.dbo.sysusers

go

create table #Tempo

 (uid int,

 status int)

insert into #Tempo ...

I'd use an ActiveX script

set oConnection = oPackage.Connections("ConnectionName")

  oConnection.DataSource = "FileName.xls"

Another bad question with no right answer.  The best choice to add to the list of answers would have been "Not enough information to determine".  The next best to add...

I would just like to add my voice to those who have pointed out that the purported answer to this question is wrong.  Procedure caches are not typically thought of...