Syntax for querying Microsoft SQL Server

queryMicrosoftSQL.md

create a subquery using the WITH keyword

http://msdn.microsoft.com/en-us/library/ms175972.aspx

WITH Sales_CTE (SalesPersonID, NumberOfOrders)
AS
(
    SELECT SalesPersonID, COUNT(*)
    FROM Sales.SalesOrderHeader
    WHERE SalesPersonID IS NOT NULL
    GROUP BY SalesPersonID
)

SELECT * FROM Sales_CTE;
GO

query with the NULL character : CHAR(0)

SELECT TOP 1000 [ORDERED_TEST_ID],
 [SPEC_PROC_ID]
      ,[SOURCE_ID]
      ,[GEN_SPEC_PROC_ID]
  FROM [downtime_test].[dbo].[soft_micset_procedure] where SPEC_PROC_ID = CHAR(0)