Hcl Technologies 3+ Experienced Sql server Questions

Answer Posted / vasumathi

3)How to know How many tables contain Empno as a column in
database?

select count(c.name) as Tables,c.name as Empno from
test.sys.tables as t inner join test.sys.columns as c on
c.object_id=t.object_id and c.name='Empno' group by c.name
having count (c.name) > 0

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What kind of Issues/bugs arise in ETL projects? I would like to know few issues (critical to somewhat bugs ) normally occur in ETL process especially when testing? Domains can be banking, retail or any.

1430


Do we have vacancy for HR RECRUITER ?

1392


what is bidirectional?

1400


speak 1min on topic Travelling,memorable moment ,memorable day?

1748


Recently conducted Apptitude test

1417






your project to describe and tell about : 1. My favorite things 2. My favorite places at home 3. Animals *Choose one of them to describe *Write on your paper *If you done, Send me *Did you get it

790


Hi.. Guys Im pranitha, presently im working in a organisation & im look for job at MNC's like DELL, Delloitte, Bank of America, Genpect, etc., I have completed B.com . Pls help me...

1157


What were the occupations of the people who lived within the Mauryan Empire?

591


email me previous question papers of bob bank for po exams

2073


what is placement paper?

2161


printf("%d",printf("%d",printf("%d",printf("%s","ILOVECPROGRAM")))); whats the output

1406


why didn't get placed so far?

1198


i want the sample placement paper of goldman sachs urgently. please send it to me

3935


what is difference between uv and visible spectroscopy and how to differentiate the drug compounds in uv visible region

1605


HI SIR I WANT PREVIOUS QUESTION PAPER OF HPCL I M CHEMICAL ENGG.

1953