Jie Ma,

Could you please explain your answer a little more clearly.  I don't quite understand what you are saying to do.

Code generation of stored procedures based off of the database schema shortens the development time also.  In addition, for smaller projects code generation of the Data Layer in VB shaves...

Try using PATINDEX.

declare @cndx int;

declare @text varchar(8000);

declare @pattern varchar(50);

declare @replace varchar(50);

set @text = 'a b  c   d ';

set @pattern = '% %'; -- wildcard pattern

set @replace = '';

set @cndx =...

A more efficient way of retrieving the identity value via a return value (as no return trip is required to fetch the new identity value) is as follows:

1) Using the...

1) Create a database called PlayGround on my (local) SQL Server 2000

2) Create a login called PlayGround_DBO with a password of "xyzabc123" and grant it DBO access to the PlayGround...