RSS Feed
Twitter
Create new User in SQL Server 2005
Archive for the ‘SQL Server’ Category
Posted in 
Tags: 
Install SQL Server 2005 in Windows XP
Posted by jitendra on September 16th, 2010
Steps to Install SQL Server 2005 – Standard edition in Windows XP
Case statement in Where Clause – SQL Server – Conditional Where clause
Posted by jitendra on September 9th, 2010
Using Case statement in Where Clause in SQl Server. This script is used to create the conditional where clause
Execute dynamic Query in SQL Server
Posted by jitendra on July 16th, 2010
How to execute the dynamic query in microsoft SQL Server 2005.
Difference in “varchar” and “nvarchar” in SQL Server
Posted by jitendra on July 15th, 2010
What is the difference between varchar and nvarchar in MS SQL Server.
Get Foreign Key related details for the Table
Posted by jitendra on July 8th, 2010
Get Foreign Key related details for the Table in SQL Server
Drop Function if exist – SQL Server
Posted by jitendra on July 2nd, 2010
Drop the user define function from database if it exists.
Get the FortNight Start and End date – SQL Server
Posted by jitendra on July 2nd, 2010
Get the Fort night start and end date on the basis of input provided. if date falls in first 15 day then it will give the First Fort night start and end date and if date falls after 15 day then it gives respective start and end date.
Get First Day and Last Day of Week – SQL Server
Posted by jitendra on July 2nd, 2010
Scalar function to get the first Day and Last day of the Week in SQL Server
Get First Day and Last Day of Month – SQL Server
Posted by jitendra on July 2nd, 2010
Get the first day and last day of the month in SQL Server using Scalar functions