[AccessD] [dba-SQLServer] Bulk insert and table names

Francisco Tapia fhtapia at gmail.com
Tue Oct 2 10:56:56 CDT 2007


The thing is that if you bracket your table names, you're allowed to use
them, prefixing your table names with something simple such as tblOR or
tblIN would have clearly avoided the problem you faced.  Similarly with
indexes, you've found a great way to keep them unique by including the
tablename in the index.

On 10/2/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> LOL.
>
> Thanks for that but I suppose my question was a jab at the concept that I
> would HAVE to make sure that my table / field names did not collide with
> some list of reserved words inside of SQL Server.  The SQL Server
> programming team should ensure that I can name my tables and fields
> whatever
> I want to, NOT look up my proposed table field names in THEIR (ever
> changing) list of keywords and change my choice if it collides with their
> reserved words.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin W Reid
> Sent: Tuesday, October 02, 2007 9:07 AM
> To: dba-sqlserver at databaseadvisors.com; 'Access Developers discussion and
> problem solving'
> Subject: Re: [AccessD] [dba-SQLServer] Bulk insert and table names
>
> Hi John
>
> List of SQL 2000 Keywords
>
> http://msdn2.microsoft.com/en-us/library/aa238507(SQL.80).aspx
>
>
> Martin
>
>
> Martin Reid
> Telephone: 02890974465
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...



More information about the AccessD mailing list