"John" <John@nospam.infovis.co.uk> wrote in message
news:eDY1VahgHHA.1312@TK2MSFTNGP03.phx.gbl...
> Hi
>
> I need to check if a record exists (or not) in a table for a particular
> id. Is there a quick way to do this (like ms access dlookup function or
> similar)?
>
> Thanks
>
> Regards
>
>

> Just need to copy records from one table to another but one at a time at
> user request. So if the id (hence record) exists record is not copied
> otherwise it is copied.

John wrote:
> Just need to copy records from one table to another but one at a time at
> user request. So if the id (hence record) exists record is not copied
> otherwise it is copied.

"William (Bill) Vaughn" <billva@NoSpamAtAll_betav.com> wrote in message
news:O$PgYjhgHHA.4872@TK2MSFTNGP03.phx.gbl...
> In a multiuser DBMS application, you can indeed check to see if an ID
> exists but it won't guarantee that the ID will or will not exist a
> millisecond later as others add and remove rows in the target table(s).
>
> SELECT IDWanted FROM MyTable WHERE ID = IDWanted
>
> What problem are you trying to solve?
>
> --
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest books:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
> Hitchhiker's Guide to SQL Server 2005 Compact Edition
>
> -----------------------------------------------------------------------------------------------------------------------
> "John" <John@nospam.infovis.co.uk> wrote in message
> news:eDY1VahgHHA.1312@TK2MSFTNGP03.phx.gbl...
>> Hi
>>
>> I need to check if a record exists (or not) in a table for a particular
>> id. Is there a quick way to do this (like ms access dlookup function or
>> similar)?
>>
>> Thanks
>>
>> Regards
>>
>>
>
>