SQL Snippets

SQLSnippets.sql

-- GET THE MAX ID ASSIGNABLE POSSIBLE IN A TABLE
 
 SELECT max(id) AS id FROM :TABLE;
 
 
 -- DYNAMIC QUERIES
 
SELECT * FROM (
 SELECT * FROM students S
 JOIN cursos  ON s.cursoId = c.cursoId
) WHERE (contidion = :condition OR :condition = 0) 

CREATE PROCEDURE SPWITHTEMPTABLES
    
    @VAR1 TYPE(QTY),
    @VAR2 TYPE(QTY),
    @VAR3 TYPE(QTY)
    
    AS
    
    SET NOCOUNT ON
    Declare @tabla2 Table (
        FIELD1,
        FIELD2,
        FIELD3,
        FIELD...
    )
    
    Insert Into @tabla
    SELECT * FROM TABLE_NAME
    
    Declare @tabla2 Table (
        FIELD1,
        FIELD2,
        FIELD3,
        FIELD...
    )
    
    Insert Into @tabla2
    SELECT * FROM TABLE_NAME
    
    SELECT * FROM @TABLE1
    UNION ALL
    SELECT * FROM @TABLE2
GO