SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table toerase_SQL
(
    SqlSource varchar(max)
)
insert into toerase_SQL 
select   
'select '+ CHAR(13)+CHAR(10)+
'VendorId, '+ CHAR(13)+CHAR(10)+
'VendorName, '+ CHAR(13)+CHAR(10)+
'VendorAddress, '+ CHAR(13)+CHAR(10)+
'VendorCity, '+ CHAR(13)+CHAR(10)+
'VendorState, '+ CHAR(13)+CHAR(10)+
'VendorZip '+ CHAR(13)+CHAR(10)+
'from Vendor '

1 rows affected

-- Or just don't close the string so the line-break is captured
insert into toerase_SQL 
select   
'select
VendorId,
VendorName,
VendorAddress,
VendorCity,
VendorState,
VendorZip 
from Vendor '
1 rows affected

select * from toerase_SQL


SqlSource


select 
VendorId, 
VendorName, 
VendorAddress, 
VendorCity, 
VendorState, 
VendorZip 
from Vendor

select
VendorId,
VendorName,
VendorAddress,
VendorCity,
VendorState,
VendorZip 
from Vendor