2016-06-10
1,367 reads
2016-06-10
1,367 reads
2016-06-09
74 reads
2016-06-09
1,459 reads
One of the things that is needed in quite a few functions is the object_id of a particular table/view/procedure/function in...
2016-06-08
1,158 reads
2016-06-08
1,070 reads
2016-06-07
116 reads
There’s a new conference in London next week, the InsideSQL conference on June 14th. It’s at the CodeNode venue, near...
2016-06-07
482 reads
I was writing a poorly performing UDF the other day and then wanted to replace it with a better performing...
2016-06-07 (first published: 2016-06-02)
1,740 reads
2016-06-07
1,413 reads
Microsoft has released the first version of a new sample database for SQL Server.
2016-06-06
635 reads
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers