4 ========================== TABLE : numeric_family ==================================
6 id int PRIMARY KEY NOT NULL
8 type_tinyint tinyint NULL
9 type_smallint smallint NULL
11 type_bigint bigint NULL
12 type_decimal decimal (38, 0) NULL
13 type_numeric numeric (38, 0) NULL
15 type_smallmoney smallmoney NULL
19 insert into numeric_family values (1,1,255,32767,2147483647,9223372036854775807,1000,1000,922337203685477.5807,214748.3647);
20 insert into numeric_family values (2,0,0,-32768,-2147483648,-9223372036854775808,-1000,-1000,-922337203685477.5808,-214748.3648);
21 insert into numeric_family values (3,0,0,0,0,0,0,0,0,0);
22 insert into numeric_family values (4,null,null,null,null,null,null,null,null,null);
25 ========================== END TABLE : numeric_family ===============================
28 ========================== TABLE : binary_family ====================================
31 id int PRIMARY KEY NOT NULL
32 type_binary binary NULL
33 type_varbinary varbinary (255) NULL
35 type_tinyblob image NULL
36 type_mediumblob image NULL
37 type_longblob_image image NULL
41 insert into binary_family values (1, convert (image, '555555'), convert (image, '0123456789012345678901234567890123456789012345678901234567890123456789'),
42 convert (image, '66666666'), convert (image, '777777'),
43 convert (image, '888888'), convert (image, '999999'));
44 --insert into binary_family values (2,
45 --insert into binary_family values (3,
46 insert into binary_family values (4,null,null,null,null,null,null);
48 ========================== END TABLE : binary_family ================================
51 =================================== TABLE: EMPLOYEE ================================
54 id int PRIMARY KEY NOT NULL
55 fname varchar (50) NOT NULL
56 lname varchar (50) NULL
59 email varchar (50) NULL
62 insert into employee values (1, 'suresh', 'kumar', '1978-08-22', '2001-03-12', 'suresh@gmail.com');
63 insert into employee values (2, 'ramesh', 'rajendran', '1977-02-15', '2005-02-11', 'ramesh@yahoo.com');
64 insert into employee values (3, 'venkat', 'ramakrishnan', '1977-06-12', '2003-12-11', 'ramesh@yahoo.com');
65 insert into employee values (4, 'ramu', 'dhasarath', '1977-02-15', '2005-02-11', 'ramesh@yahoo.com');
67 =============================== END TABLE: EMPLOYEE ================================
70 =============================== STORED PROCEDURE : sp_clean_employee_table =========
71 SP : sp_clean_employee_table
73 NAME: sp_clean_employee_table
76 delete from employee where id > 6000;
78 ============================ END STORED PROCEDURE : sp_clean_employee_table =========
81 ============================ STORED PROCEDURE : sp_get_age ==========================
82 NAME: procedure sp_get_age
84 NAME : fname TYPE: varchar (50) DIRECTION : in
85 NAME : age TYPE: int DIRECTION : out
87 select age = datediff (day, dob, getdate ()) from employee where fname like fname;
90 =================================== END PROCEDURE : sp_get_age =====================