Tag Archives: sql

Using Excel to Update SQL Data

The other day a co-worker was trying to figure out how to help a client update a lot of individual fields in a SQL table.  He did not want to grant …

Tags: , , , , , , , | Posted under MSSQL, Programming/Coding | Leave a comment

Finding Referenced Objects in SQL Server

When working with a large amount of objects in sql server there are times when you want to know what columns or fields are used in other objects (views, stored …

Tags: , , , , | Posted under ASP .NET 4.0, Programming/Coding | Leave a comment

Get Set, Get Select, Which One Do I Use in SQL?

If you are like me I frequently use cursors in sql, but the other day I had created a piece of code like below. Before telling me I could do …

Tags: , , , , , | Posted under Programming/Coding | Leave a comment