SQL server indexed temp table

madeinstein , 
IF (SELECT object_id('TempDB..#TempTable')) IS NOT NULL
    DROP TABLE #TempTable
GO
-- 
CREATE TABLE #TempTable
(
    id int,
    name varchar(50),
    primary key (id, name)
)
-- 
INSERT INTO #TempTable
SELECT 1,'name'
-- 
SELECT * FROM #TempTable

Comments

Post a Comment

Popular posts from this blog

Parse XML to dynamic object in C#

madeinstein ,
<? xml version="1.0" encoding="utf-8" ?> < contacts > < contact id = '1' > < firstName > Michael </ firstName > < lastName > Jordan </ lastName > < age > 40 </ age > < dob > 1965 </ dob > < salary > 100.35 </ salary > </ contact > < contact id = '2' > < firstName > Scottie </ firstName > < lastName > Pippen </ lastName > < age > 38 </ age > < dob > 1967 </ dob > < salary > 55.28 </ salary > </ contact > </ contacts > public class XmlToDynamic { public static void Parse(dynamic parent, XElement node) { if (node.HasElements) { if (node.Elements(node.Elements().First().Name.LocalName).Count() > 1) { //list var item = new ExpandoObject(); var list = new List<dynamic
Read more

Tibco Rendezvous (tibrv) C# .Net example

madeinstein ,
This is an example of broadcast messaging using TIBCO Rendezvous . You can find more information about queue, dispatcher, transport and other rendezvous concepts in the TIBCO Rendezvous® Concepts pdf documentation. Command Line: Receiving messages tibrvlisten –service <port> -network "<ip-address>" –daemon <port> "<subject>" tibrvlisten –service <port> -network ";<multicast-ip-address>" –daemon <port> "<subject>" tibrvlisten -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.TEST" tibrvlisten -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.>" Publishing messages tibrvsend –service <port> -network "<ip-address>" –daemon <port> "<subject>" "<your-message>" tibrvsend -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.TEST" "He
Read more