Search results for query: *

Thanks. To be honest, I'm not that familiar with timestamp fields. What I do understand (I think), is that it doesn't represent an actual time, but rather a the sequence of the record's last modification in relation to the other records in the database. I'm hoping it should then be possible...

Hi I've got an database with SQL Server back-end and Access front-end. The Server gets a number of audit records from a (totally separate) remote db. The table on the remote db has a timestamp field which allows us to work out the exact order the fields were entered (very important). The...

Thanks James. Tried it and so far it works great!

Hi I'm getting this very irritating message when trying to print a uniqueidentifier field for debug info. Here is my proposed string: PRINT 'AuditID = ' + CAST(@AuditID AS varchar) I've tried using an intermediary variable, but I just get the same error there: SET @strPrint =...

Thanks I'll stick on the EXEC's from now on.

Hi I'm a little confused as to the need to use EXEC when calling a stored procedure. Sometimes I get errors and sometimes I get away with it. Is there a way to tell when it is necessary? For example, I have a stored proc which runs 3 other stored procs. The 1st and 3rd one only work with...

Hi. Is it possible to set a number of variables in one shot in something like the following manner: SELECT TOP 1 field1, field2, field3 FROM MyTable ORDER BY SortOrder ASC SET @f1 = field1 SET @f2 = field2 SET @f3 = field3 The point is that I don't want to have to run a separate SELECT query...

Hi. I'm trying to connect to a remote database. If I use Query Analyser, no matter what method I use, I seem to get this one error message: "SQL Server does not exist or access denied." The method I'd like to use is something like the following: SELECT field1, field2, field3 FROM...

Hi. I need to insert a number of new records using a transaction. The script will be something like: Create new record in Table1. Create new records in Table2, with Table2FK linked to Table1PK Create new records in Table3, with Table3FK linked to Table2PK ... Is is possible to create a...

PHV, you're my hero! It works great. Thanks soooo much.

Hi guys. Thanks in advance for any advice. My problem involves 3 tables: Users, UserTypeLinks, UserTypes. The Users table essentially has personal details, and the UserTypes table has rights data. The UserTypeLinks table links these together by storing the primary key from each of the other two...