Brand New to SQL and Programing

Hi Everyone

I am learning SQL using the "Trial by Fire" method.

The program is based on Pascal and SQL. The database responds to SQL statements. This is a propriety program. The operating system is NT 4.0.

<Problem>
I need to count the number of each type of EnrolStatus for this class.

<Tables Set-Up>
Table Name: Registration
Field Names: EnrolStatus
Field Names: Class_OID

The EnrolStatus is broken down into 4 groups
0=enrolled
1=finished
2=cancelled
3=No Show

The class OID is 1300

<Tried but didn't work>

SELECT * FROM REGISTRATION WHERE REGISTRATION.CLASS_OID = 1300 AND
Recordcount(*) REGISTRATION.EnrolSTATUS = 1

I am hoping someone can help me.

Forgive me if I didn't state everything with the right termsHi mlscw,

To count the number of each type of EnrolStatus of the class. You will need to use the GROUP BY clause and then take the COUNT.

select enrolstatus, count(*)
from registration
where class_oid = 1300
group by enrolstatus

HTH

Brand New Newbie

Hello all. The installation instructions in "Microsoft SQL Server: System
Administration" tell me to Create a New User Account in the 'Active
Directory Users and Computers' application. But when I search Win XP Pro for
this filename, it can't find it. I started AddPrograms and clicked on
everything that I didn't install originally. Still search could not find it.
What am I overlooking or doing wrong? Thanks in advance for any help. Jim
RichardsOn Fri, 05 Nov 2004 18:43:02 GMT, Jim Richards wrote:

> Hello all. The installation instructions in "Microsoft SQL Server: System
> Administration" tell me to Create a New User Account in the 'Active
> Directory Users and Computers' application. But when I search Win XP Pro for
> this filename, it can't find it. I started AddPrograms and clicked on
> everything that I didn't install originally. Still search could not find it.
> What am I overlooking or doing wrong? Thanks in advance for any help. Jim
> Richards

If your SQL server is running on an XP machine that is not part of a
domain, you will want the Local Users and Groups segment under
Administrative Tools (or under Computer Management, same thing.)|||Thank you Ross. Now how do I tell if my XP Pro is, or is not, part of a
domain? This stuff is all new to me. TIA, Jim.

"Ross Presser" <rpresser@.imtek.com> wrote in message
news:2aps97kwfpfw$.dlg@.rpresser.invalid...
> On Fri, 05 Nov 2004 18:43:02 GMT, Jim Richards wrote:
>> Hello all. The installation instructions in "Microsoft SQL Server: System
>> Administration" tell me to Create a New User Account in the 'Active
>> Directory Users and Computers' application. But when I search Win XP Pro
>> for
>> this filename, it can't find it. I started AddPrograms and clicked on
>> everything that I didn't install originally. Still search could not find
>> it.
>> What am I overlooking or doing wrong? Thanks in advance for any help. Jim
>> Richards
> If your SQL server is running on an XP machine that is not part of a
> domain, you will want the Local Users and Groups segment under
> Administrative Tools (or under Computer Management, same thing.)|||Jim Richards (JWRichards@.satx.rr.com) writes:
> Thank you Ross. Now how do I tell if my XP Pro is, or is not, part of a
> domain? This stuff is all new to me. TIA, Jim.

Control Panel, the System applet. Go the Computer Name tab. If it says
Workgroup under "Full computer name", you are not in a domain. If it says
Domain followed by the domain name, you are in a domain.

If you have your machine, and not connected to anyone else's, you are
very likely not in a domain.

If you are in a domain, you might have to see your system administrator
to create that user.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks Erland. I checked and mine says "WORKGROUP" so I am not on a domain.
This makes sense as my LAN includes only my PC and my daughter's PC
upstairs. Thanks for the help and have a good day. Jim Richards

"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9598EC6ADDB46Yazorman@.127.0.0.1...
> Jim Richards (JWRichards@.satx.rr.com) writes:
>> Thank you Ross. Now how do I tell if my XP Pro is, or is not, part of a
>> domain? This stuff is all new to me. TIA, Jim.
> Control Panel, the System applet. Go the Computer Name tab. If it says
> Workgroup under "Full computer name", you are not in a domain. If it says
> Domain followed by the domain name, you are in a domain.
> If you have your machine, and not connected to anyone else's, you are
> very likely not in a domain.
> If you are in a domain, you might have to see your system administrator
> to create that user.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

Brand new / totally confused / am I in the right place?

I downloaded MS SQL Server 2005 Express Edition. The MS site said that it was "easy to install, use and manage." However I'm totally confused. I'm not a total neophyte but I can't even seem to launch the program.

I have an MS SQL database powering my website. I view the database on my home computer using MS Access 2000 with an ODBC connection. MS Access 2000 however, does not let me make changes to the structure of the database. I can't add, delete or modify fields in my current tables. I can't add or delete tables. Is MS SQL Server 2005 Express Edition the proper software to perform these functions? If it is, is there a guide to helping me launch the program, connect to my MS SQL database and perform these functions? If this is not the right software, what is?

I would greatly appreciate any guidance anyone can offer.

Thanks!

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=196509&SiteID=1

HTH