T-SQL one line comments

I have aT-SQL script (for Sybase) which contains two slashes one line comments. The script works pretty well at Aqua Data Studio 4.7.2. But when I am running it calling Sybase.AdoNet2.AseClient.dll API it fails with message ‘ Incorrect syntax near “/” ‘ . I had to change these two-slashes comments to two-hyphens comments. And it works.

Also there is a page about SQL standard comments (http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/3747;pt=3524/*) It says ‘ /* … */ ‘ is only fully supported

Advertisements
This entry was posted in Sybase, T-SQL. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s