sql server - Insert data from 1 table to another table in my local sql -

sql server - Insert data from 1 table to another table in my local sql -

hi need run script insert info server local sql server. how can identify path? cmms name of table in local sql. pc name itfg234. should replace cmms in query.

select * cmms ( select n'178670' [_idxidentity], n'e94e6a98-b71a-41ed-8b4b-f6472ba72ecd' [contract_other_datebooked] ) t;

go

if destination table exists can't utilize "select * into" or you'll error "there object named 'cmms' in database.". select creates destination table. utilize insert dbo.cmms ([column names]) instead.

the query cutting off can't see entire subquery i'll mention should give alias or may "incorrect syntax near ')'.".

if planning run command on source server recommend design run on destination server , select source using linked server or openrowset function. it's easier pull info force it.

hope helps.

sql-server