Forum Replies Created
Viewing 9 posts - 1 through 10 (of 10 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...
Ezz Khayyat
-
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 =
Ezz Khayyat
-
RE: SQL Server 2000 vs SQL Server 2005
Thats a great information, thanks alot Julian
Ezz Khayyat
-
RE: Using Count(col1)??
Yeah, when using aggregate function such as COUNT, MAX and SUM,, always change the WHERE clause into HAVING
Ezz Khayyat
-
RE: Database Documentation
WoOoOoOoW ! This tool is amazing
Thanks for the link, dude
Ezz Khayyat
-
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...
Ezz Khayyat
-
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...
Ezz Khayyat
-
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
Ezz Khayyat
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...
Ezz Khayyat
Viewing 9 posts - 1 through 10 (of 10 total)