Hi,

I see what you're trying to do. You basically want one extra column that tells you which is the parent directory to any given file/folder, if I'm not mistaken.

There...

Hi Ramesh,

The answer is, no.  You have to create the table first and then populate it like so:

insert

into my_table ([column...

Hmmm,

I've never had to do this myself.  Detaching distribution might not work because it always has a connection to it.

If that is the case you could follow Microsoft's advice on...

Good point.

You can do this entirely in T-SQL by concatenating the [text] field into a seperate table that has a field with a text datatype (thus allowing more than 8000...

select

distinct object_name(id) from syscomments where text...

Hi Jon,

Like the previous poster I'm not sure what it is you want to achieve here.

Firstly, by default, all update/delete/insert statements that users run automically run as transactions.  You don't...

Alternatively,

Just use the interal serverproperty function.

select

serverproperty('ProductVersion')

Hi,

replication is not a viable solution for redundancy in this case.

Mirroring is an option.  It is easier and cheaper to set up than clustering and can offer complete redundancy of...

Rao,

The query you've written is not falling into an infinite loop at all.  It might take a long time but that's all.  You're basically trying to calculate the MAX(Deal_Date) for...

Hi Larry,

That's a good question, which made me think

You're right in saying that when performing an update, behind the scenes SQL Server performs a...

In that case you've got to make sure that it is in the correct format when you pass it through from .net.

So you have to do this in your .net...

Hi,

As GilaMonster indicated, forget about how dates are stored in SQL Server (it doesn't really matter).  All you have to worry about is how you present it.

Look at the CONVERT...

Hi Larry,

You mentioned that you have a high level of confidence that no changes will occur to the PK so therefore each update will not require a referential integrity check...

Hi,

if you use the NOLOCK hint as you were doing so in the original example you shouldn't place any locks on the tables and it shouldn't therefore affect other users.

Hi,

I'm not so sure that running the statements in a batch is going to help performance.  You're still joining onto tab2 (albeit with less rows) but you're going to do...