Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - Tables created with extension "SP_" in master database can be accessed from any database

Dec 27 2011 10:31AM by Nirav   

Stored procedures, tables and views created in the master database prefixed with sp_ can be accessed from any user database.

use master
create table sp_user_data (col1 tinyint)

insert into sp_user_data values(1)
insert into sp_user_data values(2)
insert into sp_user_data values(3)
insert into sp_user_data values(4)

use UserDatabase
select * from sp_user_data 
Read More..   [32134 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Nirav
37 · 5% · 1593
5
 
2
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Tables created with extension "SP_" in master database can be accessed from any database" rated 5 out of 5 by 5 readers
SQL Server - Tables created with extension "SP_" in master database can be accessed from any database , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]