Autonumber Disadvantages

Oct 4, 2004


i am thinking of using autonumber in my table which is more likely to grow over time. but i am also concerned that what if the records get too much? is there is any other fields to use instead of autonumber? is uniqueidentifier a better option? i have a bit of discussion with my colleague about this matter.

any help is appreciated

View 1 Replies


Disadvantages Using Functions

Jun 21, 2001

any disadvanges using user defined functions calling from stored procedures??

View 4 Replies View Related

Advatnages And DisAdvantages Of

Apr 7, 2004

Running SQL Server as a DOMAIN user account.

View 3 Replies View Related

DisAdvantages Of Cursors.

Apr 25, 2008

can any one help me out to know the disadvantages of the cursor

View 2 Replies View Related

Disadvantages Of Using Uniqueidentifier (Tell Your Tale)

Nov 19, 2003

Dear SQL...

I'm about to use uniqueidentifier and NEWID() for my new DB,

The DB may grow wild and I want to super safely create connections between tables,
so it would not just rely on numbers (that can B changed) as used with IDENTITY...

If U had some BAD experience with this or if U have any tips I can use please let me know


Should I take any special steps when using index on it ?

View 6 Replies View Related

Advantages And Disadvantages Of The Replication Ty

Feb 13, 2008

Can any body help me in knowing what are the advantages and disadvantages of all the three replication types?

View 1 Replies View Related

Advantages/Disadvantages To Using More Than One Database

Dec 18, 2006

I have a content site where everything is currently in one SQL ServerDB. As I add features to the site, for example message boards andblogging, does it make sense to put those features in a separatedatabase? What would I lose and gain in doing so? Thanks so much.Erik

View 3 Replies View Related

Advantages/Disadvantages B/w Being Consultant Vs Employee

Jul 12, 2000

Hi, I would appreicate your opinion/ feed back about Being consultant vs Being employee.

What are the advantages/disadvantages.
Does consultant makes more money than an employee and why so

Thanks for your response

View 2 Replies View Related

Advantages&&Disadvantages Logical Drives

Aug 5, 2005

Are they're any real disadvantages or advantages in having 1 massive disk partioned to create 2 logical drives (not including the C drive) and separating the SQL Database File & Transaction Log so that it doesnt reside on the same logical drive?

After all, it is still a single disk.


View 3 Replies View Related

Disadvantages Of Running 80 Compatibility On 2005?

May 1, 2007

I have a hosted solution where the web host provider tells me I'm running on a 2005 platform, but when I check the DB options, it shows compatibility level 80. The provider tells me I'm not losing any performance by running in the lower compatibility mode. Is this truly the case? What else am I losing out on in terms of features or capabilities?

View 11 Replies View Related

I Want To Know About Advantages And Disadvantages Of SQL Server 2005.

Nov 23, 2007

Please reply me as soon as possible.

View 4 Replies View Related

Disadvantages Of The Implementation Of Explicit Subtypes On MS SQL 7 And Oracle8i/9i

Jul 20, 2005

Could some database expert post some information or link about that?thanksJanusz

View 1 Replies View Related

Olap Mining - Advantages, Disadvantages And Problems

Jan 19, 2007

Dear Sirs and Madams,

it's quite hard to find informations about OLAP mining I think. So I have some questions to you:

What advantages do I have by using Olap Mining instead of "normal" mining (relational databases)?
Is it just faster or are there other advantages?

What are the disadvantages? The data can be overaggregated (no detailled results), can not? Are there other disadvantages?

What problem do I have to face?

Whats going on with empty cells?

Thank you very much in advance and have a nice weekend.


View 1 Replies View Related

Transact SQL :: Disadvantages Of Column Store Index

Nov 3, 2015

What are the disadvantages of columnstore index in Sql Server 2012

View 4 Replies View Related


Apr 23, 2001

Is there a way to create a(unique id) that will automatically populate similar to ACCESS?

View 1 Replies View Related


Oct 13, 1998

I am new to SQL Server coming from Access.

In the work I do, I use the Autonumber data type often.

I don`t seem to see this SQL Server.

Can you tell me if this can be done?

View 1 Replies View Related

Autonumber In Sql?

Aug 3, 2001

Is there somthing in SQL Server similar to the AutoNumber feature in access that could just add a new key + 1 of the last when you add a new entry?

View 1 Replies View Related


Jan 18, 2004

sql 2000

how can i set primary key to autonumber?
i created a form with this table,, i get error when trying to insert..
i want "id: column to autogenerate number
.................................................. .....................................

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'Guestbook.dbo.guestbook'; column does not allow nulls. INSERT fails.

View 4 Replies View Related


Mar 21, 2006


When we open the table in design view in access , we get to see the Data type as Autonumber there.

How to find out the same in SQL Server , if a particualar column fas been made autonumber & how to make it also .


Bharat Butani

View 3 Replies View Related

Autonumber In SQL

Apr 25, 2007

create table tblCasCodeDef(
CasCodeDefID int not null,
CasCodeDef char(100),
CasDescription char(200),
EngineeringFunction char(100),
Primary Key (CasCodeDefID));

In this code, how can I make my CasCodeDefID as autonumber?


View 2 Replies View Related

Sql AutoNumber

May 7, 2007

I have my id column set to automatically provide and id number, I am wondering if it will be ever be posible that it will give me the value ZERO 0.

( I want to use the lack of the 0 id, as a way to detect that there is need of a new record in a client application)

View 2 Replies View Related

AutoNumber Vs. Key

Oct 11, 2005

Hi,I am always confused about what to use as the key for a table.Let's say I have a company-employee table.[company]---*[employee]My co-worker likes to use an AutoNumber or Counter as the key for the[employee] table (and everything).I personally use an actual key set for the [employee] table.So, his table will have one (Autonumber or LONG) column as the key. Thecompany_id is just another attribute.Mine, on the other hand, has 2 columns as the key. (i.e.) company_id +employee_idSo, what is the deal?--[color=blue]> There is no answer.> There has not been an answer.> There will not be an answer.> That IS the answer!> And I am screwed.> Deadline was due yesterday.>> There is no point to life.> THAT IS THE POINT.> And we are screwed.> We will run out of oil soon.[/color]

View 22 Replies View Related


Feb 1, 2008

I am working with a database that was created in Lotus and importingit into Access. There are hundreds of clients in this data base thathave to be kept and maintained. My question is: Will auto numberingwork with this imported file and will it continue with the last numberthat is in there and if not can I make it work and how?

View 2 Replies View Related


Jul 20, 2005

Sorry for my bad English but I'm Italian...I have a question for you...I delete all record of table but I don't set autonumber field to start withvalue 1....What do you do to set a values of autonumber colomns with Query Analizer orEnterprise Manager...???

View 4 Replies View Related


Jul 20, 2005

HiPlease help me URGENTHow do i make an tableField with aAuto-Incr, the same like in an access DB where it'scalled AutoNumberThanx in advance__________________________________________________ ________________ FlemmingPaulsen ICQ#: 270065050 Current ICQ status: + More ways to contact me__________________________________________________ ________________

View 1 Replies View Related


Jul 20, 2005

What is the equivelant to Autonumber coming from an Access World toSQL?TIAMichael

View 8 Replies View Related

SQL Problem With AutoNumber.....

Nov 13, 2006

The problem is to set the right type for "Question_number"/"test_str"I have tried Integer & String (Long Integer din't work....)
The field: Question_number is autonumber dim test_str as Integerdim besvart_str as string
answer_str = "Yes" Date_now = nowtest_str = 187 Dim StrSQL_2 as String = "UPDATE q_a_table" & _ " SET answer = '" & answer_str & "' WHERE [q_a_table].Question_number= '" & test_str & "'"

View 1 Replies View Related

AutoNumber In SQL 2005

Jun 15, 2007

Hello friends,
I am using Sql Server 2005 in my web application. In one scenario I had made one field of a table as Autonumber by keeping its datatype as int and then setting its Identity flag to true. Now is there any inbuild function that can give us the next number tat will be generated if a new record will be inserted. This is needed in the case if last 1 or 2 records are deleted for e.g.
last record has value 7 and if the record is deleted still for the new record the number generated will be 8 i.e. after 6 there is 8. So by any means can we get the next number, or can we keep that autonumber to move serially even in case some record is deleted it should go for the max + 1 number.
Please let me know.
Thanks & RegardsGirish Nehte

View 5 Replies View Related

Can I Add An Autonumber To A View?

Dec 8, 2003

Hi, I wish to build a datagrid, in an ASP.NET web page, in which I can display a row from a table and when I press a button it will move forward one row. The table is not currently sorted and I need it to be alpahbetical by surname so I thought if I created a view I could sort the table alphabetically on the 'Surname' column. I know that ADO.NET when used in disconnected mode doesn't have a cursor which remembers the last row it was on so I thought if I could create an autonumber on the view then I could use this in the 'where' clause to tell SQLserver which line I wished to select by taking the previous number and adding one. Is this the best way to do this and if so could some one give advice on how to write the line of the query that will add in an autonumber column


View 2 Replies View Related

Autonumber Problem

Aug 16, 2004

Hello all,
Has anyone heard about autonumber fields skipping one number? For example, the autonumber field goes from 39 to 41 skipping 40 entirely.

Any ideas why it would do this?
Thanks in advance.
Richard M.

View 2 Replies View Related

MSSQL Autonumber

Oct 27, 2004


I remember in Access. You can set the primary to increment by one automatically. Can you do this in



View 3 Replies View Related

Autonumber Is Resetting

Dec 1, 2004

i am using autonumber as a primary key in one table. in my app., row from that table will be moved to another table after some time but that autonumber is important. when there are no any data in first table, and new row is inserted, autonumber starts from 1 which i don't want as there will be data redundancy when it will be moved to another table. so is there any way i can force the autonumber to start from previous value rathe than 1?

View 2 Replies View Related

SQL Server Autonumber??

Jan 24, 2005

Hello, Does anyone know if there is an equivalent of an autonumber in SQL Server.
I have tried to use the int field which I thought preformed the same function but it doesn't work for me.
The code I am using is as follows
aCommand.CommandText = "INSERT INTO customers (customer_Name, customer_Id) " + "VALUES (@customer_Name, @customer_Id)";
aCommand.Parameters.Add("@customer_Name", SqlDbType.NVarChar, 50).Value = TextBox1.Text;
aCommand.Parameters.Add("@customer_No", SqlDbType.Int, 4).Value = SqlDbType.Int;

However, when I try this my customer Id is not unique., and my cusomer_Id is always set to to the number 8.
Does anyone know a way around this?

View 1 Replies View Related

Copyrights 2005-15, All rights reserved