I work in a University and we are looking at installing a MSSQL 2000
database for students to be able to use for their final year projects.
Previously we gave them mysql and access. I am quite new to MSSQL and
was wondering if any of the stored proceedures which get created with

I am trying to create a query which should return 4 columns
Facility  | NoOfActiveApplicants | NoOfArchivedApplicants | TotalApplicants
I would be glad to even have just 3 columns since, the Total can be computed
in the display table (ColdFusion interface)

I have created the stored procedure and I want to handle the error like
Create Procedure MytablePro
as
select fld1, fld2 from mytable

I am trying to query data in an XML variable and I am having trouble
getting the data out in the format that I would like.  Given the
following XML:
declare @myDoc xml

i have a pb usine the convert and cast function from nvarchar to decimal
when i run for erxample this script
declare @TT as nvarchar(6)
set @TT = '2,2'

Hi,
I am currently trying to develope a reporting system through Enterprise
Manager.  The origional Database was an Access Database.  I tried the
upsizing wizard to put the Database onto the SQL Server which didn't work.  I

I have two tables:
workgroups (wg_id, wg_name)
workgroups_keywords (wgk_wg_id, wgk_keyword)
Each workgroup has an associated list of one or more keywords.

In SQL Server 2000, I have a field that is datetime. It stores it in this
format:
7/27/2005 8:32:44 PM
When I retrieve data from this field, I'd like to display it in the same

I have a database in MS Access, and I want to copy the table structures
and data over to a SQLExpress database. Could someone please advise what
the best way of doing this would be? Do I need to create all the tables
manually, then copy the data, or can I do it all in one fell ...

I have 2 tables:
- Users, with fields id and fullName
- Accounts, with accntID, userID, accntName, Active
I need to write a query which lists all the users, along with the

I tried all the INFORMATION_SCHEMA on SQL 2000 and
I see that the system tables hold pretty much everything I am
interested in: Objects names (columns, functions, stored procedures, ...)
stored procedure statements in syscomments table.

 I tried to Develop one Report in SQL Reporting Service. I have
installed SQL Reporting Serivice in Windows 2003 machine. SQL Server
Database is in another machine, running on Windows 2000. I developed
and deployed the report and all went fine.

Our database server has started acting weird and at this point I'm either
too sleep deprived or close to the problem to adequately diagnose the issue.
Basically to put it simply... when I look at the read disk queue length, the
disks queues are astronomical.

I've used ADO before and now SQL-DMO to execute
SQL statements on a SQL Server database.
I was just thinking if SQL-DMO has any capabilities
that ADO.NET does not have when it comes to

My table looks like this:
char(150) HTTP_REF,
char(250) HTTP_USER,
char(150) REMOTE_ADDR,