Browse by Tags

Get the Monday date of a given week in a given year
Thursday, June 26, 2008 12:12 AM

I have not done much sophisticated SQL server programming, generally I profer ad-hoc queries, select-insert-update-delete, and leave other calculations in .net programming. (When I do do heavy-lifting database programming, I use foxpro. I like quick and dirty stuff. Really have to try to pay more attention to style and comments). However, a user question in DNS... Read More...

by xxxd | with no comments

Filed under: SQL server 2005

Comb the tangled SQL server 2005 connection string and deploy the database to remote SQL server
Wednesday, February 20, 2008 12:48 AM

No matter how many ADO .net application I did and will write in the past and future, near and far, there is no way I can remember the long connection strings in indecipherable machine language. Normally I would do a quick search and grab whatever turns up on the first spot and stuff it in my web.config file. Normally I use access, normally it would work. Occasionally... Read More...

by xxxd

Filed under: database, SQL server 2005, ADO .NET