sqlparser

CREATE FUNCTION dbo.isoweek (@DATE datetime) 
RETURNS INT 
WITH EXECUTE AS caller 
AS 
BEGIN 
     DECLARE @ISOweek INT 


     SET @ISOweek= datepart(wk,@DATE)+1 
          -datepart(wk,CAST(datepart(yy,@DATE) AS CHAR(4))+'0104') 

sqlparser

CREATE TABLE datatype  
  (fld0 GENERICTYPE, 
   fld1 CHAR(2), 
   fld3 NCHAR(1)); 

sqlparser

SELECT department_id, 
       Min(salary)  
FROM   employees  
GROUP  BY department_id  

sqlparser

SELECT last_name  
FROM   employees  
WHERE  salary > (SELECT salary  
                 FROM   employees  
                 WHERE  last_name = 'Abel'); 

sqlparser

SELECT (( ( a - b ) - c ))  
FROM   t 

sqlparser

CREATE FUNCTION sales.Fn_salesbystore 
  (@storeid INT)  
RETURNS TABLE  
AS  
  RETURN 0; 

sqlparser

SELECT *  
FROM   dual  
WHERE  1=-1  
       AND(1!=2  
            OR 2^=3)  
       AND 3<>4  
       AND 4>5; 

sqlparser

vFirstName := 'Roger';
vLastName  := 'Smith';
vSSN       := 999999999;

sqlparser

DELETE FROM job_history jh  
WHERE  employee_id = (SELECT employee_id  
                      FROM   employee e  
                      WHERE  jh.employee_id = e.employee_id  
                             AND start_date = (SELECT Min(start_date)  
                                               FROM   job_history jh  
                                               WHERE  jh.employee_id = e.employee_id)  
                             AND 5 > (SELECT Count( * )  
                                      FROM   job_history jh  
                                      WHERE  jh.employee_id = e.employee_id  

sqlparser

SELECT DISTINCT 
       p.name      AS product, 
       p.listprice AS 'List Price', 
       p.discount  AS 'discount' 
FROM   production.product p