You cannot use the words True/False as they are reserved words in SQL. The nearest you can get to your requirement is to check against character representation of True/False

select *...

Same thing but using PATINDEX

SELECT mt.description, kw.keyword

FROM MainTable mt

INNER JOIN KeyWords kw

ON PATINDEX ('%' + kw.keyword + '%',mt.description) > 0

will this work on MS SQL SERVER 2000?

Yes, but change the first SELECT to

SELECT b.[Client ID],b.[Course Date],b.[Course ID]...

What is [Course Code], is it meant to be [Course ID], if so then

SELECT [Client ID],[Course Date],[Course ID]

FROM [Course Bookings] b

INNER JOIN (SELECT [Client ID],MAX([Course Date]) AS [Course...

Identity columns can be one of decimal, int, numeric, smallint, bigint, or tinyint, a number by definition. They are normally assigned when a table is created, eg

CREATE TABLE [tablename] (rowid...

Thanks for the replies. Having never done log shipping I was interested to know. At least I know for the future. Never liked replication since had horrible time with 6.5,...

Can someone explain how Log Shipping satisfies the 'you can lose no more than 15 minutes of data in a real disaster' requirement unless you are going to 'Log Ship' the database every...

Yes, use an Excel connection. When you apply the transformation sql will know whether yopu want to input or output. Several things to watch out for. The worksheet must exist...

bcp databasename..tablename in textfilename /c /t "," /r "\n" /S servername /U username /P password

This will insert data from a standard comma separated text file

For further info see BOL (Books...

Try changing

case when @ColOrder < @MaxCol then ', '

to

case when @ColOrder < @MaxCol then '+'',''+ '

Be careful with Excel inport with DTS. It does not like mixed data in the same column (ie numbers and text). It will take the first row data as indication of...

SELECT 'INSERT INTO VALUES (' +

CAST(intcol as varchar) + ',' +

'''' + varcharcol + ''',' +

'''' + CONVERT(varchar,datetimecol,120) + '''' +

')'

FROM

Or do...

Add a IDENTITY column, sql will automatically increment the column when new rows are inserted.

Try this

select 'sp_addlogin ''' + a.name + ''',@sid=',a.sid,',@passwd=',

CONVERT (VARBINARY (32), a.password),',@encryptopt=''skip_encryption''' + char(13) + 'GO'

FROM syslogins AS a

INNER JOIN maxprod.dbo.sysusers AS p

   ON a.name = p.name...

Mmmm. Must admit only done this in testing, mind you I would be happy if this was the only mistake I made, you should see some of my big faux...