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
 Other Forums
 MS Access
 Insert stored procedure to hosted db

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-31 : 16:12:43
Ron writes "Again, not entirely SQL. But, I understand MSSQL is used to support Access databases on a site. What would be the Command to insert a new stored procedure to an Access database. Will, what I presume to be, the SQL command Create storedprocedure work against an Access db? The reason I ask is that some of the functionality within an Access query is changed due to the SQL environment eg Like % instead of like *.
Trying to avoid having to upload db subset every time I want to add new capability."

   

- Advertisement -