Category Archives: SQL Server

Store image in SQL Server database using C#

Download Source from GitHub This sample code explains you how you can store image in SQL Server database using C#. It uses ADO.Net System.Data.SqlClient namespace. Images can be stored in SQL server using SQL parameters. For storing Image, we can use “Image” data type in SQL Server. Please note that in general it’s not recommended… Read More »

How to Store file in SQL Server database using C#

Download Source from GitHub This sample code explains you how you can store files in SQL Server database using C#. It uses ADO.Net System.Data.SqlClient namespace. Files can be stored in SQL server using SQL parameters. For storing file, we can use “VARBINARY (MAX)” data type in SQL Server. Please note that in general it’s not… Read More »

Calculate delay or difference between two dates in sql server

DATEDIFF (Transact-SQL) DATEDIFF ( datepart , startdate , enddate ) You can use SQL Server DateDiff function to calculate difference between two dates. This delay can be calculated in days, months, years, minutes,hours or seconds. Here is documentation from MSDN datepart Is the parameter that specifies on which part of the date to calculate the… Read More »