I am using SQL Server 2005 and I've created 2 tables - Orders and OrderItems
and so for each order I have
multiple order items.
So far I can select 3 of the orderitem details : Menu item, quantity and

I added a class called Matrix to my App_Code File folder. It runs and
compiles fine in the Visual Web Developer but when I try to view the
page in my browser I get the following error msg.
CS0246: The type or namespace name 'Mapack' could not be found (are

I am trying to execute rather complex query, and I got query processor
error. I read the Microsoft support page and it said I should install SP4,
and I did, but the error is still there.
I am running MSDE with SP4 installed. Everything else works like a charm.

Hey yall. I'm a DBA in a company where I do NOT have the ability to
control who logs into my SQL servers as administrator, so I'm looking
for a way to uninstall the workstation components WITHOUT completely
uninstalling all of my instances.  Does anyone know how to do this?

How do I write a query where if a column, "value," is NULL I return
the phrase "No value entered" but otherwise return the column's value,
even if it is the empty string?  I'm tried to modify this simple query
SELECT value FROM meta_data

Currently running Sql Server 2005
Is it possible to issue the delete command and capture the affected rows as
xml types that will be stored in an audit table with an xml column?
Something along the lines of:

Hi experts,
I am working on SQL Server 2005.
Now i have to write a query which will extract some data from 3 to 4
tables.

I got an XML Data in UTF-8 encoding like this
Dah$)A(&li
but when I run the schema to insert data into SQL Server 2005 Express
edition, the data will become like this

In MS Access I have a routine as follows that interrogates all the
tables in the database looking for a certain value.
I am looking for similar routine for SQL Server.  It needs to to be
run at the server and not link to the tables.

i have the following problem: I like to export data from a sql-view into an
excel sheet.
The data arrives in the corresponding columns but i have the problem that in
one column data arrives with annotation "?" as well as "DM".

Is there an equivalant construction to the CASE WHEN statement that
can be used in the WHERE clause?
For example, this works:
SELECT

I have a perl script (uses sql query) that will run if there is any
update in the row. Currently, I am a trigger that sets the DateModified
field with getdate() Then my perl script looks for certain range of
modified dates and runs the necessary query.

I have namspace problem in Bulkload where if in XML data file, I have
a namespace like xmlns='urn:TMSWebServices', then in my schema I must
put xmlns:tm="urn:TMSWebServices" right?
but if I put that, then I will not able to use Bulkload as it say

Should I add retry logic avoiding deadlock as described many places
or is there an better solution if one need "check constraints" (I know
it doesn't exists 'yet') on group of rows?
CREATE TABLE myGroup (

I'm planning the disk layout for my soon-to-be-live SQL Server 2005 SP2
OLTP database.  I've read all of the "best practices" doc I can find,
and have an idea of what I will do.  I am looking for any comments and
generally having the experts shoot holes in it.  Any help is