SQL Training:Exercises on Tables
Exercises on Tables Exercise 1 1. Create table books with columns Bookid (it should accept numbers between 1 to 2000) Bookname (it should accept Unicode variable length characters) Bookprice (it should accept currency values) 2. Insert this given values into books table BookId: 1, BookName: Reasoning, price: 500 BookId: 2, BookName: c programming, price: 600 BookId: 3, BookName: c++ programming, price: 400 BookId: 2, BookName: .net, price: 500 BookId: 3, BookName: Java, price: 400 BookId: 1, BookName: Sql server, price: 600 3. Create Table which contain Address information with columns Countryname (It should allow 20 Unicode characters only). Statename (It should allow 20 non Unicode characters only). Cityname (It should allow allows 20 non Unicode characters only). 4. Insert only Country name and state name into address table. 5. Insert this giving data at time into Address table Countryname: India, statename: AP, ctname: Hyd Countryname: India, statename: ...