建测试数据集
DROP TABLE IF EXISTS TEST; CREATE TABLE TEST( ID INT IDENTITY(1,1), NAME VARCHAR(50), CITY VARCHAR(50) ); INSERT INTO TEST(NAME,CITY) VALUES('叶枫','上海'),('沈淼','武汉'),('罗云','成都'); DROP TABLE IF EXISTS TEST; CREATE TABLE TES建测试数据集
DROP TABLE IF EXISTS TEST; CREATE TABLE TEST( ID INT IDENTITY(1,1), NAME VARCHAR(50), CITY VARCHAR(50) ); INSERT INTO TEST(NAME,CITY) VALUES('叶枫','上海'),('沈淼','武汉'),('罗云','成都'); DROP TABLE IF EXISTS TEST; CREATE TABLE TES