My Work
My Blogs
Hotlinks
Category Archives: database
Does SQL Server Management Studio truncate your results?
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 column size, max characters, query, results to text, SQL, sql server management studio, truncated results
Leave a comment
What happens in EXEC, stays in EXEC. Lifespan of a MSSQL table variable
One of my all time favorite features of MSSQL 2005+ is being able to create table variables on the fly from SELECT statements. This isn’t a lesson in what table variables are, but here is an easy sample in case … Continue reading
Posted in database, development, tsql
Tagged exec, mssql, mssql2000, mssql2005, scope, SELECT INTO, table variable, temp table, tsql
1 Comment
How to JOIN two tables using LINQ to SQL
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 asp.net, join, linq, linq to sql, linqtosql, query, SQL
6 Comments
Come have a 360Flex chat with me and Jun Heider
Chat is @ Thursday Feb 11th, 11:30am MST Jun Heider and myself will be talking to the 360|Flex guys tomorrow about our session. It’s actually going to be a back-to-back mega session comparing the latest and greatest on both the … Continue reading
Posted in .net, adobe, C#, coldfusion, database, development, FLEX
Tagged 360flex, adobe, adobeconnect, chat, conference, FLEX, jun heider, speaker
Leave a comment
