Story Category: SQL Server
VOTEHow To Make Windows Apps Without Learning The Windows SDK
Emad
The beginning of the 21st century ushered in the start of the digital revolution. These were the years when the consumer technology industry saw a boom. While computers had existed for a few decades prior,… … Read more
3 years ago in database, Delphi, MYSQL, object pascal, Oracle, programming, SQL Server, windows api, Windows App API, Windows APP SDK, Windows Apps, Windows SDK
0
SQL 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… … Read more
3 years 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… … Read more
3 years 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… … Read more
4 years 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…. … Read more
4 years 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… … Read more
14 years ago in excel, SQL Server
0