#Ben

obviously I'm trending up

Main Menu

Skip to content
  • About

Category Archives: SQL Server

Easiest Way to Run a SQL Command in ASP.NET C# Code Behind

April 1, 2013by hashben 2 Comments

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 […]

Read Article →
ASP.NET, C#, Programming, SQL Server, T-SQL

Execute SQL Query from ASP.NET Code Behind in C#

March 25, 2013by hashben Leave a comment

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 […]

Read Article →
ASP.NET, C#, Programming, SQL Server, T-SQL

SQL Inception Query – a query within a query… BRRAAWW!

March 5, 2013by hashben Leave a comment

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 […]

Read Article →
SQL Server, T-SQL

The Ultimate List of SQL Server DateTime Functions

March 4, 2013by hashben Leave a comment

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 […]

Read Article →
Programming, SQL Server, T-SQL

Code Button to Run Stored Procedure OnClick and Navigate to URL in ASP.NET

March 4, 2013by hashben Leave a comment

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 […]

Read Article →
ASP.NET, C#, Programming, SQL Server

Post navigation

Search

Categories

  • Arduino (4)
  • ASP.NET (7)
  • C# (7)
  • Crystal (1)
  • CSharp (2)
  • JavaScript (1)
  • LED (3)
  • Programming (10)
  • RFID (1)
  • SQL Server (5)
  • T-SQL (4)
  • Uncategorized (1)
  • WordPress (1)

Archives

  • September 2015 (1)
  • April 2013 (2)
  • March 2013 (9)
  • February 2013 (1)
Advertisements

Tags

AdventureWorks Arduino Ardunio Uno ASP ASP.NET Barcode Barcode reader breadboard button C# Code COM Components Cpp Crystal Crystal Report CSharp CTE Database datetime DetailsView Enter key event handler funky town HTML Hyperlink indentity INSERT Javascript jQuery led Light-emitting diode light show manufacturing Microsoft Microsoft SQL Server Microsoft Visual Studio OnClick Print Printers Printing Programming Query Recursive CTE RFID SAP select Serial serialization serial number serial numbers Serial port software Source code Source lines of code SQL SqlConnection sql database table SQL Query SQL Server Stored Procedure T-SQL technology Timestamp time stamp USB Visual Basic Visual Studio Visual Studio 2012 Web Application web application interface Webforms WordPress work order XML
Create a free website or blog at WordPress.com.
Cancel