Story Category: SQL Server
VOTESQL Server: RowVersion is not the same format as BigInt
jpluimers
A while ago, I needed to get RowVersion binary data out of SQL Server. People around me told me it is stored as BigInt. I luckily bumped into [WayBack] sql server – Cast rowversion to… – Details…
1 month ago in .NET, Database Development, Delphi, Development, Software Development, SQL Server
0
Incredible Database Development And Visualization Tool Is Built In Delphi
Embarcadero Admin
Navicat is a powerful database development tool which supports many database servers and cloud database platforms and it is built in Delphi. They have a number of different versions of Navicat with each version supporting… – Details…
5 months ago in amazon aurora, amazon rds, Azure, database, Delphi, google cloud, mariadb, MongoDB, MYSQL, navicat, object pascal, Oracle, oracle cloud, PostgreSql, programming, Showcase, SQL Server, SQLite, windows
0
FireDAC can do DBMS back-end conditional SQL via Conditional Substitution
jpluimers
Though the field-types mentioned in the problem and solution are equal (so either is wrong), the solution in [WayBack] I have a little problem with FireDAC and the TStringField and TWideStringField design time generation… – Juan… – Details…
9 months ago in Database Development, Delphi, Development, Firebird, InterBase, Software Development, SQL, SQL Server
0
In SQL Server use `SET NOCOUNT ON` so tools taking the last modified record count won’t be confused by your trigger.
jpluimers
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…. – Details…
1 year ago in Database Development, Delphi, Development, Office VBA, Scripting, Software Development, SQL, SQL Server
0
Solving Excel’s "DBCC TRACEON" error with brute force and ignorance
Sean
We use excel reports extensively for reporting. They are fast to create and everyone can read and manipulate them. However there are the occasional gotchas. In the past, I have had to muck about with… – Details…
12 years ago in excel, SQL Server
0