SQL Server FAQ - Create a Testing Table for Tutorial Exercises

Home >> FAQs/Tutorials >> SQL Server FAQ

By: FYIcenter.com

How To Create a Testing Table with Test Data?

If you want to follow the tutorial exercises presented in this collection, you need to create a testing table and insert some test data, as shown in the following sample script:

CREATE TABLE fyi_links (id INTEGER PRIMARY KEY,
  url VARCHAR(80) NOT NULL,
  notes VARCHAR(1024),
  counts INT,
  created DATETIME NOT NULL DEFAULT(getdate()))
GO

INSERT INTO fyi_links VALUES (101, 
  'dev.fyicenter.com', 
  NULL,
  0,
  '2006-04-30');
GO

INSERT INTO fyi_links VALUES (102, 
  'dba.fyicenter.com', 
  NULL,
  0,
  DEFAULT);
GO

INSERT INTO fyi_links (url, id) 
  VALUES ('sqa.fyicenter.com', 103);
GO

You should keep this table and its data to practice other tutorial exercises presented in this collection.

(Continued on next topic...)