Hi,

both will work perfect. There is no difference wrt performance also. I have seen in some community posts that select 1 is faster than select * but if you see...

Hi,

As I understood you maintain a table where you keep all the required objects which you name as BaseObjects. Now in the same dB other objects other than the required...

Based on sql version you are using. If Sql 2016 temporal table is a good option.

otherwise some other ways -

• Trigger
• Merge statement

Hi,

This is strange if the table exists and you have permission still you get the error?

can you check the schema also?