generatedata icon indicating copy to clipboard operation
generatedata copied to clipboard

SQL Server Syntax Error

Open kingjay12 opened this issue 6 years ago • 1 comments

The syntax for SQL Server is single quote ( ' ) not double quotes ( " ).

kingjay12 avatar May 07 '19 16:05 kingjay12

Hey @kingjay12, yup! Is the content being generated incorrectly for you? I get single quotes for all strings, e.g.

INSERT INTO myTable([one]) VALUES('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]');

benkeen avatar Jul 06 '19 16:07 benkeen