Returns the right part of a string

SELECT RIGHT(firstName, 5)

Anuncios

Copy Table/ Column to another database

SELECT *

INTO .[dbo].[Table]

FROM [destination].[dbo].[Table]