Via query analyzer:
update my_table
set target = 15
will only update certain rows. And when I run this query on a specific row,

I'm having a problem with a group concatenation on a temporary table in a
stored procedure.
I've been looking at
http://omnibuzz-sql.blogspot.com/2006/06/concatenate-values-in-column-in-sql.html

I'm creating a stored procedure which needs to store the result of a query
on table 1 into a text field column in table.
Let's say, table 1 contains:
Col1   Col2

using a DMV (or by using cross joins / apply ) is it possible to see a list
of the queries done by a single user or on a single connection.
I have tried looking inthe plan cache and the query text.
eg.

In my SQL Server 2000, I would like to create a VIEW across two databases on
two database servers.
How do I do that?
Thanks for help.

Justs can't make this happen with CTE.
I have 2 tables: "Teams" and "Members". In the teams table I have
ParentTeamID and TeamID, relating different teams with each other. In the
members table I have TeamID and MemberID, relating member to different teams.

Is there a way to display the 'name' of the month rather than the 'number'
using the Datepart function?

I'm creating a view that uses several tables in one SQL Server but needs
also to query another database on another SQL Server.
In access query works like this.
SELECT ProdottiRicambi.*, Ricambi.Codice AS Expr1, Ricambi.Ricambio_I AS

I need opinions and suggestions on how to accomplish the following:
Two users of my application that do not have communication to each other start the same process simultaneously.  I need
to stop the second process from occurring.
The app calls a stored proc.  My current idea is to ...

Using QA logged in as admin, is it possible to test queries using different
username/passwords? What is the syntax?
I've given read only permission for 2 tables to a user, but they give me an
error invalid name. But other users have access.

I have been asked to find out if it is possible to see if a row is being updated.  Suppose this is executed
UPDATE Table1 SET column1 = Column1 WHERE Column1 = 1
Are there DMVs or other places that are available that would enable a question like:  Does the row where column1 = 1 on

DELETE FROM does not reset Identity type cols
TRUNCATE TABLE does reset Identity type cols but requires that no FKs
reference the table
Is there any other solution ?

I have created an access app that passes 3 parameters from a form, to a
stored procedure that performs a query
I need to be able to save the result to a excel file without creating a
table in sql server.

Am getting 'bad syntax near 'IF' ???
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name =
'dbo.Vw_ChildNotDenied')
    BEGIN

Hi dear all experts:
  i have a quick question for this varbinary data type, i m doing
some project for this datatype because of MD5 (SQL2k5), however the
function HashBytes only return as varbinary data type when i save into