Viewing 5 posts - 1 through 5 (of 5 total)
Jie Ma,
Could you please explain your answer a little more clearly. I don't quite understand what you are saying to do.
March 15, 2005 at 4:23 pm
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...
November 19, 2004 at 1:58 pm
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 =...
November 11, 2004 at 9:02 am
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...
November 10, 2004 at 7:49 am
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...
October 29, 2004 at 9:10 am
Viewing 5 posts - 1 through 5 (of 5 total)