Table of Contents
Problem Statement:-Solution:-Generate script for matching search string of all SP’s
Using sp_helptextUsing system view sys.proceduresGenerate modified SP’s scriptCreate Linked...
2017-01-12
1,358 reads
Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL...
2017-01-12
2,084 reads
The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like...
2017-01-12
466 reads
At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those...
2017-01-12 (first published: 2017-01-05)
1,569 reads
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...
2017-01-12
821 reads
Open any book or article about database development and administration, and I can all but guarantee that you will find a section for database documentation that describes its importance,...
2017-01-11
48 reads
This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger”...
2017-01-11
831 reads
Bit of fun this week with something that a colleague of mine noticed when playing around with SQL Server on...
2017-01-11
1,031 reads
I posted this, but here it is again. A a shot from our engineer, behind the scenes of my live...
2017-01-11
552 reads
DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...
2017-01-11
401 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
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