Tag Archives: SQL

Does SQL Server Management Studio truncate your results?

Posted on 02/16/2010 by Eric Fickes

Ever work with query results that are so long SQL Server Management Studio truncates the results? I ran into this issue recently while running some utility sprocs that generate C# code for me.  I was thinking I’d have to refactor … Continue reading →

Posted in database, microsoft, tips and tricks, tsql | Tagged , , , , , , | Leave a comment

How to JOIN two tables using LINQ to SQL

Posted on 02/11/2010 by Eric Fickes

Wanted to share this since it gave me so much trouble figuring out.  It’s a simple SQL query ported to LINQ to SQL that joins two tables to return a filtered listed of data. Here are the tables from my … Continue reading →

Posted in .net, C#, database, development, microsoft, SQL, tips and tricks | Tagged , , , , , , | 6 Comments

I wonder if using Coldfusion9′s ORM would make this easier?

Posted on 12/31/2009 by Eric Fickes

Rolling my own SQL solution Recently I was working on a medical website and was tasked with building a doctor directory page that had to pull data from three related tables.  For the viewers at home, here is a simplified … Continue reading →

Posted in adobe, coldfusion, database, development, SQL | Tagged , , , , , , | 1 Comment

Generate random integers using tsql UDFs

Posted on 09/02/2009 by Eric Fickes

Ever need to generate random numbers from the integer family?  I had this need on a project so I whipped up these four tsql User Defined Functions to help with this task.  There are four functions in all, one for … Continue reading →

Posted in database, development, microsoft, SQL, tsql | Tagged , , , , , , , , , | 4 Comments