Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: maccaroo
  • Content: Threads
  • Order by date
  1. maccaroo

    Using SQL Server timestamp in Access

    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...
  2. maccaroo

    Insufficient result space to convert uniqueidentifier value to char.

    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 =...
  3. maccaroo

    Is EXEC necessary for stored procs?

    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...
  4. maccaroo

    Set multiple variables at once

    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...
  5. maccaroo

    SQL Server does not exist or access denied.

    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...
  6. maccaroo

    Transaction over many tables

    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...
  7. maccaroo

    Linking table

    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...

Part and Inventory Search

Back
Top