More than 3 years have passed since last update.

T-SQLでサクッとテーブル作ってselectで一覧取得までやる

SQLDatabase

Posted at 2023-02-04

はじめに

良く忘れるからメモ残す

コマンド

CREATE TABLE users (
    id INT PRIMARY KEY IDENTITY,
    name NVARCHAR(50) NOT NULL,
    email NVARCHAR(255) NOT NULL,
    created_at DATETIME DEFAULT GETDATE()
);
INSERT INTO users (name, email) VALUES ('John Doe', 'johndoe@example.com');
SELECT * FROM users;

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up