Quick SQL Server Tip – Creating your Insert Stored Procedure

When I start to create the insert stored procedure for an existing database table I used to always start by copying an existing stored procedure (for the template only purpose) and then empty the contents of the stored procedure, then I would right-click on the table and then select, script table as 'Insert' from the … Continue reading Quick SQL Server Tip – Creating your Insert Stored Procedure

Quick Tip: Tracing SQL from your application

Tip: When your debugging some code and you want to trace the SQL that's hitting your SQL Server Database then this is how I would normally cut through all the traffic hitting the SQL database your using. Tip:- Add an application_name part to your connection string in the app.config or web.config, here is an example. … Continue reading Quick Tip: Tracing SQL from your application