data protection

RE: Devlopment and production environment

• by lara31

• Redgate

• Reply

Thanks all. wish me luck!!

2005-04-05

RE: Lost Update Problem in SQL Server

• by Christoffer Hedgate

• Redgate

• Reply

To solve this you could use the HOLDLOCK and XLOCK locking hints, and run the select and update in a transaction. You could also implement some optimistic concurrency handling this yourself, I give some examples of this in my article Dealing with changing data (http://qa.sqlservercentral.com/columnists/chedgate/dealingwithchangingdata.asp). Also check Isolation Levels in BOL.

2005-04-04

RE: How do I delete the corresponding row?

• by Vladan

• Redgate

• Reply

Please copy the whole SQL again from my previous post, I have edited it in several places. sickid was changed to minsickid in the JOIN "ON" clause and also in the WHERE clause.If you still have problems, wait a minute till I create the tables here and some sample data, so that I can test […]

2005-03-31

RE: Begin Transaction and Begin Distributed Transaction

• by SJB42

• SimpleTalk

• Reply

Addict, Thanks for you response. Should really have looked in BOL myself, really. Cheers, Stephen

2005-03-31

1 reads

Identity column starting with letters, i.e. wp00001 - wp00008, is it possible?

• by orchidseb

• Redgate

• Topic

Hello,I would like to have an identity colum that increments by a seed of one and starts with two pre-defined letters that never change. Is this possible?I have created the identity colum but just need to get the two letters at the start,many thanks

2005-03-31

5 reads

RE: Drill through report as Popup window

• by Joe-Piscopo

• Redgate

• Reply

Did you ever find a solution to this problem??  Please let me know.Thank you!

2005-03-24

RE: Triggers : Name references "inserted"

• by PW-201837

• SimpleTalk

• Reply

In BOL, type "triggers" in the Index, and open the section titled "inserted tables": Using the inserted and deleted TablesTwo special tables are used in trigger statements: the deleted table and the inserted table. Microsoft® SQL Server™ 2000 automatically creates and manages these tables. You can use these temporary, memory-resident tables to test the effects of […]

2005-03-17

RE: Access via User Groups

• by Brian Kelley

• Redgate

• Reply

The group shouldn't be a SQL login. It should be a Windows login. Also, it must be a global or universal domain group. Verify the group in question isn't a local domain group. Local domain groups are not accessible outside of the domain.

2005-03-16

RE: Need help with tsql syntax

• by sellertools

• SimpleTalk

• Reply

Then again, here is article that might shed some light on speed and efficiency. http://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php seems that exists is better on larger sub-selects, where as in can be better on smaller sub-selects

2005-03-03

RE: Import external data

• by ROCNDAV

• Microsoft MSDN

• Reply

Insert into a temp table that will be blown away. Then create an "unmatched" query by left joining my existing table with the temp table. Off the top of my head INSERT INTO tblExistingTable (Field1, Field2,etc..) SELECT TT.Field1, TT.Field2, TT.Field3 FROM #TempTable AS TT LEFT JOIN tblExistingTable AS ET ON TT.SomeUniqueField = ET.SomeuniqueField --THis is […]

2005-02-15