Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 VIEWS WITH JOIN AND DEFAULT CONDITION

Author  Topic 

cirajc
Starting Member

24 Posts

Posted - 2010-09-25 : 02:59:50
Dears

I am Having one UserInterface with For Querying Data with Predefined Views.It should be Like tHis
a)When i try to JOIN two Views inorder to select different columns
then i to generate ON condition for those VIEWS by default through Asp.Net Server Side .
b)I never practiced by providing KEYS or constraints for Views, Is it possible?.if Possible then How??
Eg: View1 = CUSTOMER_SALESMAN,View2 = CUSTOMER_LIST
Common Column is Address No: of Customer.

Please Reply your Suggestions

Thanks & Regards


ciraj

cirajc
Starting Member

24 Posts

Posted - 2010-09-25 : 03:49:26
If any clarification for the above needed.

please reply


ciraj
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-09-25 : 09:09:35
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150652
Go to Top of Page
   

- Advertisement -