Testing Table for SELECT Statements in SQL Server

Q

How To Create a Testing Table with Test Data to try with SELECT statements in SQL Server?

✍: FYIcenter.com

A

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.

 

Using SELECT Statements and GROUP BY Clauses in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-26, 592👍, 0💬