2025-11-28
405 reads
2025-11-28
405 reads
2025-11-24
762 reads
2025-11-21
766 reads
2025-11-17
676 reads
2025-11-14
727 reads
2025-08-11
139 reads
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
4,400 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,276 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
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Komplek Ruko Roxy Mas, Jl. Kh Hasyim Ashari No.6 Blok C.5 No, RT.6/RW.8, Cideng,...
Jl. Gajah Mada No.203 205, RW.207, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers