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 |
|
BuddyRam
Starting Member
17 Posts |
 Posted - 2007-06-08 : 01:41:57
|
| Hello All,Today I came across one kind of sql query which contains SHAPE ,RLEATED, and APPEND keywords like as follows.SELECT * FROM tbl_menu where position ='Left' AND (parentid is null or parentid = 0) ORDER BY [order]} APPEND (( SHAPE {SELECT * FROM tbl_menu where position ='Left' ORDER BY [order] } as rsParent APPEND ({ SELECT * FROM tbl_menu where position ='Left' ORDER BY [order]} RELATE menuid to parentid ) as RSParent) RELATE menuid to parentid ) I never understood what it does mean..and when i tried to execute in my query analyzer its saying donta have enough access to run this query.Thanks And waitng for your relpy...CheersRam |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-08 : 02:05:09
|
| SHAPE, RELATE and APPEND are part of SQL Server's data mining extensions (DMX). Check BOL for details http://technet.microsoft.com/en-us/library/ms131972(SQL.90).aspx-ec |
 |
|
|
|
|
|
SHAPE and RELATE keywords in my sql query