Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedure - insert into a different database
- Thread starter Bell1991
- Start date
use syntax as shown below and it will allow inserts into other databases from a stored proc.
obviously you need the correct fields etc.
"I'm living so far beyond my income that we may almost be said to be living apart
Code:
insert into myotherdatabase..mytable (field1) values('a')obviously you need the correct fields etc.
"I'm living so far beyond my income that we may almost be said to be living apart
- Status
Similar threads
- Locked
- Question
- Locked
- Question