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                      
tip   To Refer this Site to Your Friends   Click Here
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
 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 ?    4 Yes 0 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 ?    2 Yes 0 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 ?    2 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 ?    0 Yes 1 No
Jayesh Patel
 

 
 
 
Other VB.NET Interview Questions
 
  Question Asked @ Answers
 
sql satement for 2nd maximum value  10
Trace and Debug belongs to which namespaces?  3
Write a program for calculator in VB.NET CMC3
What is an abstract class?  3
What is the difference b/w Readonly Variable and Constant Variable? Sonata4
1234 123 12 1 how to design above pic in vb.net? ABC2
How to create Crystal Report in vb.net with coding Ascent1
linex will support dot net? Phoenix-Technologies4
What is versioning in .NET?  2
Difference between VB dll and assemblies in .NET ? Digital-GlobalSoft5
What is the difference between Dataset and Recordset?  5
Disadvantages of vb ? Digital-GlobalSoft3
sir how i can calculate the value of two-textbox of gridview and show result in textbox within gridview in asp.net with vb.net..plz sir reply me Biz-Technology1
How is VB.Net different from VB6? Ksb7
What is intermediate language in .NET ? Digital-GlobalSoft8
What is the Common Language Runtime? Ksb6
What is shadowing? TCS2
Advantage of vb.net over vb ? Digital-GlobalSoft4
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
How do you do multithreading application in VB ? Satyam4
 
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