Vikas,

Try this:

if update(StatusId2)

update mytable

set = ' Old StatusId2: ' + d.StatusId2

from mytable mt

join deleted d on d.PrimaryKeyField = mt.PrimaryKeyField -- change to correct column

and d.StatusId2...

Shane,

Try this:

declare @time1 datetime

declare @time2 datetime

set @time1 = '10:00:00'

set @time2 = '11:00:00'

select SUM(DATEDIFF(MI,stoptime, case when starttime <= @time2 then starttime else @time2 end)) AS 'Downtime'

from

where stoptime = @time1

Hope...

select d.DepartmentName, e.EmpName, e.EmpAdd, e.DepartmentId, ...etc

from Department d

join Employee e on e.DepartmentId = d.DepartmentId

Hi Rama,

Checkpoints occur automatically and they occur on a frequency that is based on the recovery interval.

Look for "Checkpoints and the Active Portion of the Log" in BOL for a...

The problem is in the way that you are building the string for the dbcc shrinkfile.

You're performing the select from sysfiles outside of the dynamic sql so it will always...

Hi,

You can do this as follows:

update my_table

set user_name = replace(user_name,'ext-','')

This will replace all occurrences of the string 'ext-' with the blank string ''. You have to be sure that...

run:

sp_dropserver 'computer-2'

go

sp_addserver 'computer-1','local'

go

restart sql server services.

Hi,

Try this:

declare @yesterday datetime

declare @today datetime

set @yesterday = convert(datetime,convert(varchar(11),dateadd(dd,-1,getdate()),106) + ' 15:00:00.000')

set @today = convert(datetime,convert(varchar(11),getdate(),106) + ' 08:00:00.000')

SELECT PONum

FROM PO

WHERE

POStatusDate > @yesterday AND POStatusDate < @today

Hope that helps,

Hi Julian,

There is a good example in BOL on how to expand hierarchies and show all of the children for a given parent without using recursion. You want to...

Sure,

Just do a select * from

By default, the results are ordered on the clustered index (unless you explicitly use an order by clause).

Hi Gabor,

This depends on the order of the clustered index. If it is ascending, the null values will be at the beginning. If it is descending, the null...

You first of all have to change the Windows server name. And then you have to change the SQL Server name in the same way you already pointed out,...

The number 120 relates to the style you want to apply. In this case, it is yyyy-mm-dd hh:mi:ss(24h).

Have a look in books online for CAST and CONVERT. It...

You want something like this. I haven't tested this out but you should get the general idea.

create #a_temp_table

(item_id int)

declare @item_id int, @location int, @qty int, @new_location int

set @new_location =...

Hi Eric,

Unfortunately there isn't any table that tells you what variables have been declare inside the sp. You can find the variables that have been declare as part of...