Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange behavior
Message
From
07/07/2022 07:43:49
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01684625
Message ID:
01684635
Views:
41
>>Martina
>>
>>Thank you.
>>
>>My question concerns the behavior in .NET.
>>The query runs slowly when i used command type Text, but when I make it a stored procedure, it flies.
>>In both cases I'm using the .NET connection.
>>
>Using Martina's suggestion what happens if you add SET ARITHABORT ON; as a first line in the commandtext ?
>
>If that doesn't work, you can add OPTION (RECOMPILE) at the very end of your query.
Thank you, Naomi.
Since the problem was fixed by using a stored procedure, I won't be going back to t his code.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform