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 dencom 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: sqlval
  • Content: Threads
  • Order by date
  1. sqlval

    How to filter data based on the table value?

    I have a set of data coming from Oracle DB into SQL server. There is a table in SQL Server that stores key dates that should be used to filter data that comes from Oracle. Basically, I want to load only the records that were updated in Oracle after a particular date stored in SQL Server. Is...
  2. sqlval

    Create a constraint or rule?

    I need to put a constraint or rule on the column: if it's not null, it should be unique. I am not good with constraints at all. Can they be conditional? Your help is appreciated.
  3. sqlval

    Script constraints

    How can I script all keys and constraints without scripting tables? I need to transfer them from production to development, but I have already altered tables in dev, so I don't want to recreate them. Thank you.
  4. sqlval

    How to create a rule?

    I need to create a rule that one table field should be populated if there is a particular value in another field: if col1 = "Value" then col2 is not null. How do I do it? Is it a rule or an expression in the computed column property? Thank you for your help.
  5. sqlval

    Open an Access file as a different domain user

    If I open SQL Server Management studio, I can right click on the icon, pick Run As and then select a different user that can be on a different domain. Is there a way to run an Access DB as a user that is not currently logged in? I do not want to log off and log back in every time I need to...

Part and Inventory Search

Back
Top