What data type is your step column? If it is stored as text that would mean 9 is greater than 10. If it is being stored as text, cast or...

Glad it helped you out.

I think you need something like this:

Create procedure ProcedureName @AppCode int, @AgencyID int, @CompnyID int, @CustCode int=null

as

select @AgencyID = coalesce(@CustCode,@AgencyID)

select AppCode, AgencyID, CompnyID, CustCode, CustVal

from table1

where appcode = @appcode and...

This article is quite thorough.

Bonus: It's from Phil Factor

https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

Yes, I'm a beginner, but we have several other Python users with varying skills in Python.

We use Python to do all kinds of things, but most of our Python is used to automate ARC GIS processing.

I thought that would work too, however I tested this and it did not work:

ALTER trigger PreventRename on all server for alter_database as

declare @command varchar(max)

SELECT @Command = EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')

print @Command

if @Command...

Here is an alternative solution.

http://www.mssqltips.com/sqlservertip/3202/prevent-multiple-users-from-running-the-same-sql-server-stored-procedure-at-the-same-time/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20140718

create proc dbo.proc1 @input int

as

select case @input

when 1 then 'yes'

else 'No'

end;

That should also work, depending on permissions needed.

You will probably want to set up your app pool with a service account that has the necessary permissions to run your application.

Try this:

Click "Start button"

in the search box, enter "Turn windows features on or off"

in the features window, Click: "Internet Information Services"

Click: "World Wide Web Services"

Click: "Application Development Features"

Check (enable) the...

Can you post the error message you get?

If you are just looking to get notified when one changes or is added, you could setup a job to run this and look at the modify_date and send an...

You will need to take the SQL Server service off line and bring it back online after making the setting change.