SQL Server tutorial part 5 - View

-




In SQL, a view is a virtual table based on the result-set of an SQL statement.
A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

Sample table


Sample Data




Create View



Update View


Drop View




Please donate and support at https://www.paypal.me/Rajcoomar

Comments

Post a Comment

Popular posts from this blog

C# Windows Form : PetCare

-
Image
A desktop application using C# as technology. the application is titled as "PETCARE" a system that a pet shop or veterinary can use it to store basic information about the pet's owner, details about the pet and the purpose of the visit to the veterinary or pet shot. The system also contained a stock management module that is used to track pet food purchased by a particular customer Screen Shot You can login both as a staff or as the admin. the admin has the privilege to register new staff and view details about transaction and other sensitive information. The system encrypt user password using MD5 algorithm The home screen of the application You can either add a new pet with its owner details or add another pet belonging to the same owner. both can be done using the same form below. and each pet owner will be given a reference number. Veterinary can use the application to store information about treatment done for a particular pet Can t
Read more

Fake Call Android Application

-
Image
Fake Call android apps enable the user to simulate a call from their smartphone by entering a number were the apps will detect the network carrier and display it on screen. Technologies used are: Java, Xml. Developed using android studio and tested using android API 25 (Android 7.1.1 - Nougat) Screen Shot Select Fake Call from the home screen  Select Fake Call and enter the a phone number. You can also select to  call after a time interval as well  Click call to simulate a fake call with the network carrier, phone number as information Download Click here to download the game or source code Please donate and support at https://www.paypal.me/Rajcoomar
Read more

Car Wash System vb.net

-
Image
This software consists of a database that save the registration number of every vehicle being wash along side with the date, type of wash made and price Screen Shot Source Code To view records in the database: Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\washRcd.accdb;Persist Security Info=False") Dim sql As String sql = " SELECT * FROM tblwash" conn.Open() Dim dt As New DataTable Dim cmd2 As New OleDb.OleDbDataAdapter(sql, conn) cmd2.Fill(dt) DataGridView1.DataSource = dt DataGridView1.Refresh() conn.Close() To insert new record in the database: Private Sub insert() Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\washRcd.accdb;Persist Security Info=False") Dim updateSql As String = String.Format("
Read more