Though I am a SQL Server geek...still answering this 😉

"ed" is used in ORACLE on command-line-interface to open the current running query in editor.

-Lokesh :smooooth:

Very good question in-deep. Great reply by Paul.

Thanks for posting 🙂

- Lokesh

If you want to restrict a set of users, first create a ROLE, assign those users to this ROLE and REVOKE all the permissions for this ROLE on a speicfic...

Taken:-)

Next time for sure..

- Lokesh

It did not work for me as well.

Another tip:

Select your table in MSMS and then press Ctrl+F1

Check the result set with FK'S 😉

Don't know the exact structure of the employee table you are using, but code would be something like this-

ALTER TABLE dbo.Employee

ADD CONSTRAINT CONS_Salary_nlt_500

CHECK (Salary > 500)

Trigger is not required here. Alter your table to include CHECK Constraint with specified salary options.

Check the below links for implementation:

http://msdn.microsoft.com/en-us/library/ms188258%28v=sql.105%29.aspx

http://msdn.microsoft.com/en-us/library/ms179491%28v=sql.105%29.aspx

+1

I agree with Jeffrey, best way is to test, test and test. I know some people writing about in-consistent query plans when using table variables over temp tables. But this...

I tried this on my PC. Same result.

Seems to be a limitation of DROP_EXISTING :unsure:

Thanks Gail. At-least I have got some food-for-thought on SQL Server security now 🙂

Regards

Lokesh

Thanks Vikrant. These links are really helpful.

Regards

Lokesh

Thanks Chris for correcting me 🙂

OUPUT Clause after a dml statement also gives the latest updated/inserted/deleted rows. Check this link for more details:

msdn.microsoft.com/en-us/library/ms177564.aspx

Lokesh

Hi Vivek...I am confident that this can be done with SSIS easily. Kindly explore.

-Lokesh