Blog Posts - Sql Server 2005



row_number in sql

Row_Number feature was introduced in SQL Server 2005.Row_Number generates a run-time column in the result set which generates sequential number to each row according to the column used in order by clause.SyntaxRow_Number() over (order...
by IT Developers Zone on Oct 14, 2013

SQL database Data backup ,.bak filies

 SQL Table Data backup   Enter in the Data server. Go to Start > Programs > SQL server 2005 > Click on SQL Server management Studio > Click on Connect > Database > select the database ( i.e. AXTESTDATABASE) . Right...
by Axapta coverage and tutorials on Jun 15, 2013

Apply operator in Sql Server

Recently in a scenario, I used Cross Apply in a query and one of my colleagues asked me why and where to use Cross Apply and what is the difference between Cross Join and Cross Apply, so I thought of publishing an article related to same.Cross Apply...
by IT Developers Zone on May 28, 2013

Output Clause in SQL Server 2005

SQL Server 2005 introduced a new TSQL feature OUTPUT clause that allows you to retrieve data affected by insert/update/delete statements easily. The OUTPUT clause returns the data that you've inserted or deleted from the table within the statement.&n...
by IT Developers Zone on May 19, 2013

Script Modul Koneksi VB ke Sql Server 2005

Kali ini saya akan memberikan script modul koneksi visual studio 2005 ke sql server 2005, sebenarnya membuat database anda bisa menggunakan microsoft acces, mysql atau sql server, menurut saya yang paling mudah yaitu menggunakan access, tetap kali in...
by teknologi komputer on May 2, 2013

passing table to function sql

CREATE TYPE TableType AS TABLE ([value] [nvarchar](100) NULL)GOCREATE FUNCTION dbo.fn_get_string_with_delimeter ( @TABLE TableType READONLY, @Separator VARCHAR(5))RETURNS NVARCHAR(500)ASBEGIN DECLARE @RETURN NVARCHAR(500) SET @RETURN = STUF...
by IT Developers Zone on Dec 28, 2012

generate weekdays in sql

In this post, I am sharing simple code to generate weekdays using Recursive CTE. Common Table Expression (CTE) was introduced in SQL Server 2005 by Microsoft. To learn more about CTE, refer Common Table Expresssion in SQL Server &...
by IT Developers Zone on Dec 27, 2012

generate weekdays in sql

In this post, I am sharing simple code to generate weekdays using Recursive CTE. Common Table Expression (CTE) was introduced in SQL Server 2005 by Microsoft. To learn more about CTE, refer Common Table Expresssion in SQL Server &...
by IT Developers Zone on Dec 27, 2012

SQL Server Versiyonları

SQL Server Versions Adı Versiyon Numarası Yayın Tarihi  Kod Adı SQL Server 2012  11.0.2100.60 1 April 2012  Denali SQL Server 2008 R2 10.50.1600.1 3rd May 2010  Kilimanjaro SQL Server 2008 10.00.1600.22 6th Aug 2008  Katmai SQL Server 2005 9...

generate list of months in sql server

In this article, I am sharing how to generate list of months with scenario where it is required?Sometimes, you would have come across the situation where you have to generate a list of months, given year. So, here is the simple script using...
by IT Developers Zone on Nov 26, 2012

generate list of months in sql server

Sometimes, you have the situation where you have to generate a list of month, given year. So, here is the simple script using CTE to generate the list of monthsdeclare @year intset @year = 2012;with mths as( select 1 as mth, DATENAME(MONTH, cast(@...
by IT Developers Zone on Nov 26, 2012

generate list of dates in sql server

Sometimes, you may come across the situation where you have to generate a list of date range, given start date and end date. So, here is the simple script using CTE to generate the list of datesdeclare @date_from datetime, @date_to datetimeset @date_...
by IT Developers Zone on Nov 6, 2012

generate list of dates in sql server

Sometimes, you have the situation where you have to generate a list of date range, given start date and end date. So, here is the simple script using CTE to generate the list of datesdeclare @date_from datetime, @date_to datetimeset @date_from = '11/...
by IT Developers Zone on Nov 6, 2012

split function in sql

The purpose of split function (table valued function) is to split a delimited string into multiple strings based on delimiter. split function takes two parametersDelimited String : The delimited string to be split in multiple strings.Delimiter : The...
by IT Developers Zone on Jul 16, 2012

split function in sql

The purpose of split function (table valued function) is to split a delimited string into multiple strings based on delimiter. split function takes two parametersDelimited String : The delimited string to be split in multiple strings.Delimiter : The...
by IT Developers Zone on Jul 16, 2012

sql calculate distance between two points

Sometimes you have to find distance between two locations given geographical points (latitude and longitude) of the locations. Below is a function that takes latitude and longitude of the locations and returns the distance between the locations in mi...
by IT Developers Zone on Jun 15, 2012

sql calculate distance between two points

Sometimes you have to find distance between two locations given geographical points (latitude and longitude) of the locations. Below is a function that takes latitude and longitude of the locations and returns the distance between the locations in mi...
by IT Developers Zone on Jun 15, 2012

gigabajt komputery-obs?uguje p?atnika

Microsoft Data Access Components (MDAC) 2.8 SP1 w polskiej wersji j?zykowej (MDAC 2.7 dla Windows 95); Przy wyborze bazy danych MS SQL Server instalowany jest motor bazy danych Microsoft SQL Server 2005 Express Edition z Service Pack 3. W tym …...

calculate working hours sql server

Calculating work hours is a very frequent need in scheduling, billing, payroll, and time and attendance applications. When the data is fetched from some punching device, you just know the timings of the punches of the employees but don't know whether...
by IT Developers Zone on Mar 8, 2012

Running Total in Sql Server

This post is related with sharing my thoughts on calculating Running Total in Sql Server. There are various ways to calculate running total in Sql Server likeUsing Nested Sub QueryUsing Self JoinUsing Cursors But, In this post I am sharing how runn...
by IT Developers Zone on Feb 19, 2012


Trending Topics

Close