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 |
|
avijit_mca
Posting Yak Master
109 Posts |
 Posted - 2008-12-15 : 23:38:47
|
| Hi Guys,any body explain me details about with syntax in sql.with [Bookid ] as( select cardcode as Bookid, * from table_name ) select * from [Bookid ] this syntax is working fine. but i want to know more about it.Regards,avijit |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-12-15 : 23:44:44
|
| see in book online about common table expressions |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 23:50:35
|
| http://msdn.microsoft.com/en-us/magazine/cc163346.aspx |
|
|
|
avijit_mca
Posting Yak Master
109 Posts |
Posted - 2008-12-16 : 02:03:46
|
| thanks .. going to checking ...Regards,avijit |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 02:08:37
|
welcome  |
|
|
|
|
|
|
With syntax in sql