Tag Archives: query

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