There's 2 questions that come up with the DRI discussion:

1) Wthout DRI, is there a guarantee that the data has integrity? How? (This is not to say DRI can enforce...

How are you storing it? INT or VARCHAR?

If you're storing INT, then do nothing: it's a presentation issue, and you can format it on retrieval. (This is what we've done...

Automate any repetitive manual tasks, prioritized by the amount of time you spend doing them.

Write general-case and/or parameterized solutions for these, so that they will be ready to handle new...

Non-clustered index seek on SQL 2000 sp2. The table does not have a clustered index.

P

I tried LIKE and PATINDEX on a table with a unique constraint. When searching at the beginning of the string ('C%'), both used that index, with PATINDEX using INDEX SCAN...

Use LIKE when comparing from the beginning of a string.

Otherwise, LIKE and PATINDEX will usually have the same execution plan.

P

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...

The parm is to limit the cursor rows?

DECLARE mycursor CURSOR FOR

SELECT cols

FROM mytable

WHERE col1 = @myparm

OPEN mycursor.....

Yep. Choose All Objects and Data, and you're on your way.

P

See CREATE FUNCTION in BOL...a table-valued function can only accept a constant or a variable in it's arguments.

No worries.

Thanks for clearing that up, Steve.

P

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...

Can't SELECT...INTO a table var either.

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,...