update U

set <your fields go here>

from TableToUpdate U

join TableInOtherDatabase O

on U.KeyField = o.KeyField

I think the easiest way to accomplish your goal is to check for the existing record inyour application and issue the message from there. This is a pretty common...

See my FAQ on "What (good) are self joins anyway?" to answer this q.

select *

from grades g

and g.Grade = (select min(grade)

from grades inside

where g.name = inside.name

)

Index the Grade and Name...

If you use raiserror() in a trigger, the result error number 50000 is sent back to the caller. Use the SP mentioned to add your custom error message in...

Here's an old trick:

As him/her for assumptions about the business over the same time period: acquisitions, divestitures, regulatory changes, industry trends (yours, business, economy), etc.

The make some projects based on...

If you pass the test, they pay. No pass-No pay. Actually, we get to use vouchers for the 1st try so it's no money out of pocket,...

you can just add this select statement to your variable

select @Month = right(('0' + cast(datepart(mm, <yourdate>) as varchar(2), 2)

the "21 days" series are usually good for an intro. If you're already a SS7 experienced user, I would say go with Books online. You can download it...

VB is receiving "TRUE" and "FALSE" as literals. You will need to convert this to a 1 or a 0 in your script.

You can also try CBln(column). ...

As long as they're all still accessbile, you can just change your server settings to join the new domain instead of the current one. If you are changing your...

I say warn 'em in advance and kick 'em out.

alter database <dbname> set single_user with rollback after 10 seconds

have you just considered posting a maintenance window when your data bases/servers will be off line? That would be easier than trying to do all this junk.

we use it all the time for our developers. Really cool. I think there's more local restriction than server restriction. Using Visual Studio.NET, it's all integrated. ...

Log shipping is not a real-time operation. You can accomplish the same thing with less trouble by performing regular backups and send those offsite. Unless you're dealing with...

As noted, a function must return the same result every time it's called. Doesn't make a lot of sense to me but that's the rule. There are lots...