Importing table from MySQL into MSSQL error with dates being 0000-00-00

Transact-SQL
21

The best explanation I found to explain the use of quadruple quotes is this a site that shows info on set-quoted_identifier-settings-in-sql-server/
I have trouble with the logic of anything more than ''double quotes'' as first single quote is delimiter and second one is part of the string , but what the 3rd 4th and sometimes fifth single quotes do is beyond me.

Pete

22

best way to vet that out is

DECLARE @OPENQUERY nvarchar(4000), @TSQL nvarchar(4000), @TSQL_SELECT nvarchar(4000), @LinkedServer nvarchar(4000)
SET @LinkedServer = 'MYSQL_ECHEANCIER'
SET @TSQL_SELECT = 'SELECT * '
SET @OPENQUERY = ' FROM OPENQUERY('+ @LinkedServer + ','''
SET @TSQL = 'SELECT nullif( project.deployment_date, ''''0000-00-00'''') as deployment_date,
nullif( project.csr_date, ''''0000-00-00'''') as csr_date FROM dbo.project '')'


print @OPENQUERY
print @TSQL