Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Find the database which have specify table name
declare @tablename varchar(100)='spt_values' declare @sql varchar(max) set @sql=' if object_id(''?..'+@tablename+''') IS NOT NULL select ''table '+@tablename+' existed in ''+ ''?''' EXEC sys.sp_MSforeachdb @sql
run
|
edit
|
history
|
help
0
select empname from emp;
by mummy, 3 years ago
Please
log in
to post a comment.
StackOverflow_53575163
nandhu
Генерация чисел в диапазоне в MS SQL
Me
Task_3_Final
STDEV vs STDEVP
Create and Insert Command Example
comparison and logical
BRYANActul
c12part2
stackse - search stackoverflow differently
select empname from emp;
by mummy, 3 years agoPlease log in to post a comment.