Re: Table Creation..

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Liz (liz_at_tiredofspam.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 10:35:19 -0500

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:OkiyW$4KEHA.2704@TK2MSFTNGP10.phx.gbl...
> > I answered, that once a table is created through EM,
> > an entry is made in the sysobjects table and the syntax
> > entry is made in the syscomments table.

who knows ? .. it may be your failure to specifically say that a script is
generated that rubbed him the wrong way; a lot of these interviewers have
"book answers" they're looking for and that's all they're going to go by ..
you cannot leave out anything even if it's a very obvious implicit step

I would imagine a lot of the book answers are to be found in the prep books
for certification exams; you might do well to study some of this material
... I suspect there are quite a few very experienced and very good SQL DBAs
and programmers who would not pass one of these interviews ... which is kind
of a sad state of affairs

> The interviewers probably didn't like the fact that you mentioned that
> CREATE TABLE is stored in syscomments because this is not the case.
> Syscomments will be affected only if you have a computed column. DEFAULT
> and CHECK constraints are also stored in syscomments.
>
> You can examine the script generated by EM by clicking the 'save change
> script' button. I get the following when creating a new table. I suspect
> this is the answer to the interview question.
>
> BEGIN TRANSACTION
> SET QUOTED_IDENTIFIER ON
> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
> SET ARITHABORT ON
> SET NUMERIC_ROUNDABORT OFF
> SET CONCAT_NULL_YIELDS_NULL ON
> SET ANSI_NULLS ON
> SET ANSI_PADDING ON
> SET ANSI_WARNINGS ON
> COMMIT
> BEGIN TRANSACTION
> CREATE TABLE dbo.Table1
> (
> MyColumn int NOT NULL
> ) ON [PRIMARY]
> GO
> COMMIT
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "V.Boomessh" <anonymous@discussions.microsoft.com> wrote in message
> news:086C3142-6038-4A47-9272-75F26C01257E@microsoft.com...
> > Hai david,
> >
> > Thanks for the reply.
> >
> > The question was asked to me in an interview. I answered, that once a
> table is created through EM, an entry is made in the sysobjects table and
> the syntax entry is made in the syscomments table. The interviewer was not
> impressed with this and asked me, apart from this what else happens?.
> >
> > Was he refering to the page allocation for the new table or anything
like
> that?
> >
> > Thanks,
> > V.Boomessh
> >
> >
>
>

Quantcast