Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What Is This?
Message
General information
Forum:
ASP.NET
Category:
Reporting
Title:
Miscellaneous
Thread ID:
01452075
Message ID:
01452419
Views:
49
>>>>>When I select a stored procedure in the Database Export, the name appears with ";1" next to it. Calls to SQL also appear that way.
>>>>>Here's what profiler shows:
>>>>>
>>>>>
>>>>>exec "ApexGlobal"."dbo"."sp_RPT_Assembly_Cum_LT_Detail";1 4, NULL, NULL, NULL, NULL, 0, 1
>>>>>
>>>>>
>>>>>What is this ";1"?
>>>>
>>>>Semi-colon is end of line, next line should be parameters passed to SP.
>>>>1, 4, NULL .....
>>>
>>>The semicolon and 1 appear in all reports, whether or not params are used, so that's not it.
>>
>>And that is what SQL Server Profiler shows you?
>>Did you try to execute that line in SSMS?
>
>Yes and Yes



From BOL:
; number
Is an optional integer that is used to group procedures of the same name.
This parameter is not used for extended stored procedures.

Note:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform