This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
use tempdb | |
GO | |
CREATE TABLE dbo.Test1 | |
( | |
Col1 VARCHAR(6) NOT NULL PRIMARY KEY | |
) | |
GO |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--Use a Where Clause | |
SELECT Posts.Title | |
,acceptedAnswer.CreationDate | |
,Users.DisplayName | |
FROM dbo.Posts | |
LEFT JOIN dbo.Posts AS acceptedAnswer | |
ON acceptedAnswer.Id = Posts.AcceptedAnswerId | |
LEFT JOIN dbo.Users | |
ON acceptedAnswer.LastEditorUserId = Users.Id |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT Posts.Title, acceptedAnswer.CreationDate, Users.DisplayName | |
FROM dbo.Posts | |
LEFT JOIN dbo.Posts AS acceptedAnswer | |
ON acceptedAnswer.Id = Posts.AcceptedAnswerId | |
INNER JOIN dbo.Users | |
ON acceptedAnswer.LastEditorUserId = Users.Id | |
WHERE Posts.PostTypeId = 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT Posts.Title,acceptedAnswer.CreationDate | |
FROM dbo.Posts | |
LEFT JOIN dbo.Posts AS acceptedAnswer | |
ON acceptedAnswer.Id = Posts.AcceptedAnswerId | |
WHERE Posts.PostTypeId = 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
private void GenerateToast(string title, string message) | |
{ | |
var template = ToastTemplateType.ToastImageAndText02; | |
var toastXML = ToastNotificationManager.GetTemplateContent(template); | |
var images = toastXML.GetElementsByTagName("image"); | |
images[0].Attributes[1].NodeValue = @"file://**FilePath**\**FileName.png"; | |
var textNodes = toastXML.GetElementsByTagName("text"); | |
textNodes[0].AppendChild(toastXML.CreateTextNode(title)); | |
textNodes[1].AppendChild(toastXML.CreateTextNode(message)); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<Window.TaskbarItemInfo> | |
<TaskbarItemInfo ProgressValue="{Binding StepsProcessed}" ProgressState="{Binding ProgressState}" /> | |
</Window.TaskbarItemInfo> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN TRAN | |
DECLARE @SourceExtension INT = 2443 | |
,@DestinationExtension INT = 2544 | |
,@WhatToCopy VARCHAR(255) = 'Console Buttons' --Console Buttons,Contact Favourites,Extension Favourites,Queue Favourites,Shortcuts | |
--DON'T CHANGE ANYTHING BELOW HERE!!! | |
NewerOlder