Posts Tagged ‘sql server’

Autonumber using Stored Procedure in SQL Server

Friday, January 16th, 2009

Today I want to share an SQL Server 2005 stored procedure to make autonumber. This stored procedure provide two numbering templates.

autonumber template #1: ..
autonumber template #2: <1DIGIT-YEAR><1DIGIT-MONTH>.

sqlserver-autonumber

(more…)

Tags: ,
Posted in Programming | No Comments »

How to Migrate Access Database to SQL Server 2005

Monday, November 24th, 2008

I found a solution to import Access Data to SQL Server easily using SQL Server Migration Assistant (SSMA) for Access. This is a free tool from Microsoft that comes with three versions (Access, Oracle, and Sybase).

(more…)

Tags: , , ,
Posted in Programming, Tips and Trick | No Comments »