CREATE TABLE [dbo].[Fixtures](
[FixtureID] [int] IDENTITY(1,1) NOT NULL,
[KickOff] [datetime] NOT NULL,
[HomeTeamID] [int] NOT NULL,

im having trouble understanding how to perform sql statements in
workign past papers.
can anyone help me with these questions
all female students who do not live within 10km of Bristol university

I am getting this error when attempting to insert a uniqueidentifier into a
table through a Stored Procedure & even direct SQL in Query Analyzer. I have
searched and tried numerous alternatives ALL with no success ...
Perhaps there is a Database setting that I am missing?

I have a dynamic sql update statement where the expression in the update is
sent as a textual parameter to the sp.  I only add it to my dynamic update
statement without parsing it.  When one or more of the rows cause a division
by 0 error, non of the other rows get updated.  How ...

I have 3 tables, where one table contains list of products, another - spare
parts, and the third table used to join first two tables.
ProdID                SpareID        PosOnDwg
EB3B0320         1721701               9

when i do     print (@SQLSelect  + @SQLFROM + @SQLWhere)
i get
SELECT *  FROM dbo.vwSearchProperties   WHERE PropertyId > 0 AND
IsReady=1 AND dbo.vwSearchProperties.SellingStatusId =         1 AND

Just curious as to see if anyone has any experience of creating and then
writing XML files, for example, out to a client web site within a SQL Server
stored procedure.
Does or is SQL Server capable of utilizing SOAP utilities or is it more

This is a sample of some CATCH code. I call the ErrorWriteLog  sproc which
logs the error variables to a table. In a code review, it was pointed out
that if the call to the sproc fails, the error wont be caught. I was told to
remove the call as errors can be diagnosed via the SQL ...

During a code review my boss complained I was using BETWEEN to find a match
on a date column, he said it was bad practice and I should use >= AND <=
instead. Does it really make any difference? Thanks.

table A
     Col1 char(4)
     Col2 char(6)
     INSERT INTO A('1', 'ABC')

I am trying to analyze a stored procedure (which was created in SQL 2000 and
stored in SQL 2000) using SQL 2005 Database Engine Tuning Advisor.
It was working fine for others, but when I tried to analyze the stored
procedure, I am getting this error

I only have basic SQL Server programming experience and I'm trying to do
something that seems simple but I can't get it work;
I have a simple SELECT Statement in a Stored Procedure as follows:
CREATE procedure spGetIndProductivity @parm1 varchar, @parm2 datetime,

I have a bcp command to output a query to a comma-delimited text file:
bcp 'select * from tablename' queryout 'c:\Output\table.csv' -c -t \, -r \n -T
But I couldn't figure out how to surrond each field with double quotation,
so that the file will be read correctly for those field ...

Hi all,
I am using SQL Server 2005 SP2. I have a need to add / append text (one line
each time) to an o/p text file in c: (say c:\test\logdate.txt) from within a
stored proc. This adding happens frequently like a log file.

I have a stored procedure to delete all info associated with a named user
from several databases. Is the construction
delete from lightboxes.dbo.lightboxItem AS LBI
where LBI.UserName = @UserName