Upsizing database from MS Access 03 to SQL Server

[Leaner79]

Hi,
I have developed a database that i use for Inventory. I did it in MS Access 2003.. I tried ti upsize it to our SQL server but ran into some problems.
1. All my tables, links and forms were trasfered without a problem
2. None of my Append, Update, or Delete queries were upsized..
3. How do i get my SQL database to have these? I am not very good at SQL, i heard that i should create procedures, but i have no idea, how or where to start.
Please help. Thanx

 

[SQLDenis]

>>1. All my tables, links and forms were trasfered without a problem


really? where did the forma and links go?

>>2. None of my Append, Update, or Delete queries were upsized..

nope you need to create procs


Get yourself a good book on sql server programming! I would suggest Ken Henderson's Guru books

Here are 3 template without proper error handling and return values

create procedure prEmployeeInsert
@lastName varchar(100),@firstName varchar(100),@MiddleInitial varchar(1)
as

set nocount on

insert employee
values(@lastName,@firstName,@MiddleInitial)

create procedure prEmployeeUpdate
@lastName varchar(100),@firstName varchar(100),@MiddleInitial varchar(1),@id int
as

set nocount on

update employee
set LastNem = @lastName,
FirstName = @firstName,
MiddleInitial = @MiddleInitial
where id = @id

create procedure prEmployeeDelete
@id int
as

set nocount on

delete employee
where id = @id

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions