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,943 reads
system functions
Metadata Functions in SQL Server and Their Use Cases
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
Understanding the Metadata Function DATABASEPROPERTYEX()
Learn how to use the DatabasePropertyEX() function to query your database for settings.
2022-08-29
2,129 reads
SQL Server REPLACE
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
SQL Server System Functions: The Basics
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
Blogs
A New Word: Redesis
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
Friday Flyway Tips: Autopilot in 10 minutes
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
Visualising SQL Server in Kubernetes
The other day I came across an interesting repo on github, KubeDiagrams. What this...
Forums
Solution to a problem without using a CURSOR
Hi there to all SQL gurus So, here is the scenario. I have a...
Error when running sql server backup routine job
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
Prepare Sum of Bill Amount Having two different status with fast performance
1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...
Question of the Day
Counting Bits II
What is the result of this query in SQL Server 2022+?
select bit_count('7') See possible answers