Tag Archives: sql

Use Stored Procedure Instead of Crystal Report Query

When building any application that has data entry you will quickly require reports. These reports can come in a variety of formats. They may be in a .csv, .pdf, .rdf, …

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

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