Always remain updated about current software development trends

Articles having tag: SQL-SERVER

LINQ to SqlDataReader

By Akram El Assas

This tip introduces how to query an SqlDataReader with Linq.

SQL Server Date Format Language

By Cristhian Selah

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

About transaction log and its truncation in SQL Server

By Mika Wendelius

Article describes basic information about transaction log behavior and truncation of the log.

Control trigger logic based on user

By Mika Wendelius

This article describes a mechanism how trigger actions bypassed based on database user information

How to guarantee a fixed amount of rows in a table

By Mika Wendelius

This tip describes how to guarantee a fixed amount of rows in a table by using triggers

Retrieving failed records after an SqlBulkCopy exception

By David Catriel

How to get a list of data rows that caused an exception (or several of them) in a SqlBulkCopy operation

How to continue a for each loop container even if its inner tasks fails (Propogate)

By Smitha_Prabith

How can we configure our foreach loop container, even when the task inside it failed

Snippet and Surround features in SQL Server 2012

By Tigya

Snippet and Surround features in SQL Server 2012.

Applying Running Total to a Result set

By Mika Wendelius

This is an alternative for "Applying Running Total to a Result set"

XML Serialization and Deserialization

By Md. Rashim uddin

XML Serialization and Deserialization in c#