Forum Replies Created
Viewing 9 posts - 1 through 9 (of 9 total)
-
RE: Optimized SQL for Name Search
Try to use this inline query building technique (the fastest way to do it):
DECLARE @query NVARCHAR(300)
DECLARE @fname NVARCHAR(30)
DECLARE @lname...
-
RE: how can i c password
You can simply do a basic XOR operation on every character in the password:
// C++ code
char* pass; // contains the user's password
char* newpass =
-
RE: SQL Server 2000 vs SQL Server 2005
Thats a great information, thanks alot Julian
-
RE: Using Count(col1)??
Yeah, when using aggregate function such as COUNT, MAX and SUM,, always change the WHERE clause into HAVING
-
RE: Database Documentation
WoOoOoOoW ! This tool is amazing
Thanks for the link, dude
-
RE: Problem with Stored Procedure with Temporary Table
Ohh yes, you are right!
Sorry I didn't notice this! 
So I guess there is no any...
-
RE: Problem with Stored Procedure with Temporary Table
Ohh you are right! The results are not in the same order as you wanted it to be!
Well, the LIMIT clause is really...
-
RE: Problem with Stored Procedure with Temporary Table
Why do you insert the whole resultset into the temp table, while you only need @Size results at a time??????!!!!
This will consume a lot of time if the
April 4, 2005 at 8:34 pm
-
RE: What Your SP Can Return
In my opinion, I always suggest to use return values as a Success/Failure indication. In the project I am working on, I have some nested stored procedures. spX calls spY and...
Viewing 9 posts - 1 through 9 (of 9 total)