Help T-SQL

INFORMACION DE UNA TABLA

use DbHelpDesk
go
--
execute sp_help 'db_hd.sytcate'

SPLIT

 -- FERNANDO|ROMAN
 select SUBSTRING('FERNANDO|ROMAN',0,CHARINDEX('|','FERNANDO|ROMAN'))
 select SUBSTRING('FERNANDO|ROMAN',CHARINDEX('|','FERNANDO|ROMAN')+1,LEN('FERNANDO|ROMAN'))
 --
 -- FERNANDO
 -- ROMAN

CREACION DE TABLA A PARTIR DE UN SELECT

--
Select * into new_table  from  old_table
--