Delphi-PRAXiS

Delphi-PRAXiS (https://www.delphipraxis.net/forum.php)
-   Delphi-News aus aller Welt (https://www.delphipraxis.net/58-delphi-news-aus-aller-welt/)
-   -   In SQL Server use `SET NOCOUNT ON` so tools taking the last modified record count won (https://www.delphipraxis.net/203915-sql-server-use-%60set-nocount-%60-so-tools-taking-last-modified-record-count-won.html)

DP News-Robot 7. Apr 2020 06:10

In SQL Server use `SET NOCOUNT ON` so tools taking the last modified record count won
 
Interesting read:*Time eating bug of the day… – Fabian S. Biehn – Google+. TL;DR: in SQL Server use SET NOCOUNT ON so tools taking the last modified record count won’t be confused by your trigger. Source: [WayBack]*Time eating bug of the day: I used a TADOQuery.ExecSQL (on Berlin) for an Up… Related:*[WayBack] sql server – […]

Weiterlesen...


Alle Zeitangaben in WEZ +1. Es ist jetzt 12:01 Uhr.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO © 2011, Crawlability, Inc.
Delphi-PRAXiS (c) 2002 - 2023 by Daniel R. Wolf, 2024 by Thomas Breitkreuz