SQL: Updating One Table with the Values of Another Table
Thursday, March 4th, 2010For one reason or another, I often have to update rows in one table with the values in another table, and every time I do, I end up Googling for the answer.
I don’t claim to have come up with this little code snippet* but I’m putting it up here so I don’t have to waste [...]
Maintenance Plans/Backup Jobs in SQL Server
Thursday, May 22nd, 2008Nice little tutorial here:
Creating Backup Jobs in SQL Server 2005
SQL Server Tips: Shrinking Log
Will need to try.
Have gone a little crazy over current project–will be back during the next possible commercial break to blog about multiple results stored procedures and LINQ. Honest.
Click on pen to var showHover=true;
LINQ, Stored Procedures and Multiple Recordsets
Thursday, May 15th, 2008Update: This post has a follow up here: LINQ, Stored Procedures and Multiple Recordsets: How-To
I wanted to use a LINQ with a stored procedure that would return multiple recordsets, like this:
CREATE PROCEDURE spReturnMultiple
AS
–first set
SELECT value1 FROM table1
–second set
SELECT t1.value1, t2.value2
FROM [...]
SQL Server 2005’s Pivot…PIVOT, PIVVOOOOT – Ross Gellar, Friends
Friday, May 9th, 2008Every time I see SQL Server’s 2005 PIVOT, I think of that episode of Friends where Ross tries to guide his friends as they bring up the couch to his apartment.
But serious, PIVOT is one of those things that I’m still trying to wrap my brain around.
I’m currently digesting this: Pivots with Dynamic Columns in [...]
SQL Server: Data types text / ntext won’t play with sort or LIKE.
Tuesday, April 22nd, 2008Msg 306, Level 16, State 2, Line 1
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Pretty self-explanatory.
In order to compare or sort text/ntext, you need to convert it to varchar (or similar datatype that can allow compare/sort). Note, text/ntext often has a large capacity [...]
Use the Highlighter