If you use the IF EXISTS clause, it will only fire the code within the BEGIN...END when it finds the existance of a row in the SELECT statement. I'm pretty...

Actually that's only going to delete individual rows. The EXISTS followed by a full DELETE with no WHERE clause is probably what he's looking for.

Do you mean you need to delete all records where the value = 'Checked' or if any value = 'Checked' you're going to delete all values?

If the former, simply make...

In general terms, it doesn't sound bad, but it all comes down to the code, the indexes and the code, and if I didn't mention it, the code. How you...

Yeah, what he says.

I know you're just learning this stuff. When you get an error, look it up in the Books Online. It'll mostly tell you what's going on. In...

Hopefully this won't kick up too much mud.

I agree with some of what Steve Schmechel is advocating (if not necessarily his approach in advocating it). In working with our...

The thing to remember is that logically, they are different operations. They occur at different points in the query processing and will affect data in different ways. The JOIN criteria...

Nice article. You do a good job of outlining the issues that come up on the database side of things when doing Agile development.

The one thing I'd add is that...

shwetha004 (2/13/2008)

---

hi ppl!!

i tried using the select into statement.however, i cant see how i can actually merge two columns from two tables into one.

maybe i shud explain further.

Table1 has (userid,username,password,email,status)

Table2...

Yeah, 3 votes & one quasi-intelligent post aren't exactly encouraging. Still, you got a response. I posted on Services Center Operations Manager (SCOM) and got zip. Either no one is...

I've used both. In terms of messaging, there's no real difference between them. Blackberries are a bit more sophisticated in terms of actually chatting to other human beings, but when...

Jeff,

Doesn't the fact that floats are imprecise estimates represent a pretty major possible problem in using them in financial calculations? At least that's what I've always been told. I mean...

If you can't purchase tools, here's another option.

Definitely a backup and a restore is the much easier route. All the data, all the structure, all the statistics, just as they are in production. Done.

However, you can create...

There's this company, called Microsoft. Searching their web site can find all sorts of stuff.