Collections:
Creating a Simple Table to Test Triggers in SQL Server
How To Create a Simple Table to Test Triggers in SQL Server?
✍: FYIcenter.com
If you want to follow other tutorial examples included in this collection, you need to run this SQL script to create a simple table called fyi_users:
USE FyiCenterData; GO DROP TABLE fyi_users; GO CREATE TABLE fyi_users ( id INTEGER IDENTITY NOT NULL, name VARCHAR(80) NOT NULL, email VARCHAR(80) NULL, password VARCHAR(32) NULL ); INSERT INTO fyi_users (name) VALUES ('John King'); INSERT INTO fyi_users (name) VALUES ('Nancy Greenberg'); GO
fyi_users is created now with 2 records.
2016-10-25, 661👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want t...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...