临时表

–本地临时表:
–生命周期:当前会话期间(执行完关闭当前窗口,表将被释放掉)
–只能在当前会话窗口操作(增删改查),不能跨窗口(会话)访问
–临时表操作:在内存中操作

CREATE TABLE #Student(
 id INT PRIMARY KEY IDENTITY(1,1) NOT NULL,
 name VARCHAR(20) NOT NULL,
 age SMALLINT 

);
INSERT INTO #Student(name,age) VALUES('Jackey',25);
SELECT * FROM #Student

–创建全局临时表
—生命周期:当前会话期间,
—可以跨窗口(会话)访问–在其他窗口进行增删改查操作

CREATE TABLE ##Student(
 id INT PRIMARY KEY IDENTITY(1,1) NOT NULL,
 name VARCHAR(20) NOT NULL,
 age SMALLINT 
);


INSERT INTO ##Student(name,age) VALUES('Michael',30);
USE SchoolDB;
INSERT INTO Course VALUES('C# CRM项目开发')
INSERT INTO Course VALUES(15862,'Java从入门到精通')