o: CF-Talk
> Subject: RE: OT SQL Server (OK 1 More ?)
>
> OK I got it. Now that I have the primary key set with datatype int, the
> length is limited to 4. Is this correct and will this limit the table to
> records?
>
> Thanks,
> Rich
>
> -Origina
You're right.
>From now on we'll all assume that someone *else* answered your question and
not bother.
^_^
-Gel
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
This list is a bit slow, no?
about 3490853 peopls have answered pretty simple question...
~~
that you might run into a problem
if you have more than 2.1 billion records on that table.
Mike Bruce
Fig Leaf Software
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 12:32 PM
To: CF-Talk
Subject: RE: OT SQL Server (OK 1 More ?)
OK I got it. Now
200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 9:32 AM
To: CF-Talk
Subject: RE: OT SQL Server (OK 1 More ?)
OK I got it. Now that I have the primary key set with datatype int, the
length is limi
That means 4 bytes. This will limit the number but more like around 30,000.
I don't remember the exact number, anyone...?
Derek
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 9
This list is a bit slow, no?
about 3490853 peopls have answered pretty simple question...
Thanks,
Michael
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 5:32 PM
Subject:
> I have a simple question. How do you set the primary key field to
> autonumber in SQL server? I have always used Access where this is a
choice
> but don't see how to do it with SQL Server 2000.
Open Design Table view:
- clear the Null column on your PK field
- check Identity and
- make sur
Subject: RE: OT SQL Server
You must set a field to be identity and not null. You can set its seed to
any number (start autonumbering at 1000 for example.)
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 9:37 AM
To: CF-Talk
Subject: OT SQL Server
If you are using SQL Enterprise Manager, in design mode, click on the
Identity option and set it to Yes. Optionally, you can set the seed as
well.
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:36 AM
Subject: OT
SQL does not have autonumber, but you can set the field to Identity, then
set the Identity seed and Identity increment to whatever you wish. (Seed is
your start number, increment, well, that should be obvious.
Rich sat down, thought things over, and said
~~
I have a simple question.
Set the field as identity (in the lower table)
incremental, and seed are also avaialbe for configuration.
Thanks,
Michael
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:36 PM
Subject: OT SQL Server
> I have a s
It's the identity check box. Make sure you have allow Nulls deselected.
-Bill
www.brainbox.tv
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:36 AM
Subject: OT SQL Server
> I have a simple question. How do y
You set identity seed and identity increment to 1 in the design of the
table. As well make sure that the Identity box is checked.
Robert Filipovich
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:36 AM
Subject:
> I have a simple question. How do you set the primary key field
> to autonumber in SQL server? I have always used Access where
> this is a choice but don't see how to do it with SQL Server 2000.
In SQL Server, it's called an identity column.
Dave Watts, CTO, Fig Leaf Software
http://www.figl
Identity
At 10:36 AM -0400 6/13/01, ibtoad wrote:
>I have a simple question. How do you set the primary key field to
>autonumber in SQL server? I have always used Access where this is a choice
>but don't see how to do it with SQL Server 2000.
>
>Thanks,
>Rich
~~
In design view of Enterprise manager for the table, check on identity and
you see what to do next.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 10:37 AM
To: CF-Talk
Subject: OT SQL Server
I have a simple question. How do you set the primar
Select the field to be of type int and also select it to not allow Nulls and
to be a identity field. You can then select the seed (first value) and the
increment step for every new record.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 13 June 2001 15:37
To: CF-Talk
Sub
You must set a field to be identity and not null. You can set its seed to
any number (start autonumbering at 1000 for example.)
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 9:37 AM
To: CF-Talk
Subject: OT SQL Server
I have a simple question.
INT/NOT NULL/IDENTITY
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Art,
You can just use MS Access 2000's interface to hit SQL
Server 2000. You may need to download a patch from
Microsoft because there were some changes going from
SQL Server 7.0 to 2000. (URL below). It is definitely
the best way for folks who are used to MS Access to
work with a SQL Server.
Easiest thing for you to do is get enterprise manager / Query Analyzer.
You can order the SQL Server evaluation CD for about $10 off of the
microsoft web site. (I.E. Enterprise Manager and Query Analyzer do not
time out). You will not be able to run a local SQL Server on Windows
95/98
River,
Are you noticing performance problems or are you just concerned, and is this
machine a dedicated database server? Does this occur when there is no
database activity at all, or does memory usage drop as database activity
decreases?
- Chris
Christopher Cortes |Coming Q3
You can configure SQL Server (my knowledge is based on 6.5) to use a certain
amount of memory, and it will pretty much use that whether it needs it or
not. If you think it would be ok with less, you can adjust setting and
restart it.
-Original Message-
From: river [mailto:[EMAIL PROTECTE
I don't know about running it on W2K, but I have seen that exact message
over and over again, and everytime I've gotten it, I re-installed the MDAC
from MS, and all was well...
At 09:04 AM 1/25/01 -0500, you wrote:
>I'm running SQL7 on W2K Professional. When I try to use the query designer
>(r
>From http://www.sql-server-performance.com/glossary.asp :
When rows are deleted from the leaf level of an index, the are not removed
immediately. Instead, they are marked as invalid and are called ghost
records. Periodically, SQL Server starts a special housekeeping thread that
locates and remov
: Re: (OT) SQL Server?
You would probably have an easier time with storing the .dat or .mpeg files
in a directory on the webserver and just storing the url to them in the
database. This way when you go to use it, cold fusion and the sql server
aren't tied up with a 100megs of file througput
Hellow Akbar
Use image data type to that field
Thanx
Ramesh
-Original Message-
From: Akbar [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 03, 2000 7:44 PM
To: CF Talk (E-mail)
Subject: (OT) SQL Server?
hi all,
how do we store .mpeg or .dat to be exact movies in SQL server?? wat
You would probably have an easier time with storing the .dat or .mpeg files
in a directory on the webserver and just storing the url to them in the
database. This way when you go to use it, cold fusion and the sql server
aren't tied up with a 100megs of file througput each time someone wants t
according to MS's site, SQL 7.0 is 100% compliant with Win2K.
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 27, 2000 3:54 PM
To: [EMAIL PROTECTED]
Subject: OT SQL Server 7 and Win2K
I am considering
> I am considering upgrading to Win2K. Are there known issues
> between Win2K and SQL Server 7.0?
In my informal testing (on my development machine) they work fine together.
You might want to check the MS support documentation if you want to do this
on a production server, but I don't think you'l
Change to check boxes.
Your results are then made into a list, for example "1,2"
best, paul
At 12:04 PM 4/6/00 -0400, you wrote:
>Hello,
>
>Forgive the off topic post, just not sure where else to get the best answer.
>
>I have an application where I use a list box from which multiple selections
> I have an application where I use a list box from which
> multiple selections can be made. When a selection is made
> and the form is submitted, that selections ID is sent to
> the appropriate table column. If two selections are made,
> both ID's are sent to the column, etc.
>
> My problem is t
101 - 132 of 132 matches
Mail list logo