First of all thanks ...

I have no problems to explain my intention. Hopefully you can continue to make suggestions.

I'm build the application using Visual Basic, myself. The new application is...

If I add the following:

SELECT c.name AS ExistingColOnTab2

FROM sys.columns AS c

JOIN sys.types AS t ON c.user_type_id=t.user_type_id

WHERE c.object_id = OBJECT_ID('dbo.tab2')

GO

it shows the column's name already exist in the "tab2" table.

There...

Sorry, I means automatically within an application (Visual Basic 2012)

suppose I have an application, which is used to fill and use the information stored in a database, suppose (after a...

It is working fine, thanks.

now, my dubit is: how to use @sql content to create the new table?

Could you suggest some idea?

The tbtab1 column B is TEXT

The new tbtab2 columns should be INT