Script Schema and Data


I've found two problems when a user chooses the "Script Schema and Data" option:

1) DateTime values are output without being enclosed within single quotes
2) Null values are not properly outputted. The string 'NULL' should be outputted, currently nothing is outputted.


INSERT INTO [Person] (PersonID,LastName,FirstName,HireDate,EnrollmentDate,Discriminator) VALUES (13,'Zheng','Roger',12/02/2004 00:00:00,,'Instructor');

should be

INSERT INTO [Person] (PersonID,LastName,FirstName,HireDate,EnrollmentDate,Discriminator) VALUES (13,'Zheng','Roger','12/02/2004 00:00:00',NULL,'Instructor');

Other than that issue, I'm finding your app to be very useful!


christianhelle wrote Feb 10, 2012 at 11:08 AM

I'm glad you like the app. The issue you reported should be a very small fix and I'll try to resolve this issue tonight or over the weekend and publish a new build

Thanks for reporting it :)

christianhelle wrote Feb 19, 2012 at 10:29 PM

I checked in fixes for this issue in http://sqlcequery.codeplex.com/SourceControl/changeset/changes/5480d766051a

I'll publish a new build soon...