How to Search Stored Procedures and Ad-Hoc Queries
Photo by Louis Blythe on UnsplashHave you ever wanted to find something that was referenced in the body of a SQL query?
Maybe you...
2017-11-14
327 reads
Photo by Louis Blythe on UnsplashHave you ever wanted to find something that was referenced in the body of a SQL query?
Maybe you...
2017-11-14
327 reads
Have you ever wanted to find something that was referenced in the body of a SQL query?
Maybe you need to know what queries you will have to modify for...
2017-11-14
41 reads
TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today...
2017-11-14
330 reads
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two...
2017-11-14
338 reads
The benefits of running databases in the AWS are compelling but how do you get your data there? In this...
2017-11-14
423 reads
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
16 reads
It’s time for T-SQL Tuesday and this month’s edition is hosted by Ewald Cress (blog|twitter). It’s non-technical this month because we’re all recovering from PASS Summit. Ewald asks us...
2017-11-14
21 reads
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
17 reads
This month’s topic: Folks Who Have Made a Difference
T-SQL Tuesday is a monthly blog party for the SQL Server community...
2017-11-14
324 reads
Connect() is a yearly, Microsoft-hosted developer event that is broadcast live from New York City to developers worldwide.
The Connect(); 2017...
2017-11-13
314 reads
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...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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