Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to create views in sql with syntax and example

Answer Posted / ranjith reddy

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Using Views
CREATE VIEW [Current Product List] AS
SELECT ProductID,ProductName
FROM Products
WHERE Discontinued=No

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?

968


What is a static variable?

1796


What is an application domain? how they get created?

1021


hello thank you for replying to my question regarding adding barcode fonts in vb.net project. I have downloaded a free font and added in my vb.net project but now i dont know how to use that i need to generate barcodes can any body help me how to use those fonts these are font3of9 .i need a small code to use these fonts to generate barcode thank u!

2011


how to get dynamic control array position or its index position?

2529


Name some of the features present in vb 2005?

957


Explain option strict?

952


Explain the difference between namespace and assembly?

1001


How does vb.net achieve polymorphism?

933


described weak typing?

1030


What keyword is used to accept a variable number of parameter in a method?

1020


What is meant by jagged arrays?

1041


What is the importance of a Button control?

1304


How can we remove handlers at run time?

1062


Explain clr?

1042