SQL SERVER SETTING
Sql
server notes
another thing you
should consider is maybe you installed sql server express edition. in this case
you must enter ".\sqlexpress" as server name. or . dot only
CREATE NEW
TABLE
Joining Assignment , Insert into select , database backup
create table salesman ( salesman_id int , name varchar ( 500 ), city varchar ( 500 ) , commission int ); create table customer ( customer_id int , cust_name varchar ( 500 ) , city varchar ( 500 ), grade int , salesman_id int ); create table orders ( ord_no int , purch_amt int , customer_id int , salesman_id int ) create table orders ( ord_no int , purch_amt int , customer_id int , salesman_id int , ord_date varchar ( 20 )) insert into salesman values ( 101 , 'Ramesh' , 'Nagpur' , '12.23' ) insert into salesman values ( 102 , 'suresh' , 'pune' , '15.23' ) insert into salesman values ( 103 , 'mahesh' , 'delhi' , '16.23' ) insert into salesman values ( 104 , 'raj' , 'pune' , '16.23' ) insert into salesman values ( 105 , 'rahul' , 'mumbai' , '17.23' ) ...
Comments
Post a Comment