SQL semaine1

De Memo

Aller à : navigation, rechercher

https://tableplus.com/

https://portal.azure.com/

CREATE TABLE francois_sales (
   id_product int,
   quantity int,
   price float
);

sp_columns grades

SELECT *
FROM grades AS A
LEFT JOIN ages AS B
ON CAST(A.Last_name AS CHAR) = CAST(B.Last_name AS CHAR);

SELECT *
INTO francois_grades
FROM grades

SELECT *
INTO francois_grades
FROM grades
WHERE 0=1

Récupérée de « https://labastie.org/memo/index.php?title=SQL_semaine1&oldid=2958 »