So between...

Do those two columns belong to that table/view?

gopalchalla (7/21/2011)

---

Here is the cleaner format of the SQL,

SELECT sep5.V_ALERTS.ALERT_IDX, COM.IP_ADDR1_TEXT, COM.COMPUTER_NAME, COM.COMPUTER_DOMAIN_NAME,

ALE.USER_NAME, ALE.SOURCE_COMPUTER_NAME, ALE.SOURCE_COMPUTER_IP_TEXT,...

You can't pass a stored procedure to a function. You could pass the results of a stored procedure to a function if you wanted. Based on what you are describing...

I agree that the all upper case makes reading this slightly less painful than removing your own eyeballs and wiping them off with sandpaper and vinegar.

There are two major problems...

Rechana Rajan (7/21/2011)

---

Thanks Sean,

What you said is absolutely right and 100% i agree with you.

But can you please help me in understanding on what areas can they ask question...

This sounds like a fairly easy thing to do using a case operator. If you want some tested and working code you need to post some ddl, sample data and...

Rechana Rajan (7/20/2011)

---

Hi,

Right now working as SQL DBA .Have an interview next week and they want one who is having good knowledge in IIS, Windows server 2000,2003 and 2008.

Can anyone...

I think that this is major cause of poorly designed tables in the real world. The teachers...

+1 for somebody with more knowledge than me jumping in. Thanks Gus.

The only other things I can think would be "exists" "not exists" or "in". I have no clue what would do the things you say it did. Could it have...

Maybe if you shed some light on the context we might be able to come up something.

homework?

interview?

You are correct that this is vague.

Sounds like you have done pretty much what you can. You have to store the hash somewhere and there really isn't much wrong with putting it in a password column....

I agree with Gus that the table itself is neither prone to or not prone to sql injection. It is all about how you access your data. You say your...