Articles having tag: SQL2008

SQL Server Date Format Language

By Cristhian Selah

Perform a conversion in a select, view, and Stored Procedure.

Cache IQueryable for Better LINQ-to-SQL Performance

By Zimin Max Yang

An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.

A scheduler GUI for SQL Server Agent

By Alberto Venditti

An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs

Simplify Database Operations with Generic Fluent NHibernate

By Kieran Maltz

This article describes database communication using a generic Fluent NHibernate implementation.

List SQL Server table column name as rows

By Mika Wendelius

This is an alternative for "List SQL Server table column name as rows"

Quickest way to create a .NET database application

By Subha.N

Tip to create a database application using C# .NET in the shortest time possible.

Null value converted into "default"

By VJ Reddy

I think since the SQL server expects DBNull.Value instead of null, when employeeSocialTitle is null, it is replaced with default. To avoid this the null coalescing operator can be used as follows:cmd.Parameters.Add("@employeeSocialTitle", SqlDbType.Char, 5).Value...