If I recall correctly the SQL Engine service of SQL 2000 is named "MS SQL Server". When you have the services sorted on name (default) the Engine service is -not-...

If you want to validate text-strings in a table field, you can use a TALLY table to match the values against.

Create a table with a datetime field and fill it...

You posted this question in the SQL 2000 forum, so I don't know if you can use this.

If you are on SQL version 2005+ then you have the ability to...

Or to make use of the DMV's:

select count(*)

from sys.dm_exec_requests

where blocking_session_id <> 0

select count(*) as blocked_actions

from master..sysprocesses

where blocked <> 0

P.S.: No need to use all capital letters

You can execute a simple update command to alter the value in the shift_table (the @new_value and @shift_id are variables with the values...

Do you need to change the values in a generic way (i.e.: add a fixed value, replace with a fixed value, etc.)?

Do you need to change the values in a...

??

I don't understand what you mean. Please clearify.

update shift_table

set shift = case shift_id

when 1 then 'C'

when 2 then 'B'

else shift_id

end

where shift_id < 3

You can expand and/or alter the CASE statement to your specific needs. Also try to...

You can remove the CONVERT part from the SELECT to get the (estimated) query plan. But that doesn't remove the incorrect value.

You really should fix this incorrect value(s) first.

The query execution won't get any better with this solution. But the code below will do what you want:create procedure search_row

(

@search_1 nvarchar(100) = null

, @search_2 nvarchar(100) = null

, @search_3 nvarchar(100)...

Without proper DDL (create table) statements and sample data it is hard for us to understand and help you.

If I understand correct you have a view with data from 2...

For this case...

Thanks Dwain, I've read the post.

But sometimes (when the table is small) a stored procedure that is easier to...

If you are able to specify on which column you are searching, then below is a simple solution:

create procedure search_row

(

@skills nvarchar(100) = null

, @position nvarchar(40) = null

, @location nvarchar(50) =...