USE Statement in SQL Server

Question

I am currently using USE [databaseName] in my stored procedures. However, is there a way that I can point this at the current local database and not give a database name? I know this may sound a bit obscure but its highly likely that I will be using these Stored Procedures in many different databases.

Manish Dalal · Accepted Answer · 2014-04-29 08:34:52Z

4

remove the USE [databaseName] from your stored procedure.

By default, the stored procedure will run on the current database (in which SP is created)

answered Apr 29, 2014 at 8:34

Manish Dalal

1,7961 gold badge11 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

USE Statement in SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related