Hcl Technologies 3+ Experienced Sql server Questions
- 20 Answers
- 52845 Views
- HCL, Patni, I also Faced
- E-Mail Answers
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 you will do when you struck in traffic ?
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.
A frog wants to climb a pole which is 15 feet in height, frog can jump 3 feet every minute after which he rests for a minute where he slips down 2 feet. How much time will the frog take to reach the top of the pole?
email me previous question papers of bob bank for po exams
speak 1min on topic Travelling,memorable moment ,memorable day?
Sks Microfinance
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?
If anybody knows the recruitment procedure of IOTL & POWER MECHANICAL. send me the placement papers if u hav... very urgent ...
HI SIR I WANT PREVIOUS QUESTION PAPER OF HPCL I M CHEMICAL ENGG.
Recently conducted Apptitude test
what is placement paper?
my question is : reverse a string in COBOL program (please write a code asap) input file: 1234abcdef abc*$#1___ cdef____ghi a_z_k_h___ 4_3_2_1___ ______5678 output file: 8765_____ 1_2_3_4__ h_k_z_a__ ihg____ghi 1#$*cba__ fedcb4321
Do we have vacancy for HR RECRUITER ?
What are the frequently asked questions for interview in capital iq company ?
