Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
3,176 reads
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
3,176 reads
Learn about various SQL Server system functions to return meta data from SQL Server such as SERVERPROPERTY, DATABASEPROPERTYEX, DB_NAME, DB_ID, FILE_NAME, FILE_ID, FILE_IDEX, SCHEMA_NAME, SCHEMA_ID, OBJECT_NAME, OBJECT_ID and STATS_DATE.
2022-09-05
Learn how to use the DatabasePropertyEX() function to query your database for settings.
2022-08-29
1,919 reads
In this article we look at the SQL Server REPLACE function and show several examples of how this can be used to replace text values in strings.
2020-12-28
Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the ridiculous (IsNumeric()) Robert Sheldon provides an overview of the most commonly used of them.
2016-04-18
6,053 reads
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Falschgeld kaufen in essen WhatsApp….. +17785578351 Kaufen Sie 100 % nicht nachweisbare gefälschte Banknoten...
Hello, Im looking for assistance. I have this query and need to display the...
I added the Profiler module to AZure Data Studio in our ("Microsoft Azure SQL...