As mentioned in the MS article posted above by Andy, you can run full-text search without BUILTIN\Administrators by creating a Windows login for NT Authority\System and adding it to the...

The function will not compare values, it will convert all values to a common format. For example:

FN('1-1-2') could return '001-001-002'

FN(1-1-2-1) could return '001-001-002-001'

FN('A-1-2') could return 'A-001-002'

FN('A-1-10') could return 'A-001-010'

Of course,...

I'm not sure exactly what you want to do, but you might want to look at the Microsoft SQL Server Web Data Administrator:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en

You could add another integer column called displayOrder and populate it so that the rows are displayed in your "custom" order. Of course, any applications would need to be modified to...

As Farrell pointed out, first look at your use of the STR() function. This function only accepts the float data type. You also used the STR() function like this:

WHEN provcat =...

Be careful using IsNumeric() in cases like this. IsNumeric() will return 1 (true) for strings which contain numbers in scientific notation, such as the following:

IF IsNumeric('333D33') = 1

  PRINT 'Value...

Here's the transcript of the speech:

http://news-service.stanford.edu/news/2005/june15/jobs-061505

Edit: Sorry, this is the prepared remarks, not a transcript of what he actually said.

Be aware that if you script your stored procedures using EM, they are generated in alphabetical order (case sensative, upper case first, then lower case).

If you have any nested stored...

How about:

SELECT suser_sname()

Bill, refer to Adam's previous post that contains this code snippet:

SELECT CHAR(number)

FROM master..spt_values

WHERE type = 'p'

AND number >= 34

ORDER BY CHAR(number) COLLATE SQL_Latin1_General_Cp1_CI_AS

If you change it to:

SELECT number, CHAR(number)

FROM master..spt_values

WHERE...

Tim,

You would think so, since ASCII codes 58 thru 64 are punctuation characters. It seems that with certain collations, this does not apply. Try this:

DECLARE @var varchar(1)

June 2, 2005 at 7:21 am