Attention: Site upgrade failed last night. Will resume updates this weekend. Thanks!- Keith

clintz' blog

clintz' blog

Home
Contact

Syndication

Archives

Sort By: Most Recent | Most Viewed | Most Commented

Excel to SQL Server using TSQL

When I create an application, I always ask my client to give me a sample data for testing my application. Almost all my client give it to me on excel file. To copy the data from excel to SQL server, what I always do was to create a new DTS package then...

Published Tue, Nov 11 2006 5:52 PM by clintz

Filed under: SQL Scripts, TSQL, SQL Server
Tip for faster T-SQL coding

Lots of developers write code in flash with the help of intellisense. But when coding t-sql is scripts, there is no built-in intellisense on query analyzer or SSMS. You will have to use a 3rd party tool to have intellisense on your query analyzer. But...

Published Wed, Sep 09 2006 3:32 PM by clintz

Filed under: SQL Scripts, TSQL, SQL Server
Creating Sudoku problems using TSQL

When I'm bored at the office or home, I sleep. One rainy afternoon, when I can't find the bug on my application, I feel kinda bored but I don't want to sleep because my manager was pissed. So i went over to the next cubicle to chat with my sleepy officemate...

Published Tue, Sep 09 2006 5:34 PM by clintz

Filed under: SQL Scripts, TSQL, SQL Server
Creating Dummy Data

Testing is one of the "must" in software development process. Once, our client lost almost 14 million pesos in a month because of using an application that was developed in a hurry and tested only for 2 days. I feel sorry for them because i was the one...

Published Thu, Aug 08 2006 2:55 PM by clintz

Filed under: SQL Scripts, TSQL, SQL Server

clintz' blog

Syndication

Recent Posts

Tags

Archives

Excel to SQL Server using TSQL

Tip for faster T-SQL coding

Creating Sudoku problems using TSQL

Creating Dummy Data