Wednesday, 15 April 2015

sql server - SQL Declaration error -


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