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.
| Author |
Topic |
|
suman.reddy39
Starting Member
34 Posts |
 Posted - 2008-01-21 : 01:00:33
|
| can we create a view with data into it, without a base table.SumanReddy.k |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 01:04:48
|
| You can create view to select data from other views, but data are still from base tables eventually. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-21 : 08:30:32
|
quote:
Originally posted by suman.reddy39
can we create a view with data into it, without a base table.SumanReddy.k
Why do you need this?create view test_viewasselect * from(select 10 as code,'test' as names) as tGoSelect * from test_viewMadhivananFailing to plan is Planning to fail |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-21 : 08:36:22
|
| moved from article discussion_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
suman.reddy39
Starting Member
34 Posts |
Posted - 2008-01-22 : 23:01:15
|
| thanks for your valuable replySumanReddy.k |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-23 : 00:44:25
|
quote:
Originally posted by suman.reddy39
thanks for your valuable replySumanReddy.k
You didnt tell us why you need thisMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
view