Like any other enterprise RDBMS system, SQL Server ships with several built-in functions that make developers’ T-SQL code clean, convenient and reusable. To demonstrate the efficiency of functions, say we needed to retrieve a server name for one of our SQL Server instances. Well, one of doing this would be to write a SELECT statement that would query the system view [sys].[servers] from the master database as shown in Script 1.
Read more »![Sifiso Ndlovu](https://s33046.pcdn.co/wp-content/uploads/2022/10/Sifiso.jpg)
![](https://s33046.pcdn.co/wp-content/uploads/2017/06/word-image-319a-featured-624x104.png)