Browse by Tags

• I didn't know you could do this!

  create proc p_test as -- multiple resultsets select @@servername as ServerName; select 'abc'; select srvname from sysservers; go create table #tmp ( ServerName sysname ) go INSERT #tmp EXECUTE p_test; I did not know that the last statement above (i.e. Read More... Posted Friday, November 06, 2009 12:50 PM by Linchi Shea | 4 Comments Filed under: Random thoughts

• What's the difference between a server and a desktop?

  By server, I mean a computer that is fit for an enterprise data center. Different people will no doubt look at this question from different angles. If you are into computer technical specs, you probably would be quick to point out the difference in the Read More... Posted Wednesday, May 06, 2009 12:19 AM by Linchi Shea | 4 Comments Filed under: Random thoughts