Viewing 15 posts - 121 through 135 (of 821 total)
December 29, 2017 at 1:59 am
Good to know!
I would add a where clause to avoid empty stringDECLARE @A VARCHAR(6) = 'ABCDEF'
SELECT value FROM STRING_SPLIT(CAST(CAST(CAST(@A AS NVARCHAR) AS VARBINARY) AS VARCHAR),...
December 11, 2017 at 1:00 am
October 5, 2017 at 1:10 am
Rune Bivrin - Friday, September 29, 2017 12:04 AMBzzzt!
Tht's true! I agree.
September 29, 2017 at 1:44 am
Just to add:
There is different behavior on SQL-Server 2012....
September 26, 2017 at 8:41 am
Here the script:
CREATE TABLE dbo.LotsofIntegers1 (ID INT) WITH (DATA_COMPRESSION = PAGE);
CREATE TABLE dbo.LotsofIntegers2 (ID BIGINT) WITH (DATA_COMPRESSION = ROW);
CREATE TABLE dbo.LotsofIntegers3 (ID BIGINT) WITH...
September 26, 2017 at 2:07 am
Another "bug" is when you rename a stored procedure and run sp_helptext.
It returns the create of stored proc with the old name:
create procedure A
as
select 1 as...
September 25, 2017 at 1:48 am
September 8, 2017 at 12:48 am
August 30, 2017 at 2:08 am
July 17, 2017 at 3:28 am
July 12, 2017 at 1:01 am
Confused question!
If the author intended the primary key is clustered, this apply (from BOL):
When a constraint that created a clustered index is deleted, the data rows that...
July 11, 2017 at 1:56 am
Viewing 15 posts - 121 through 135 (of 821 total)