|
22>
23> CREATE TABLE employee (emp_no INTEGER NOT NULL,
24> emp_fname CHAR(20) NOT NULL,
25> emp_lname CHAR(20) NOT NULL,
26> dept_no CHAR(4) NULL)
27>
28> insert into employee values(1, 'Matthew', 'Smith', 'd3')
29> insert into employee values(2, 'Ann', 'Jones', 'd3')
30> insert into employee values(3, 'John', 'Barrimore','d1')
31> insert into employee values(4, 'James', 'James', 'd2')
32> insert into employee values(5, 'Elsa', 'Bertoni', 'd2')
33> insert into employee values(6, 'Elke', 'Hansel', 'd2')
34> insert into employee values(7, 'Sybill', 'Moser', 'd1')
35>
36> select * from employee
37> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
emp_no emp_fname emp_lname dept_no
----------- -------------------- -------------------- -------
1 Matthew Smith d3
2 Ann Jones d3
3 John Barrimore d1
4 James James d2
5 Elsa Bertoni d2
6 Elke Hansel d2
7 Sybill Moser d1
(7 rows affected)
1>
2>
3> -- ELSE: execute another line of script when the condition is not met:
4>
5> CREATE PROCEDURE spTableExists
6> @TableName VarChar(128)
7> AS
8> IF EXISTS(SELECT * FROM sysobjects WHERE name = @TableName)
9> PRINT @TableName + 'exists'
10> ELSE
11> PRINT @TableName + 'does not'
12> GO
1>
2> EXEC spTableExists 'employee'
3> GO
employeeexists
1>
2> drop table employee
3> drop procedure spTableExists
4> GO
1>
2>
|