Viewing 15 posts - 436 through 450 (of 476 total)
Use LIKE when comparing from the beginning of a string.
Otherwise, LIKE and PATINDEX will usually have the same execution plan.
P
March 23, 2005 at 10:02 am
Actually, LIKE 'something%' will perform better (only when you're looking from the beginning of the string - LIKE '%something%' will do a table scan).
This is because LIKE can use an...
March 1, 2005 at 9:49 am
The parm is to limit the cursor rows?
DECLARE mycursor CURSOR FOR
SELECT cols
FROM mytable
WHERE col1 = @myparm
OPEN mycursor.....
March 1, 2005 at 8:46 am
Yep. Choose All Objects and Data, and you're on your way.
P
February 21, 2005 at 7:30 am
See CREATE FUNCTION in BOL...a table-valued function can only accept a constant or a variable in it's arguments.
February 9, 2005 at 8:50 am
Well, for sure you're going to have to use the with MOVE, since the folders on developer's stations have different structure than prod boxes.
What I've done is write a sproc...
February 3, 2005 at 1:30 pm
Can't SELECT...INTO a table var either.
February 3, 2005 at 12:03 pm
See CREATE FUNCTION in BOL.
It states that dynamic SQL is not allowed in functions.
Instead of having new tables everyday (tablename_businessdate), why not have permanent tables with a businessdate column. Then,...
February 3, 2005 at 9:06 am
Contrary to a statement above, you can declare a PK or Unique constraint - which creates an index - on a table variable.
Table vars can be as good or slower...
February 1, 2005 at 7:58 am
Jam,
Yes, it does exist. You can find code examples on the net quite easily. The MS website has some code too.
See DTS Package2 Hierarchy in Books Online.
P
February 1, 2005 at 7:50 am
Did you say you have a deal_id column in each of product and asset tables? Can 1 product have more than one deal_id? Can 1 asset have more than 1...
December 14, 2004 at 8:02 am
Hi Steve,
Thanks for the reply.
So in my case, @ObjectHandle = reference to the jobs collection object? I've tried that, and I kept getting and error.
Here's the rest of the...
December 14, 2004 at 7:20 am
Thanks for the reply.
I know I can use sp_add_job, except I have to run that on the SQL Server I want the job added to first. Using DMO, I can...
December 13, 2004 at 12:05 pm
Viewing 15 posts - 436 through 450 (of 476 total)