FINDING TABLE PRESENTED IN WHAT DATABASES

select name from sys.databases

declare @a varchar(max)=''
select @a=@a+'
if exists(select 1 from '+name+'.INFORMATION_SCHEMA.TABLES where TABLE_NAME=''emp'')
print ''emp in :'+name+char(39)
from sys.databases
exec(@a)

result of selected number of tables

declare @a varchar(max)='dept1,dept2,dept3,EMP,EmpDup,ExamResult,ggg'
declare @b varchar(max)=''
select @b=@b+'
select * from '+replace(@a,',',' select * from ')
print(@b)

Phone numbers adding 000

CREATE TABLE TBL_PHON_NUMBS(ID INT IDENTITY,PH_NUM BIGINT)

 INSERT INTO TBL_PHON_NUMBS VALUES(1234567890),(123456789),(987456123),(65498730)

 SELECT * FROM TBL_PHON_NUMBS

 SELECT CASE WHEN LEN(CAST(PH_NUM AS VARCHAR(MAX)))=10 THEN
 LEFT(CAST(PH_NUM AS VARCHAR(MAX)),3)+'-'+
 LEFT(RIGHT(CAST(PH_NUM AS VARCHAR(MAX)),7),3)
 +'-'+RIGHT(CAST(PH_NUM AS VARCHAR(MAX)),4)
 WHEN LEN(CAST(PH_NUM AS VARCHAR(MAX)))=9 THEN
 +'0'+LEFT(CAST(PH_NUM AS VARCHAR(MAX)),2)+'-'+
 LEFT(RIGHT(CAST(PH_NUM AS VARCHAR(MAX)),7),3)
 +'-'+RIGHT(CAST(PH_NUM AS VARCHAR(MAX)),4)
 WHEN LEN(CAST(PH_NUM AS VARCHAR(MAX)))=8 THEN
 +'00'+LEFT(CAST(PH_NUM AS VARCHAR(MAX)),1)+'-'+
 LEFT(RIGHT(CAST(PH_NUM AS VARCHAR(MAX)),7),3)
 +'-'+RIGHT(CAST(PH_NUM AS VARCHAR(MAX)),4)
 ELSE CAST(PH_NUM AS VARCHAR(MAX)) END FROM TBL_PHON_NUMBS

count of signs

CREATE TABLE TBL_COUNT(ID INT)

 INSERT INTO TBL_COUNT VALUES(1),(-1),(-2),(1),(2),(-1),(1)

 SELECT * FROM TBL_COUNT

 SELECT SIGN(ID) AS ID,COUNT(ID) FROM TBL_COUNT GROUP BY SIGN(ID)