I have 2 tables , tblTOSub , and tblTrScanSub with this schema , the 2
identities are the PKeys.
CREATE TABLE [dbo].[tblTOSub](
[TOSubID] [int] IDENTITY(1,1) NOT NULL,

In an UPDATE...FROM statement, how do I instruct SQL server to specifically
lock only rows where the PK matches AND the value to be updated is
different. It looks like it puts an update lock on TblOne whether the values
differ or match.

I tried all setup for Service Pack 2 sql server
But i got error like " xxxxxx.exe  is not a valid win 32 application"
What should i do
please help on this

Wondering if someone can help me with this, I have read quite a bit about
pivot tables but none of the solutions seem to be what I am after, I have
table data that looks like this
ID                  Address

When I go to attach a DB I get the following error:
Attach database failed for Server 'MANGLER'. (Microfoft.SQLServer.Smo)
An exception occurred while executing a Transact-SQL statment or
batch.

I need to insert a line then CR/LF then another line in an nvarchar column
in a table, then at client user see it as 2 lines of text in the memo field
this does not work
INSERT INTO tblMemo (MemoCol) Values ('Hello' + nchar(13) + 'World')

I am beginner in TSQL.
A have basic question about time:
How can I compare if current time is between 06:00 - 20:00?
I want compare only time (not date).

Is there a function similar to MySQL's MD5 for encrypting data? If not, is
there a way to do this in sql 2000?

I have a query that executes in a 1-2secs in Query Analyzer, but when I try
to execute the same query from a .net app I immediately get a timeout error.
Can anyone point me in the right direction on this?
Any help appreciated!

I have synonyms in the database:
   CREATE SYNONYM MySynonym FOR MyDatabase.dbo.MyTable
There is also the view sys.synonyms with a structure like sys.objects.
How can I determine the target database and table name?

I have a SqlAgent job with a job step that uses CmdExec  to execute a VBS
script.
The error I receive is "reason: %1 is not a valid Win32 application"
Is it not possible to run VBS script from Sql Server Agent Jobs?  will I

I am trying to get select distinct to show unique record only, but it keeps
showing duplicate records if the employee have more than one jobs.  
empno  startdate    jobno
111      1/1/2006    555

Currently every one of our databases has its own audit database. We simply take the database name and append 'Audit'.
I am writing some stored procedures that will perform DDL on the audit databases / tables. I want to write a single routine that can
work with all databases and ...

I'm receiving a 8115 arithmetic overflow error on a DBCC CHECKTABLE.
The clustered index is on a datetime column.
There are 20 million rows.
Version 8.00.2039 - I'm about to patch to 2187.

I have to modify this query:
SELECT LOGCODE, CURRTS, SUPPRESSEDCOUNT
FROM SM_ALERTINIT
WHERE (CURRTS > dateadd(dd, datediff(dd, 0, getdate())-120, 0) )