Collections:
Testing Table for DML Statements in SQL Server
How To Create a Testing Table with Test Data in SQL Server?
✍: FYIcenter.com
If you want to practice DML statements, like INSERT, UPDATE and DELETE statements, you should create a testing table. The tutorial exercise shows you a good example:
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 SELECT c.column_id as seq, c.name, x.name as type, c.max_length, c.is_nullable FROM sys.columns c, sys.tables t, sys.systypes x WHERE c.object_id = t.object_id AND c.system_type_id = x.xtype AND t.name = 'fyi_links' ORDER BY c.column_id GO seq name type max_length is_nullable 1 id int 4 0 2 url varchar 80 0 3 notes varchar 1024 1 4 counts int 4 1 5 created datetime 8 0
You should keep this table to practice other tutorial exercises presented in this collection.
2016-11-03, 719👍, 0💬
Popular Posts:
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...
How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...