Is this also true of the examples in Books Online?

vikingDBA (4/4/2012)

---

Lynn:

I look forward to seeing that. I do light to medium design work, mostly administration. My databases that I write are only used by small departments. ...

vikingDBA (4/4/2012)

---

If it helps, here are a couple of functions I created to do just that. First input is the full line of information to look at, and the...

Here is a comparison of Raid 1 + 0 vs Raid 0 + 1, http://decipherinfosys.wordpress.com/2008/01/15/difference-between-raid-01-vs-raid-10/%5B/url.

Given a choice for resiliency, I'll go with Raid 1 + 0.

Really? Do you still have the original production...

bullo (4/4/2012)

---

this is all for a SINGLE CLASS DAY.

the plus second is to find overlapping/close classes. i have to make a drawing to came up with that logic....

SQLKnowItAll (4/4/2012)

---

I used to administer GP at my previous company. How many users do you have on GP and how many use it concurrently? Most cases, GP does not...

aptlogix (4/4/2012)

---

Lynn Pettis (4/4/2012)

---

One, for what time period is the report run? Past 7 days, since the beginning of the term, etc.

When one sees consecutive days, one is usually refering...

One, for what time period is the report run? Past 7 days, since the beginning of the term, etc.

When one sees consecutive days, one is usually refering to more than...

Actually, I got this to work with no problem.

ALTER PROC dbo.sp_GetMaxID (@MaxID INT OUTPUT)

AS

BEGIN

SELECT @MaxID = max(ID) + 1 FROM tblFileWatchMaxID;

END

Use the same test code from...

TeraByteMe,

Looking at your original post, I think I know the problem. Modified the code to return max(id) + 1 and it doesn't use any dynamic sql.

ALTER PROC dbo.sp_GetMaxID (@MaxID...

In addition, you have no control over the code generated by Hibernate. If the code is inefficient, it stays that way. Going to stored procedures allows you to...

If you are receiving unicode data, I would be concerned about losing data. I have to agree with Jack and vote for storing the information in nvarchar columns and...

One last thing that may not have been covered in the article, expected results. Based on the sample data you provided, what should the results from the query be?

To be honest, I'd rather have an automated method of enforcing the UPPER CASE on SQL reserved words, even if it meant me hitting a sequence of control keys to...