SET DEADLOCK_PRIORITY LOW / NORMAL / HIGH (Transact-SQL)
Posted by Jayceooi
By setting DEADLOCK_PRIORITY, system will determine the relative importance that the current session continue processing if it is deadlocked with another session. It can be set with numeric too.For example, if SET DEADLOCK_PRIORITY LOW, this session will become victim of deadlock if other session is set to NORMAL / HIGH. While SET DEADLOCK_PRIORITY NORMAL, it will become victim only when other session is set to HIGH.[...]
Continue ReadingSET NOCOUNT ON / OFF (Transact-SQL)
Posted by Jayceooi
When SET NOCOUNT ON, the count is not returned. While SET NOCOUNT OFF, the count is returned. The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.Example,– SET NOCOUNT to ON to no longer display the count message.
SET NOCOUNT ON;
GO
SELECT TOP(5) product
FROM dbo.test
WHERE producy LIKE ‘A%’;
GO[...]
Continue ReadingSET NOCOUNT ON;
GO
SELECT TOP(5) product
FROM dbo.test
WHERE producy LIKE ‘A%’;
GO[...]
CREATE PROCEDURE (Transact-SQL)
Posted by Jayceooi
What is a SQL stored procedure? SQL stored procedure is a saved collection of Transact-SQL statements that that can take and return user-supplied parameters. It is kind of the programming for SQL. It is supporting Microsoft .NET Framework common language runtime (CLR) method with Microsoft SQL Server 2008.Example of CREATE PROCEDURE (Transact-SQL),IF OBJECT_ID ( ‘dbo.sp_test’, ‘P’ ) IS NOT NULL
DROP PROCEDURE dbo.sp_test;
GO
CREATE PROCEDURE dbo.sp_test
AS
SELECT LastName, FirstName, JobTitle, Department
FROM dbo.test;
GOAnd the stored procedure can be executed byEXECUTE dbo.sp_test;
GO
– Or
EXEC dbo.sp_test;
GO
– Or, if this procedure is the first stateme[...]
Continue ReadingDROP PROCEDURE dbo.sp_test;
GO
CREATE PROCEDURE dbo.sp_test
AS
SELECT LastName, FirstName, JobTitle, Department
FROM dbo.test;
GOAnd the stored procedure can be executed byEXECUTE dbo.sp_test;
GO
– Or
EXEC dbo.sp_test;
GO
– Or, if this procedure is the first stateme[...]
Are you a Duck or an Eagle???
Posted by Jayceooi
No one can make you serve customers well. That’s because great service is a choice. Harvey Mackay, tells a wonderful story about a cab driver that proved this point. He was waiting in line for a ride at the airport. When a cab pulled up, the first thing Harvey noticed was that the taxi was polished to a bright shine.Smartly dressed in a white shirt, black tie, and freshly pressed black slacks, the cab driver jumped out and rounded the car to open the back passenger door for Harvey .He handed my friend a laminated card and said: ‘I’m Wally, your driver. While I’m loading your bags in the trunk I’d like you to read my mission statement.’ Taken aback, Harvey[...]
Continue ReadingOBJECT_ID (Transact-SQL)
Posted by Jayceooi
OBJECT_ID (Transact-SQL) is database object identification number of a schema-scoped object.Example, it will drop table test if the table test already exist in the database.IF OBJECT_ID (N’dbo.test’, N’U') IS NOT NULL
DROP TABLE dbo.test;
GO[...]
Continue ReadingDROP TABLE dbo.test;
GO[...]
Huzzah! GMail adds drag and drop email attachments!
Posted by Wirefresh
We’ve been waiting for this one for ages. From today, Gmail users looking to include files with their email messages won’t have to faff about with all that “Attach a...[...]
Continue ReadingVLC Player victorious in media player comparison shoot out
Posted by Wirefresh
When it comes to the relatively simple task of watching a video file or getting an earful of an audio file, most people are happy to stick with whatever’s already...[...]
Continue ReadingWatch live as aircraft empty the UK skies to escape volcanic ash eruption
Posted by Wirefresh
With an Icelandic volcano currently spewing tonnes of ash towards UK skies, all aircraft are being grounded as a safety measure, with authorities mindful of the damage that hot, abrasive...[...]
Continue ReadingOlympus updates E-P1, E-P2 and E-PL1 Micro Four Thirds cameras
Posted by Wirefresh
We’ve loved the look of Olympus’s stunning E-P1, E-P2 and E-PL1 Micro Four Thirds cameras for yonks, but one of the factors that nudged us towards getting the rival Panasonic...[...]
Continue ReadingHow much do music artists actually earn online? [Infographic]
Posted by Wirefresh
For years, the music industry has been walking around like Private Fraser declaring, “Doomed – we’re all doomed!,” but what about the artists? We’ve often wondered how the online music...[...]
Continue Reading
No comments:
Post a Comment