Viewing 15 posts - 76 through 90 (of 177 total)
weissa, so that's the first query that you issue, right. And then based on the results, you issue a seprate query for each record you got from the first...
December 24, 2003 at 8:28 am
quote:
There is no info as of now!! on how are things implemented ( used) supposed a Master -Detail Application.
December 24, 2003 at 8:21 am
That means: a) telnet is blocked on your LAN (it is here, but that wouldn't cause a problem connecting to SQL Server), b) a router between here and there is...
December 24, 2003 at 8:18 am
Even if this is best done as two queries, it would probably be better to write it into a stored procedure rather than having CF issue a second select.
December 24, 2003 at 8:06 am
Can you post your first query and the query that CF is issuing?
December 24, 2003 at 7:59 am
As your quote suggests, an UPDLOCK hint holds the lock until the end of the transaction. Therefore, no one else can update the table while the transaction is running.
Other...
December 24, 2003 at 7:44 am
Thanks, bkelley. That is a very well thought out and written white paper. However, it confirms what I already believed; the waters here are fairly murky. It...
December 23, 2003 at 2:55 pm
quote:
why is it look like it is locking the whole table rather than the 9 records that belong to ItemID 3883790.001
December 23, 2003 at 2:37 pm
You want to look at the isntuser and isntgroup columns of syslogins.
December 23, 2003 at 2:25 pm
You want to look at the isntuser and isntgroup columns of syslogins.
December 23, 2003 at 2:25 pm
if exists (select * from tempdb.dbo.sysobjects where id = OBJECT_ID('tempdb..#tbl_temp'))
drop table [dbo].[#tbl_temp]
December 23, 2003 at 11:11 am
From Enterprise Manager, click on Data Transformation Services and then Local Packages, then right click to create a new package.
Under Tasks, you'll see that there is a type of task...
December 23, 2003 at 11:02 am
You need to build an application. You can't use query analyzer to retrieve an image. However, you can insert an image as an array of bytes and retrieve...
December 23, 2003 at 10:58 am
quote:
What I can't figure out is if there is a valid reason for it.
That...
December 23, 2003 at 10:56 am
Viewing 15 posts - 76 through 90 (of 177 total)