Gary Varga (3/8/2010)

---

jay holovacs (3/8/2010)

---

Gary Varga (3/8/2010)

---

From a truly serious viewpoint (sorry to spoil the party - hic), I believe that IT practitioners should be regulated like the legal and...

Roy Ernest (3/1/2010)

---

USA has a world cup winning team? I did not expect that for the next 5 yrs because they are so new to the world cup.

I...

Oh, no! His GOOGLE search bot is sure to find this thread now!

george.greiner (3/1/2010)

---

As with most Access it is a hybrid of Access SQL and VB... You write the queries...

That is not Access SQL, that is Access Visual Basic.

Using identity columns as a PK key and putting unique constraints on the candidate keys is the way to go. In many cases, there is no way to know...

Tom.Thomson (2/28/2010)

---

...The next Monday I walked into the office where the people who owned the affected code were and said something like "Listen up guys, I've fucked up and we...

Kingston Dhasian (2/26/2010)

---

Paul White (2/26/2010)

--------------------------------------------------------------------------------

If you have a pain in your finger, chopping your hand off is not the solution.

In fairness, it is *a* solution, just probably not optimal...

Welsh Corgi (2/26/2010)

---

So there are no DBA's that recognize that there are risk to Dynamic SQL?

If I'm wrong then I respectfully respect that you forgive me for...

Michael Valentine Jones (2/25/2010)

---

In a public forum like SSC, I think it is more important to correct errors in the thread directly than to worry about someone’s feelings. The...

Welsh Corgi (2/26/2010)

---

Thank you Jeff. I read your link concerning the SQL Injections.

However there is a lot more to consider that what is addressed in this article.

You are...

Dynamic SQL is a very good tool for situations where you have stored procedure input parameters that may or may not be used for selection criteria. By constructing the...

Nested REPLACE works just fine:

print 'Load Test data with all strings of Commas from 1 to 8000'

select

NUMBER,

Commas = convert(varchar(8000),replicate(',',NUMBER))

into

#t

from

-- Number Table Function available here:

-- http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685

F_TABLE_NUMBER_RANGE(1,8000)

order by

NUMBER

go

print 'Test Replaces'

select

*

from

(

select

NUMBER,

Commas =

replace(replace(replace(replace(replace(replace(replace(Commas

,',,,,,,,,,,',',')

,',,,,,,,,,,',',')

,',,,,,,,,,,',',')

,',,',',')

,',,',',')

,',,',',')

,',,',',')

from

#t

)...

In a public forum like SSC, I think it is more important to correct errors in the thread directly than to worry about someone’s feelings. The damage that can...

Noman Tariq (2/15/2010)

---

So, If i say it like that, we dont need to add FKs if we have no problem with data integrity because our application flow will handle this....