This tutorial demonstrates 2 ways for you how to obtain the number of working days and business hours in SQL Server based on between date start and end date parameters.This function is more popular in doing business related to human resource, particularly in calculating salary of employee… Continue reading
This article describes How to get information of all databases by using stored procedures or SQL statement which SQL Server supports. This information includes : name, size, owner, created date, full path file name… Continue reading
This tutorial demonstrates 2 ways for you how to obtain the first/last day of previous/current/next month in SQL Server by making UDF(User Defined Function)… Continue reading
As we know SPLIT() is very popular function in many languages but unfortunately SQL Server 2000, 2005, 2008 does not have function SPLIT(), they just support some basic functions Continue reading
