pietlinden (9/23/2013)

---

Just say NO to dynamic SQL!!! That opens doors to all kinds of REALLY bad things! I should probably go find Kevin Kline's "SQL Server Low-Hanging Fruit"...

pietlinden (9/23/2013)

---

Young Jedi,

Read these:

http://www.sqlservercentral.com/articles/Security/sqlinjection/1269/

http://www.sqlservercentral.com/articles/Editorial/77168/

http://www.sqlservercentral.com/articles/sql+injection/65129/

I would consider dynamic SQL as an absolute last resort. Not a tool to be used by ex-Access programmers (I...

pietlinden (9/23/2013)

---

I think you can use it. The best way to find out is to use a "sandbox" database (or something you can mess up and it won't matter),...

Sean Lange (9/23/2013)

---

Based on your screen shot and the description this sounds like a search criteria based on the values the user wants to use as their criteria. This is...

Sean Lange (9/23/2013)

---

Instead of this, read the article that...

L' Eomot Inversé (9/21/2013)

---

AndrewSQLDBA (9/20/2013)

---

This code is a waste, since @FirstName is an input parameter that will not allow a NULL. And the front-end should be checking the values for...

Greg Edwards-268690 (9/20/2013)

---

enriquezreyjoseph (9/20/2013)

---

Hi Michael

You have a point there, a lot of people does not exert any little effort before posting the questions...

But for me, that how the technology works,...

pietlinden (9/20/2013)

---

No. I was leaving out a bunch of stuff. It was the bare bones of a stored procedure. One of the differences between a view and...

pietlinden (9/20/2013)

---

Are the pick lists for 3 possible values really necessary? Simplify, then you're done.

You could do this...

SELECT bioID

, FirstName

, LastName

, Sex

, Status

FROM Bio INNER JOIN Sex ON Bio.SexID=Sex.SexID

INNER JOIN...

Hi Michael

You have a point there, a lot of people does not exert any little effort before posting the questions...

But for me, that how the technology works, it has its...

Thanks andrew 🙂

hi steve

Can you show us the code??..

cheers!!

"Be Brave even though you are not no one can tell the difference" - sir bernard tan

thank you my friend 😉

Thanks my friend you got it!!!