What’s wrong with the following code?
SELECT
a.[BusinessEntityID]
, b.[FirstName]
, b.[LastName]
FROM [HumanResources].[Employee] a
INNER JOIN [Person].[Person] b
ON b.[BusinessEntityID] = a.[BusinessEntityID]Nothing – except for my...
2013-03-05
934 reads
What's wrong with the following code?
tsqlLine number Off | Hide | Select allSELECT a.[BusinessEntityID] , b.[FirstName] , b.[LastName]FROM[HumanResources].[Employee] a INNER JOIN [Person].[Person] b ON...
2013-03-05
806 reads
The Big Data revolution will be more important than the PC or the Internet. While there were many...
2013-03-04
35 reads
The Big Data revolution will be more important than the PC or the Internet. While there were many interesting conversations last week at Strata, two new publications captured my...
2013-03-04
58 reads
This spring I’m speaking at the SQL Intersection conference. It’s a new conference, managed by SQLskills founders Kimberly Tripp and...
2013-03-04
1,198 reads
It’s the first Monday of the month, do you know where your servers are?
Hopefully, they are still in your data...
2013-03-04
821 reads
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-04
597 reads
I jumped at the opportunity to write a chapter for this book, Pro SQL Server 2012 Practices, because of all...
2013-03-04
1,706 reads
This past weekend I was back in Tampa for the sixth annual SQLSaturday. It’s a trip I always look forward...
2013-03-04
662 reads
One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you...
2013-03-04
688 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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