import data from access into sql server 2005
hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into ms sqlserver 2005. I am receiving info into database access on a daily basis. so I have to do an auto job to import data from access into sql server 2005. I [...]
Answer Question
| November 24, 2010 10:30 AM
Migration, SQL Server 2005, Stored Procedures
hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into ms sqlserver 2005. I am receiving info into database access on a daily basis. so I have to do an auto job to import data from access into sql server 2005. I [...]
Answer Question
| November 24, 2010 10:30 AM
Migration, SQL Server 2005, Stored Procedures
USE DATABASE
How can I write a stored procedure which can switch to new databases using something like “use DBASENAME”, but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures within my stored procedure [...]
Answer Question
| December 2, 2007 1:40 PM
Database, SQL, Stored Procedures, USE DATABASE
How can I write a stored procedure which can switch to new databases using something like “use DBASENAME”, but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures within my stored procedure [...]
Answer Question
| December 2, 2007 1:40 PM
Database, SQL, Stored Procedures, USE DATABASE
