Easiest Way to Run a SQL Command in ASP.NET C# Code Behind
Well… its Monday, so my post today will be exactly how I’d like my Mondays to be: Short and Sweet. I came across this method of running a SQL command […]
Category Archives: SQL Server
Execute SQL Query from ASP.NET Code Behind in C#
While working on one of my recent applications, I was tasked with generating serial numbers for a batch of products once their assembly was completed. To give you all some […]
SQL Inception Query – a query within a query… BRRAAWW!
The SQL Inception Query (queue the “BRRRAAAAWWWW!”) is otherwise known as a Recursive CTE (Yawn.) If you’re job is anything like mine, then you’ve probably had to create reports and stored […]
The Ultimate List of SQL Server DateTime Functions
A while back I happened upon this post by Pinal Dave, the self proclaimed SQL Authority. It is quite possibly the best list of SQL Server datetime functions ever created. How […]
Code Button to Run Stored Procedure OnClick and Navigate to URL in ASP.NET
Visual Studio has a lot of great features when it comes to linking your awesome ASP.NET application items to a SQL Server database without a whole lot of code knowlege […]
