ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  VB.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
how to create views in sql with syntax and example
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how to create views in sql with syntax and example
Answer
# 1
create view <Viewname> as
select a as A,b as B,c as C 
from <tablename>
where <whereclause{optional}> order by A
 
Is This Answer Correct ?    6 Yes 1 No
Abhinandan
 
  Re: how to create views in sql with syntax and example
Answer
# 2
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 2 No
Ranjith Reddy
 
 
 
  Re: how to create views in sql with syntax and example
Answer
# 3
CREATE VIEW vino (view_name) 
AS
SELECT mark1 (column_name(s))
FROM stud(table name)
WHERE avg>80 (condition)
 
Is This Answer Correct ?    4 Yes 0 No
Vinoth
 
  Re: how to create views in sql with syntax and example
Answer
# 4
CREATE VIEW <View Name> AS <Query Goes here>
 
Is This Answer Correct ?    3 Yes 1 No
Jayesh Patel
 
  Re: how to create views in sql with syntax and example
Answer
# 5
CREATE VIEW table_name [ ( column_name1, 
column_name2, ... ) ]
  AS SELECT ...

EX:
CREATE VIEW ViewOfTableA AS SELECT col1 FROM TableA
 
Is This Answer Correct ?    0 Yes 0 No
V.vaithyanarayanan
 

 
 
 
Other VB.NET Interview Questions
 
  Question Asked @ Answers
 
if user enters 1 or 2 or any other number in digit format in next textbox it should show the answer in word reading like if enters 12 answer should be twelve  4
What is MSIL. HDFC3
1.wht is satellite assembly??? 2.How Garbage Collector works can u explain ???? ABC3
how to get sum of two numbers in vb.net?  3
How to Insert a TextBox value in to Sql database using VB.Net coding?  3
what is the base class of .net?  6
How do you do multithreading application in VB ? Satyam4
Trace and Debug belongs to which namespaces?  4
what are the difference between An input box and Message box ..?  3
linex will support dot net? Phoenix-Technologies4
Hi I am planning to take interview in VB.net,can any one share your interview Questions for a Entry-level job. Regards Lina  3
when we will use console ?  3
What is the difference between Abstract Classes and Interfaces? Give the answer as a table format....  5
What is the DIfference between Friend and Protected Friend? CTS5
What is the difference between Dataset and Recordset?  7
In Datagrid after adding row, how you will assign the value for each cell to currently added new row?  1
what is vb.net?  9
hello! I am developing software in vb6 and vb.net separately which i need to generate barcodes e.g i have a string "182346-u",so the problem is that how to generate barcode from this type of string can any body help me please thanks regard !  2
hello friends, I have created a animated button in VB.NET. As its dll file coding can be viewed and also copied to some other location. So my question is how can I protect the Dll file of the animated button so that noone can access it. Any idea about this???????? Thanks Rekha  1
Advantage of vb.net over vb ? Digital-GlobalSoft5
 
For more VB.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com