Search results for query: *

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

Thank you for the link.

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.

Thank you, already recreated the DB and ran updates again.

Thank you. Will try if it works.

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.

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.

Shift+Right Click! That's what I needed. Thank you.

This option is not available for Access.

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