Skip to content

Blog


Categories:

Procedure to script your data (to generate INSERT statements from the existing data)

Post date:
Author:
Number of comments: no comments

This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It’s very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample data to your vendor or […]

Categories:

Difference between using SET and SELECT when assigning variables in T-SQL

Post date:
Author:
Number of comments: no comments

I came across a great article by Narayana Vyas Kondreddi that describes the difference between the SET and SELECT .The article is well worth the read, but here are the main points: SET is the ANSI standard for variable assignment, SELECT is not.SET can only assign one variable at a time, SELECT can make multiple […]

Categories:

A New Approach to Web Applications: AJAX

Post date:
Author:
Number of comments: no comments

If anything about current interaction design can be called “glamorous,” it’s creating Web applications. After all, when was the last time you heard someone rave about the interaction design of a product that wasn’t on the Web? (Okay, besides the iPod.) All the cool, innovative new projects are online. Despite this, Web interaction designers can’t […]