Yes, you are correct that is one way of doing.

I want to do add or drop column in a stored procedure.

When you add a column programmatically it will add...

I know primary key and foreign key relationship among tables and here my table doesn’t have relation ship with other tables on Identity Column. It is a Staging table.Purpose of...

Hey, I found a solution for this and here it is.

Problem:

I have a Staging Table which updates every week incrementally.

Per Business, in this table every week I have to...