Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What Is This?
Message
Information générale
Forum:
ASP.NET
Catégorie:
Rapports
Titre:
Divers
Thread ID:
01452075
Message ID:
01452419
Vues:
50
>>>>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform