Mega Code Archive

 

Categories / MSSQL / Select Query

 

Get full details of all departments using

1> 2> CREATE TABLE department(dept_no   CHAR(4) NOT NULL, 3>                         dept_name CHAR(25) NOT NULL, 4>                         location  CHAR(30) NULL) 5> 6> insert into department values ('d1', 'developer',   'Dallas') 7> insert into department values ('d2', 'tester',      'Seattle') 8> insert into department values ('d3', 'marketing',  'Dallas') 9> 10> 11> 12> 13> -- Get full details of all departments. 14> 15> SELECT * from department 16> GO (1 rows affected) (1 rows affected) (1 rows affected) dept_no dept_name                 location ------- ------------------------- ------------------------------ d1      developer                 Dallas d2      tester                    Seattle d3      marketing                 Dallas (3 rows affected) 1> 2> drop table department 3> GO