stevenhug
asked on
Sql Server SELECT statement using '=*'
I inherited some code which uses a dynamic Sql Server SELECT statement. The statement uses an Equal Sign, Asterisk (=*) as part of the WHERE clause like this:
SELECT
LocalChangeBoard_Sign_RFC_ Parm.LcbBo ardName,
RequestForChange_LCB_Signa ture.LcbAp proveFlag AS LcbApproveFlag,
LocalChangeBoard_Sign_RFC_ Parm.LcbBo ardID
FROM RequestForChange_LCB_Signa ture ,LocalChangeBoard_Sign_RFC _Parm
WHERE RequestForChange_LCB_Signa ture.LcbAp proveFlag = 1
AND (RequestForChange_LCB_Sign ature.LcbB oardID =* LocalChangeBoard_Sign_RFC_ Parm.LcbBo ardID )
AND (LocalChangeBoard_Sign_RFC _Parm.Acti veFlag = 'A')
AND (RequestForChange_LCB_Sign ature.Requ estForChan geID = @RfcID)
ORDER BY LocalChangeBoard_Sign_RFC_ Parm.LcbBo ardName
I have no idea what this does. Can you help?
SELECT
LocalChangeBoard_Sign_RFC_
RequestForChange_LCB_Signa
LocalChangeBoard_Sign_RFC_
FROM RequestForChange_LCB_Signa
WHERE RequestForChange_LCB_Signa
AND (RequestForChange_LCB_Sign
AND (LocalChangeBoard_Sign_RFC
AND (RequestForChange_LCB_Sign
ORDER BY LocalChangeBoard_Sign_RFC_
I have no idea what this does. Can you help?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://msdn.microsoft.com/en-us/library/aa213228%28v=sql.80%29.aspx