Data Dictionary Queries for SQL Server
--Finding all details of Primary Key constraint
select * from sysobjectswhere xtype='PK'
--Finding all details of Foreign Key constraint
select * from sysobjectswhere xtype='F'
--Finding all User-Defined objects (tables, etc)
select * from sysobjectswhere xtype='U'
--Finding all System objects
select * from sysobjectswhere xtype='S'
--Finding all user names
select * from sysusers
--Finding Column Names of Particular Table
--Select Pubs Database
select c.name from sysobjects o, syscolumns cwhere o.id = c.id ando.name = 'publishers'
Tough interview question: "What are your weaknesses?"
The key to answering this age-old question is not to respond literally. Your future employer most likely won't care if your weak spot is that you can't cook, nor do they want to hear the generic responses, like you're "too detail oriented" or "work too hard." Respond to this query by identifying areas in your work where you can improve and figure out how they can be assets to a future employer. If you didn't have the opportunity to develop certain skills at your previous job, explain how eager you are to gain that skill in a new position.
Suggested answer: "In my last position, I wasn't able to develop my public-speaking skills. I'd really like to be able to work in a place that will help me get better at giving presentations and talking in front of others."
