Posted by Erland Sommarskog on 10/02/42 11:55

--CELKO-- (jcelko212@earthlink.net) writes:
>>> The data types are VarChar(50), and VarChar(50) respectively. <<
>
> See prior remark about camelCase. This should be NVARCHAR(n) where (n)
> was actually researched . Please post DDL, so that people do not have
> to guess what the keys, constraints, Declarative Referential Integrity,
> data types, etc.

No, Joe. Get yourself a copy of SQL 2005 and install the AdventureWorks
database. NepTune may be cheating with his homework. But he gave all
necessary information to solve the problem.

> No auditor will allow you to put "modified_date" in a table. Audit
> trails have to be separate from the data by law (see SOX compliance
> rules), by GAAP and by common sense.

I don't think AdventureWorks Bicycles has any auditor...


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: format files for use with bulk insert
• Prev in forum: Re: Hey I've got a homework problem I'm working on and am stumped.
• Thread view: Re: Hey I've got a homework problem I'm working on and am stumped.

[Reply to this message]