When I execute SQL Below I get error" ID "should declare table variable" "." But I am saying what is wrong?
DECLARE @ID underlying producer SET @ID = NEWID in (select) Select pcx_vacancyassociationId in pcx_vacancyassociationId pcx_candidate_to_pcx_vacancyId, .pcx_candidateid, @ID from pcx_vacancyassociationExtensionBase in pcx_vacancyid, pcx_candidate_to_pcx_vacancyBase.pcx_candidateid, pcx_candidate_to_pcx_vacancyBase.pcx_vacancyid
The problem is as mentioned by others is that this is not a table variable Not sure what you are going for, but what do you mean to insert values?
The pcx_vacancyassociationId values (@ID)
is not completely sure which field you want, but you can choose You can:
pcx_vacancyassociationId as 'SELECT @ID', enter pcx_candidate_to_pcx_vacancyId, pxx_candidateid, pcx_vacancyid pcx_vacancyassociationExtensionBase from table
or enter:
in both versions @ID copy Will be similar to each line, if you want random values for each row do not use the variable, just use the NEWID () in the SELECT clause.
No comments:
Post a Comment