Why don't Microsoft develope SQL in SQLSERver like a high programing language

Question

I use SQL SERver, it is really difficult and not flexible , i think it is better if it like high programing language like C#, it can import some outside library, flexible, and do many thing with this, such as i a have a column have many null value and i want to repalce null value to value in this column, i used to case when , isnull but it does not work , it is really hard, i make 5 days to find in Internet but it does not work

Answer 1

I use SQL SERver, it is really difficult and not flexible

I work with SQL Server since more then 25 year and I must say: It do what it should do and works like a charm.

if it like high programing language like C#

SQL Server supports CLR integration: https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-overview?view=sql-server-ver16
But avoid to use it, plain T-SQL performs much better.

, i used to case when , isnull but it does not work

It works for me and the rest of the RDBMS world. If it "don't work" for you, then because you are doing something wrong. But I can say what, because you only complain and didn't show any peace of code.

Answer 2

Hi，@khanh

Welcome to Microsoft T-SQL Q&A Forum!

I don't understand why you have this idea , sql has a unique role, just like if you want to develop a large-scale application software , you have to use database products: mysql and the like , and the c# you mentioned has the function of linking databases , I have used c# , and there is also a local database.

It plays an indispensable role in multiple operations. If you think it is invalid for you, it may be because you use it incorrectly and do not clearly understand its proper function.

it is recommended that you copy the code where the isnull problem occurs , so that we can help you solve the problem , instead of just complaining that it is not smart.

Finally, to sum up, c# is not a panacea, and it is irreplaceable in its respective fields.

Best regards,
Bert Zhou