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
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.
Do we have vacancy for HR RECRUITER ?
what is bidirectional?
speak 1min on topic Travelling,memorable moment ,memorable day?
Recently conducted Apptitude test
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
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...
What were the occupations of the people who lived within the Mauryan Empire?
email me previous question papers of bob bank for po exams
what is placement paper?
printf("%d",printf("%d",printf("%d",printf("%s","ILOVECPROGRAM")))); whats the output
why didn't get placed so far?
i want the sample placement paper of goldman sachs urgently. please send it to me
what is difference between uv and visible spectroscopy and how to differentiate the drug compounds in uv visible region
HI SIR I WANT PREVIOUS QUESTION PAPER OF HPCL I M CHEMICAL ENGG.