且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从现有表创建新表?

更新时间:2022-05-03 22:14:17

我假设你只是说SELECT INTO:

SELECT City, State, Postalcode
  INTO dbo.PostalDB
  FROM dbo.Profile_Updated;

CREATE UNIQUE CLUSTERED INDEX p ON dbo.PostalDB(PostalCode);
CREATE INDEX ... -- you'll need to fill in these details