Exactly 6 years this month as an independent consultant.
TODAY I am embarking on my first ever SQL Server driven web site.
(So please, be gentle with me)
OMG yes, first ever - til now just never needed more than MS Access.
I'm running SQL Server 2000, and have successfully converted a message forum
Access database to SQL Server - total 3,609 records.
3 Basic Questions
1 - Question regarding indexing. In Access, I was able to just designate
whether a
column in a table was indexed or not.
In reading the SQL Server documentation I THINK I need to do this through
"Manage Indexes" / Create Index. However I'm not sure if I'm doing this
properly.
I have three columns in the table that I want to index on - CategoryChoice
(nvarchar), PostDate (datetime desc) and ThreadDate (datetime desc). All three
are non-unique.
I createed an index based on these three columns, and set it as nonclustered,
name it BoardSort The FIleGroup is checked and set as Primary.
Subquestions:
Is that all I need to do, or am I missing something? Do I need to refer to
this
index on my web site to make use of it?
2. - Auto-Incremented Number field - in Access, I just set a field to AutoNum.
In SQL Server, after import, for my CategoryChoices Table, I have a unique ID
field that was autonum. The import wizard converted the column to an INT and
I set the Identity to YES, Identity Seed to 1, and Identity Increment to 1.
Is that all I need to do to achieve the same results as an Access AutoNum?
3. On the front end of the site, for my queries, what is the syntax for a
query
regarding ownership? I recall needing to either refer to the table owner or
provide
the UserID and Password to access a table however I can't recall where in the
query to do this or when. Couldn't find any info in the documentation.
Thanks very much for any help provided
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Re: CF Forum 2000 jonhall
- RE: CF Forum 2000 Jim Davis
- RE: CF Forum 2000 Adam Wayne Lehman
- RE: CF Forum 2000 Mark A. Kruger - CFG
- RE: CF Forum 2000 Che Vilnonis
- RE: CF Forum 2000 Adam Wayne Lehman
- Re: CF Forum 2000 Jochem van Dieten
- Sort Order Best Practice Re... Les Mizzell
- Re: Sort Order Best Practic... Deanna Schneider
- Re: Sort Order Best Practic... Les Mizzell
- RE: Goofy Rows Questions Rafael Bleiweiss
- RE: Goofy Rows Questions Eric Hoffman
- RE: Goofy Rows Questions Eric Hoffman
- RE: Goofy Rows Questions Tony Weeg
- RE: Goofy Rows Questions Charlie Griefer
- RE: Goofy Rows Questions Pascal Peters