Convert database from Access2000 to SQL Server2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Convert database from Access2000 to SQL Server2000

Author

Topic

asm
Posting Yak Master

140 Posts

Posted - 2005-12-12 : 06:33:12

Hi

I want to convert the access2000 database to SQL server 2000.
I am able to convert the tables but unable to convert the query as view in SQL server 2000.

please quide how to convert the query as view in sql server 2000.

thanks

asm

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-12 : 08:12:36

the syntax for creating a view is

create view view_name 
as 
-- basically this is your query
select col1, col2, ... 
from table_name
where <where conditions>

are you facing any problem creating a view ?

-----------------
[KH]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-12 : 08:25:16

and if your queries have parameters then you need to convert them as Stored Procedure

Create Procedure your_SP
(@param dataType,.....)
as
Select .....
where col=@param....

Madhivanan

Failing to plan is Planning to fail

asm
Posting Yak Master

140 Posts

Posted - 2005-12-13 : 03:12:26

I am able to create a view in SQL Server 2000 but i want access2000 query converted into sql instead of creating a view.

asm

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-13 : 03:27:31