 Sybase Tips & Tricks by Rob Verschoor | |||
|
|
|
||||||
|
Randomly selected quiz question (want a different question? Click here): May 2010 Here is an issue I stumbled over last week. As you probably know, ASE 15 has increased the maximum length for many identifiers from 30 to 255 bytes. This applies to names of tables, column, stored procedures etc. I was writing a small piece of SQL to run a particular test, and as it happened, the length of a name of one of the tables exceeded 30 bytes. The reason I noticed the identifier was longer than 30 bytes was that this error message was raised: 1> create table this_is_a_kinda_long_table_name (a int) 2> go Msg 103, Level 15, State 205 Server 'SYB155', Line 1 The identifier that starts with 'this_is_a_kinda_long_table_nam' is too long. Maximum length is 30.Now that's strange! I double-checked I wasn't accidentally connected to a 12.x server (and I wasn't, this was ASE 15.5). But if this was ASE 15.x, then a 31-character table name should be allowed.... What's going on here? Click here for the answer. More ASE quiz questions: 2011 - 2010 - 2009 - 2008 - 2007 - 2006 - 2005 - 2004 - 2003 - 2002 - 2001 For a randomly selected quiz question, click here. |
||||||
|