Why not to call stored procedure from Python?

I have similar experience, ChatGPT generated T-SQL code to calculate local min and max nodes from a function that was defined by set of values in a given table. As...

1. SELECT * FROM is not a good practice.
2. You could wrap multiple parameters into a single XML/JSON document and pass it as a SINGLE parameter into StoredProcedure

I am just wondering how I managed to do this in Microsoft Access without offshore team by myself without TDD and just for 6 month 🙂 A a developers we...

It's a pity that EF does not support synonyms

HOW about Common Table Expression expressions? You should be able to use them in View definition 🙂 And I believe that they performed are BETTER than CROSS APPLY

How to build a HELL in each SQL Server :angry:

It's amazing that usage of CLR is no-no in SQL Server , but old-fashion OLE/COM integration is acceptable 😉

I quite disagree that SQL Server nvarchar data type is limited by 4,000 bytes 😉

nvarchar [ ( n | max ) ]

Variable-length Unicode string data. n defines the string...

Support with both hands - IMHO ORM breaks encapsulation principle - why on Earth front end should knew about EACH table in database instead of calling DB operations (aka as...

With all due respect getting output parameter and return value from stored procedure via EF should not be a "black belt" coding endevour 🙁 What really escapes me that EF...

Entity Framework supports SQL server stored procedures and from June 1 it would also support natively compiled stored procedures for in-memory database.

I wish that Microsift also add support for...

Did you consider to create a view with Rand() column?

CREATE VIEW [Common].[vwRandomView]

AS

SELECT RAND() Result

and use CROSS APPLY with this view?

It worked for me 😉

SQL Azure Linked Servers - note about security:

In order to successfully create a SQL Azure Linked Server you should perform the following in SQL Azure database:

-- run this...

I do not claim that this is a next silver bullet, from my experience I simply found this capability more useful comparing with "classical" approach. When it came to your...