May be taking a "desert sabatical", if he was paying attention to The...

J (3/17/2009)

---

Woops! with my limited command of the Englsih language (not my mother tonge) I assumed Lynn was a...

I would suggest contacting tech support for the monitoring product and seeing if they can help.

Try this:

declare @name sysname

set @Name = 'A_NEW_York'

select @name where @name like 'a[_][a-z][a-z][a-z][_]%'

Square-brackets around an underscore make it a literal-string, instead of a variable. Test it with this:

declare @name sysname

set...

Not stupid. Just have stuff to learn about SQL. Who doesn't?

Try this:

select @NewCourse =

(select min(Courses.CourseID)

from @Courses Courses

left outer join @Enrollment Enrollment

on Courses.CourseID = Enrollment.CourseID

and Student = @Student

where Enrollment.CourseID is null);

See if that'll do what you need.

If I understand what you mean, that you want to make a date and time look a certain way, do that in the front end (report/web page/form/whatever). Easier and...

chrisn (3/17/2009)

---

The Express version is designed by Microsoft to fill this hole, where a solid RDBMS engine is required but not all the extra features. I guess encouraging the use...

Why would you be in the middle of both regression testing and installing a service pack on the same server at the same instant? Or am I misunderstanding your...

gary (3/17/2009)

---

The sad fact is that Microsoft makes everything an application. SQL Server should be a server not a programming language and Vista should be an operating system not a...

YSLGuru (3/17/2009)

---

BTW ... I must be the only person on the planet, aside from the actors in the Vista commercials, who has had no problems with Vista and...

It seems to be dropping blank lines in the format. Maybe I'm doing something wrong, but it seems to be doing so.

Line one, followed by a blank line

Line two

That...

foxjazz (3/17/2009)

---

Well for you folks that are still here.

What I am speaking about is language, not about application.

It seems many have failed to grasp that simple concept, and appear too...

Both can do 10 characters. One takes 10 bytes for that, the other takes 20 (plus overhead in both cases). The 10-byte one, varchar, can only hold ASCII...

Lynn, have you tried it? I just tried all of these options:

create table #T (

ID int identity primary key,

Col1 tinyint,

Col2 tinyint);

alter table #T

alter column Col1 smallint, alter column Col2...