Curtis Timson

Front End & .NET Developer

Tag

sql-server

Copy table schema to new a table

In SQL Server, SELECT INTO is used to copy data from an existing table/s into a new one. However by adding a WHERE clause which will always return false, this will prevent any data from being copied, and therefore create… Continue Reading →

Strongly typed Stored Procedure names in C#

Calling SQL Stored Procedures in ASP.NET as simple text strings can cause problems such as: Typo in Stored Procedure name. This isn’t a huge issue, but it can be costly if you later need to rebuild the application because of… Continue Reading →

© 2017 Curtis Timson — Powered by WordPress

Theme by Anders NorenUp ↑