Several Programming Questions

  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post July 30th, 2009, 1:52 am

I've looked everywhere to find a place that would give me a SQL statement that creates (or modifies) an integer field with auto increment (Autonumber) in my MS ACCESS database.

Below are some of the statements I've tried unsuccessfully!

"CREATE TABLE table_name
(int_field INT AUTOINCREMENT)"

"CREATE TABLE table_name
(int_field INT AUTONUMBER)"

"CREATE TABLE table_name
(int_field INT COUNTER(1,1))"

"CREATE TABLE table_name
(int_field INT UNIQUE IDENTIFIER)"

Can someone please help me!

Thanks in advance.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post July 30th, 2009, 1:52 am

  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post July 30th, 2009, 6:02 am

You can find the syntax for MySQL, SQL Server, Access, and Oracle over here.
I'd love to change the world, but they won't give me the source code.
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post July 31st, 2009, 1:40 am

What are the authentication modes in SQL Server? How can it be changed?
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post July 31st, 2009, 1:41 am

What are the properties and different Types of Sub-Queries?
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post July 31st, 2009, 1:42 am

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post July 31st, 2009, 1:43 am

What is difference between DELETE & TRUNCATE commands?
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post July 31st, 2009, 1:44 am

What are the different index configurations a table can have?
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Joined: Feb 10, 2004
  • Posts: 13455
  • Loc: Florida
  • Status: Offline

Post July 31st, 2009, 3:51 am

Assuming you're refering to SQL, "TRUNCATE" will delete all of the rows in a table and depending on the SQL engine and engine version, reset any counters such as auto_increment. "DELETE" gets rid of the entire table completely instead of just emptying it.
Strong with this one, the sudo is.
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post July 31st, 2009, 4:23 am

What type of server should we assume?
I'd love to change the world, but they won't give me the source code.
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post July 31st, 2009, 4:26 am

The two are very similar, however, the HAVING clause can be used in conjunction with aggregate clauses (like GROUP BY), which allows you a slightly different approach. Have a look here for a more detailed explanation:

http://www.itjungle.com/fhg/fhg050907-story01.html
I'd love to change the world, but they won't give me the source code.
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post July 31st, 2009, 4:29 am

Are we doing your homework or what? This is ridiculous - this is like the 5th school-esque question I've answered for you this morning. LMGTFY
I'd love to change the world, but they won't give me the source code.
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post August 3rd, 2009, 12:38 am

How do I adopt or take over a module already on CPAN?
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post August 3rd, 2009, 12:42 am

What's the difference between dynamic and lexical (static) scoping? Between local() and my()?
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post August 3rd, 2009, 12:43 am

How can I catch accesses to undefined variables, functions, or methods?
  • gkumar
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jul 28, 2009
  • Posts: 39
  • Status: Offline

Post August 3rd, 2009, 12:44 am

How do I clear a package?
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post August 3rd, 2009, 12:44 am

Post Information

  • Total Posts in this topic: 18 posts
  • Users browsing this forum: No registered users and 189 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.