In T-SQL you may use "insert" to remove duplicates. What you must do is create another work table with the IGNORE_DUP_KEY option set. So you copy the data from one table to the other. Drop the original table and rename the work table to your … [Continue reading]
Must have books for web developers / Livros todo desenvolvedor web tem que ter
I am addicted to IT books. If this blog helped you somehow and you want to contribute please visit my amazon wish list T-SQL (SQL Server 2000) To become a guru: All from Ken Henderson For begginers in T-SQL: SQL Server 2000 Programming by … [Continue reading]
How to output a list of IDs in a field as recordsets / Como retornar uma lista de IDs como recordset
Sometimes we face issues on our jobs where we can't apply the right thory that we learned from the books and at school about database design. Algumas vezes encontramos situações no trabalho onde não podemos aplicar a teoria … [Continue reading]
Why Another Blog / Por quê mais um blog
I was writing some time ago for a well known Brazilian ColdFusion Blog. But since I didn't have much time to post often I end up not doing any more. Now, that I have again some time, I will continue posting my opinion and views on web … [Continue reading]
- « Previous Page
- 1
- …
- 7
- 8
- 9