T-SQL Tuesday #98 Round Up
Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...
2018-01-11
592 reads
Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...
2018-01-11
592 reads
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a...
2018-01-11
23 reads
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would...
2018-01-11
548 reads
Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in...
2018-01-11
1,622 reads
Link Below:
How to Change the File Extension for a Data File
In general, the file extensions that we use for SQL Server data files are MDF (Primary Data File), NDF...
2018-01-11
22 reads
Link Below:
How to Change the File Extension for a Data File
In general, the file extensions for our SQL Data Files...
2018-01-11
412 reads
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a new location.
The ALTER DATABASE command would work for moving...
2018-01-11
23 reads
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a...
2018-01-11
364 reads
I ran into an issue recently where I couldn’t get a Windows login to work with some application software. This...
2018-01-10
447 reads
Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...
2018-01-10
468 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
WhatsApp:0817819444 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten Jember,...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
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