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
4,063 reads
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
4,063 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
2,165 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
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure...
By Brian Kelley
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
Hi everyone I am using BULK INSERT to load a CSV. I have noticed...
One of our systems contains data for multiple organizations. OrgA should not be able...
We have the following requirement:- Event_Time ...
Can I use dab update to update a connection string in my Data API Builder configuration file?
See possible answers