Skip to Content
0

/** and /* meaning in sap b1

May 08 at 08:59 AM

19

avatar image
Former Member

Dear experts,

In my query reports in query manager, one of reports is running from store procedure. to run that store procedure , we have to pass the parameter. But this report is passing the parameter with /** and /*. Report is running correctly. But I want to know meaning of /** and /*. Here is parameter passing query in the report.

/**SELECT FROM [OITM] T0 **/

DECLARE @SerType as varchar(50)

/* WHERE */

Set @SerType = /* T0.U_Service */ '[%0]'

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Johan Hakkesteegt May 09 at 05:38 AM
0

Hi,

There is no functional difference.

/* This is normal SQL comment syntax. */

Anything in between /* and */ is a comment, and will not be executed by MS SQL Server. In the B1 client however, the SQL parser engine will recognize the query in the comment.

The extra * in /** is simply interpreted as being a part of a comment, and the B1 SQL parser engine only recognizes the query SELECT FROM [OITM] T0.

/**SELECT FROM [OITM] T0 **/
DECLARE @SerType as varchar(50)
/* WHERE */
Set @SerType = /* T0.U_Service */ '[%0]'

will work just the same as

/* SELECT FROM [OITM] T0 */
DECLARE @SerType as varchar(50)
Set @SerType = /* T0.U_Service */ '[%0]'

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded