Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Arif First Query
Recursive CTE termination
MOVIE TIME
Self join producing wrong results -SQL
Microsoft SQL Server T-SQL in 10 minutes - products
Recursos_Humanos
student
CTE Recursive sample
SQL Server NULL replacement with dynamic value
c12part2