Viewing 15 posts - 15,976 through 15,990 (of 18,926 total)
I agree for database objects. But I like to name my variables bVerdict for booleans, sSomething for strings. Saves a lot of time on long procedures. But...
June 29, 2005 at 3:20 pm
Why don't you take the time to index it? You're gonna kill the server with that query if it uses a table scan... even if it's a secondary operation.
June 29, 2005 at 3:17 pm
Yup... looks like civilisation hasn't reached you yet. Sorry to hear that ![]()
.
June 29, 2005 at 3:16 pm
It's not long to do... Just browse through my list of posts, you'll come up with about the same results.
BTW I'm just being polite to the users so they aren't...
June 29, 2005 at 3:14 pm
EM, you still use that thing????
ALTER TABLE dbo.TableName ADD
NewPhoneColName AS Right(Phone, 2)
you can then create an index on that column just like if it was a real one.
June 29, 2005 at 3:11 pm
Why not add a type of categorie and hardcode that type only?? You know you'll have to change this list everytime a new category fits it. This is...
June 29, 2005 at 3:07 pm
Approximate post count since I joined :
| month | year | posts | posts/day |
June 29, 2005 at 3:02 pm
In case I'm gone when you read this...
This may help you :
IF Object_id('fnSplit_Set') > 0
DROP FUNCTION fnSplit_Set
GO
CREATE FUNCTION [dbo].[fnSplit_Set] (@IDS as varchar(8000), @vcDelimiter varchar(3))
RETURNS TABLE
WITH SCHEMABINDING
AS
Return
Select...
June 29, 2005 at 2:50 pm
Is this what you mean?
Where Categories.ProductCategoryID in (16, 32, 33, 34, 45, 48, 64, 80, 96)
Because if you want ProductCategoryID = 16 and ProductCategoryID = 32... then it's just...
June 29, 2005 at 2:49 pm
This will fail : isdate(dos) 1
You're asking the server to convert from char to datetime where the conversion is not possible... You'll have to use a char column in...
June 29, 2005 at 2:40 pm
It still will take a lot of time to backup and you will lose performance on the application side to maintain the jpegs.
Are you afraid of losing the data integrity...
June 29, 2005 at 2:36 pm
Not likely, I'm only one of many good t-sqler here. I just happen to post more than the average. ![]()
June 29, 2005 at 2:14 pm
Viewing 15 posts - 15,976 through 15,990 (of 18,926 total)