Running a LIKE statement when searching for a date field...

I am trying to run a like statement that has a datetime column and for some reason it does not return any values. I looked in the SQL help files and in states in there that when trying to select using a datetime that the preferred way of doing it is using a like statment. Does anybody know a better way of doing this? Here is my example: (I have dates in this column ie 2006-02-13 11:30:54.220)

SELECT * FROM workorderhistory WHERE wheninstalled LIKE '%2006-02%'

Where did you find that preferred way to compare dates is LIKE. You might want to use many date functions to compare dates available in 2k and 2k5.

OR if you incist on using LIKE convert "wheninstalled" to format that you specify in LIKE.

|||datetime is stored in database in an internal format. It is not in YYYY-MM-DD or whatsoever format.

>> I have dates in this column ie 2006-02-13 11:30:54.220
This just how Query Analyser represent the date or format the date and time when it return the records.

>> SELECT * FROM workorderhistory WHERE wheninstalled LIKE '%2006-02%'
To retireve records for month of Feb 2006,

SELECT * FROM workorderhistory WHERE wheninstalled >= '2006-02-01' and wheninstalled < '2006-03-01'

|||

Here is the text from the sql help file.

It is recommended that LIKE be used when you search for datetime values, because datetime entries can contain a variety of dateparts. For example, if you insert the value 19981231 9:20 into a column named arrival_time, the clause WHERE arrival_time = 9:20 cannot find an exact match for the 9:20 string because SQL Server converts it to Jan 1, 1900 9:20AM. A match is found, however, by the clause WHERE arrival_time LIKE '%9:20%'.

Thanks for your help.

|||Thanks for the help... I don't konw why I did not think of doing it that way... Slipped my mind I guess.|||

try this may be helpful for you

SELECT * FROM
WHERE (CAST(FLOOR(CAST([date] AS FLOAT)) AS DATETIME) = '3/14/2006')

|||

How can I use a like statement in there. I tried doing

select * from workorderhistory where (CAST(FLOOR(CAST([date] AS FLOAT)) AS DATETIME) like '03/%') and this did not work. Basically I want to see all the workorders that were installed in the month of march.

Running a LIKE statement when searching for a date field...

I am trying to run a like statement that has a datetime column and for some reason it does not return any values. I looked in the SQL help files and in states in there that when trying to select using a datetime that the preferred way of doing it is using a like statment. Does anybody know a better way of doing this? Here is my example: (I have dates in this column ie 2006-02-13 11:30:54.220)

SELECT * FROM workorderhistory WHERE wheninstalled LIKE '%2006-02%'

Where did you find that preferred way to compare dates is LIKE. You might want to use many date functions to compare dates available in 2k and 2k5.

OR if you incist on using LIKE convert "wheninstalled" to format that you specify in LIKE.

|||datetime is stored in database in an internal format. It is not in YYYY-MM-DD or whatsoever format.

>> I have dates in this column ie 2006-02-13 11:30:54.220
This just how Query Analyser represent the date or format the date and time when it return the records.

>> SELECT * FROM workorderhistory WHERE wheninstalled LIKE '%2006-02%'
To retireve records for month of Feb 2006,

SELECT * FROM workorderhistory WHERE wheninstalled >= '2006-02-01' and wheninstalled < '2006-03-01'

|||

Here is the text from the sql help file.

It is recommended that LIKE be used when you search for datetime values, because datetime entries can contain a variety of dateparts. For example, if you insert the value 19981231 9:20 into a column named arrival_time, the clause WHERE arrival_time = 9:20 cannot find an exact match for the 9:20 string because SQL Server converts it to Jan 1, 1900 9:20AM. A match is found, however, by the clause WHERE arrival_time LIKE '%9:20%'.

Thanks for your help.

|||Thanks for the help... I don't konw why I did not think of doing it that way... Slipped my mind I guess.|||

try this may be helpful for you

SELECT * FROM
WHERE (CAST(FLOOR(CAST([date] AS FLOAT)) AS DATETIME) = '3/14/2006')

|||

How can I use a like statement in there. I tried doing

select * from workorderhistory where (CAST(FLOOR(CAST([date] AS FLOAT)) AS DATETIME) like '03/%') and this did not work. Basically I want to see all the workorders that were installed in the month of march.

Run Dynamic Query Using Stored Procedure

Hi,

I need to create a stored procedure, which needs to accept the column name and table name as input parameter,

and form the select query at the run time with the given column name and table name..

my procedure is,

CREATE PROC spTest

@.myColumn varchar(100) ,

@.myTable varchar(100)

AS

SELECT @.myColumn FROM @.myTable

GO

This one showing me the error,

stating that myTable is not declared..

..........as i need to perform this type of query for more than 10 tables.. i need the stored procedure to accept the column and table as parameters..

Plese help me?? Is it possible in stored procedure..

DECLARE @.sql as Char(500) -- or whatever length is needed
SELECT @.sql = 'SELECT ' + @.myColumn + ' FROM ' + @.myTable
EXEC(@.sql)

Rule disappeared

I seem to have a rule on one of my columns which prevents me from entering a
value above 25000 in an integer column.
I am not able to find the rule so that I can delete it.
Is there a system table that I should look for?
This table was upsize from Access to SQL 7.0
Are you sure it's a rule you are looking for? If you used
the upsizing wizard, it should have implemented this as a
constraint.
What are you using to manage SQL Server and where are you
looking? You really don't want to address this by modifying
system tables.
To view information as well as constraints, rules on a
table, you could execute:
EXEC sp_help YourTable
To check for constraints, you can execute:
EXEC sp_helpconstraint YourTable
-Sue
On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:

>I seem to have a rule on one of my columns which prevents me from entering a
>value above 25000 in an integer column.
>I am not able to find the rule so that I can delete it.
>Is there a system table that I should look for?
>This table was upsize from Access to SQL 7.0
|||Sue,
I executed the two command that you suggested. There seem to be another
hidden constraint that I can't find.
"Sue Hoegemeier" wrote:

> Are you sure it's a rule you are looking for? If you used
> the upsizing wizard, it should have implemented this as a
> constraint.
> What are you using to manage SQL Server and where are you
> looking? You really don't want to address this by modifying
> system tables.
> To view information as well as constraints, rules on a
> table, you could execute:
> EXEC sp_help YourTable
> To check for constraints, you can execute:
> EXEC sp_helpconstraint YourTable
> -Sue
> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
>
>
|||Constraints don't typically hide so...let's start over.
Could you please post what you are doing and what tool or
application you are using? And post the exact error message
you are receiving?
-Sue
On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
>I executed the two command that you suggested. There seem to be another
>hidden constraint that I can't find.
>"Sue Hoegemeier" wrote:
|||Sue,
I am inside enterprise manager. I try to change the quantity from 6000 to
26000 in an integer column. I get a message that says the current Maximum is
25,000.
We create a new column called quantityNew and with the same datatype and
content. QuantityNew can be changed with no problems.
Arne
"Sue Hoegemeier" wrote:

> Constraints don't typically hide so...let's start over.
> Could you please post what you are doing and what tool or
> application you are using? And post the exact error message
> you are receiving?
> -Sue
> On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
>
>
|||The only way I can think of that you can get a message like
that is through a trigger. If it was a rule or a constraint,
you'd get a much more verbose message indicating that it
violated a check constraint or a rule, the column it was on,
the name of the constraint if it violated a check
constraint, etc.
Check for triggers on the table. In Enterprise Manager,
right click on the table, select All Tasks and then select
manage triggers.
-Sue
On Thu, 20 Jan 2005 10:45:03 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
>I am inside enterprise manager. I try to change the quantity from 6000 to
>26000 in an integer column. I get a message that says the current Maximum is
>25,000.
>We create a new column called quantityNew and with the same datatype and
>content. QuantityNew can be changed with no problems.
>Arne
>"Sue Hoegemeier" wrote:
|||Sue,
I finally found the offending trigger. Thanks.
Arne.
"Sue Hoegemeier" wrote:

> The only way I can think of that you can get a message like
> that is through a trigger. If it was a rule or a constraint,
> you'd get a much more verbose message indicating that it
> violated a check constraint or a rule, the column it was on,
> the name of the constraint if it violated a check
> constraint, etc.
> Check for triggers on the table. In Enterprise Manager,
> right click on the table, select All Tasks and then select
> manage triggers.
> -Sue
> On Thu, 20 Jan 2005 10:45:03 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
>
>
|||Glad it's fixed! Thanks for posting back the results.
-Sue
On Thu, 20 Jan 2005 13:43:09 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
>I finally found the offending trigger. Thanks.
>Arne.
>"Sue Hoegemeier" wrote:

Rule disappeared

I seem to have a rule on one of my columns which prevents me from entering a
value above 25000 in an integer column.
I am not able to find the rule so that I can delete it.
Is there a system table that I should look for?
This table was upsize from Access to SQL 7.0Are you sure it's a rule you are looking for? If you used
the upsizing wizard, it should have implemented this as a
constraint.
What are you using to manage SQL Server and where are you
looking? You really don't want to address this by modifying
system tables.
To view information as well as constraints, rules on a
table, you could execute:
EXEC sp_help YourTable
To check for constraints, you can execute:
EXEC sp_helpconstraint YourTable
-Sue
On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
>I seem to have a rule on one of my columns which prevents me from entering a
>value above 25000 in an integer column.
>I am not able to find the rule so that I can delete it.
>Is there a system table that I should look for?
>This table was upsize from Access to SQL 7.0|||Sue,
I executed the two command that you suggested. There seem to be another
hidden constraint that I can't find.
"Sue Hoegemeier" wrote:
> Are you sure it's a rule you are looking for? If you used
> the upsizing wizard, it should have implemented this as a
> constraint.
> What are you using to manage SQL Server and where are you
> looking? You really don't want to address this by modifying
> system tables.
> To view information as well as constraints, rules on a
> table, you could execute:
> EXEC sp_help YourTable
> To check for constraints, you can execute:
> EXEC sp_helpconstraint YourTable
> -Sue
> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
> >I seem to have a rule on one of my columns which prevents me from entering a
> >value above 25000 in an integer column.
> >I am not able to find the rule so that I can delete it.
> >Is there a system table that I should look for?
> >This table was upsize from Access to SQL 7.0
>|||Constraints don't typically hide so...let's start over.
Could you please post what you are doing and what tool or
application you are using? And post the exact error message
you are receiving?
-Sue
On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
>Sue,
>I executed the two command that you suggested. There seem to be another
>hidden constraint that I can't find.
>"Sue Hoegemeier" wrote:
>> Are you sure it's a rule you are looking for? If you used
>> the upsizing wizard, it should have implemented this as a
>> constraint.
>> What are you using to manage SQL Server and where are you
>> looking? You really don't want to address this by modifying
>> system tables.
>> To view information as well as constraints, rules on a
>> table, you could execute:
>> EXEC sp_help YourTable
>> To check for constraints, you can execute:
>> EXEC sp_helpconstraint YourTable
>> -Sue
>> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
>> <Arne@.discussions.microsoft.com> wrote:
>> >I seem to have a rule on one of my columns which prevents me from entering a
>> >value above 25000 in an integer column.
>> >I am not able to find the rule so that I can delete it.
>> >Is there a system table that I should look for?
>> >This table was upsize from Access to SQL 7.0
>>|||Sue,
I am inside enterprise manager. I try to change the quantity from 6000 to
26000 in an integer column. I get a message that says the current Maximum is
25,000.
We create a new column called quantityNew and with the same datatype and
content. QuantityNew can be changed with no problems.
Arne
"Sue Hoegemeier" wrote:
> Constraints don't typically hide so...let's start over.
> Could you please post what you are doing and what tool or
> application you are using? And post the exact error message
> you are receiving?
> -Sue
> On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
> >Sue,
> >I executed the two command that you suggested. There seem to be another
> >hidden constraint that I can't find.
> >
> >"Sue Hoegemeier" wrote:
> >
> >> Are you sure it's a rule you are looking for? If you used
> >> the upsizing wizard, it should have implemented this as a
> >> constraint.
> >> What are you using to manage SQL Server and where are you
> >> looking? You really don't want to address this by modifying
> >> system tables.
> >> To view information as well as constraints, rules on a
> >> table, you could execute:
> >> EXEC sp_help YourTable
> >> To check for constraints, you can execute:
> >> EXEC sp_helpconstraint YourTable
> >>
> >> -Sue
> >>
> >> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
> >> <Arne@.discussions.microsoft.com> wrote:
> >>
> >> >I seem to have a rule on one of my columns which prevents me from entering a
> >> >value above 25000 in an integer column.
> >> >I am not able to find the rule so that I can delete it.
> >> >Is there a system table that I should look for?
> >> >This table was upsize from Access to SQL 7.0
> >>
> >>
>|||The only way I can think of that you can get a message like
that is through a trigger. If it was a rule or a constraint,
you'd get a much more verbose message indicating that it
violated a check constraint or a rule, the column it was on,
the name of the constraint if it violated a check
constraint, etc.
Check for triggers on the table. In Enterprise Manager,
right click on the table, select All Tasks and then select
manage triggers.
-Sue
On Thu, 20 Jan 2005 10:45:03 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
>Sue,
>I am inside enterprise manager. I try to change the quantity from 6000 to
>26000 in an integer column. I get a message that says the current Maximum is
>25,000.
>We create a new column called quantityNew and with the same datatype and
>content. QuantityNew can be changed with no problems.
>Arne
>"Sue Hoegemeier" wrote:
>> Constraints don't typically hide so...let's start over.
>> Could you please post what you are doing and what tool or
>> application you are using? And post the exact error message
>> you are receiving?
>> -Sue
>> On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
>> <Arne@.discussions.microsoft.com> wrote:
>> >Sue,
>> >I executed the two command that you suggested. There seem to be another
>> >hidden constraint that I can't find.
>> >
>> >"Sue Hoegemeier" wrote:
>> >
>> >> Are you sure it's a rule you are looking for? If you used
>> >> the upsizing wizard, it should have implemented this as a
>> >> constraint.
>> >> What are you using to manage SQL Server and where are you
>> >> looking? You really don't want to address this by modifying
>> >> system tables.
>> >> To view information as well as constraints, rules on a
>> >> table, you could execute:
>> >> EXEC sp_help YourTable
>> >> To check for constraints, you can execute:
>> >> EXEC sp_helpconstraint YourTable
>> >>
>> >> -Sue
>> >>
>> >> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
>> >> <Arne@.discussions.microsoft.com> wrote:
>> >>
>> >> >I seem to have a rule on one of my columns which prevents me from entering a
>> >> >value above 25000 in an integer column.
>> >> >I am not able to find the rule so that I can delete it.
>> >> >Is there a system table that I should look for?
>> >> >This table was upsize from Access to SQL 7.0
>> >>
>> >>
>>|||Sue,
I finally found the offending trigger. Thanks.
Arne.
"Sue Hoegemeier" wrote:
> The only way I can think of that you can get a message like
> that is through a trigger. If it was a rule or a constraint,
> you'd get a much more verbose message indicating that it
> violated a check constraint or a rule, the column it was on,
> the name of the constraint if it violated a check
> constraint, etc.
> Check for triggers on the table. In Enterprise Manager,
> right click on the table, select All Tasks and then select
> manage triggers.
> -Sue
> On Thu, 20 Jan 2005 10:45:03 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
> >Sue,
> >I am inside enterprise manager. I try to change the quantity from 6000 to
> >26000 in an integer column. I get a message that says the current Maximum is
> >25,000.
> >We create a new column called quantityNew and with the same datatype and
> >content. QuantityNew can be changed with no problems.
> >
> >Arne
> >
> >"Sue Hoegemeier" wrote:
> >
> >> Constraints don't typically hide so...let's start over.
> >> Could you please post what you are doing and what tool or
> >> application you are using? And post the exact error message
> >> you are receiving?
> >>
> >> -Sue
> >>
> >> On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
> >> <Arne@.discussions.microsoft.com> wrote:
> >>
> >> >Sue,
> >> >I executed the two command that you suggested. There seem to be another
> >> >hidden constraint that I can't find.
> >> >
> >> >"Sue Hoegemeier" wrote:
> >> >
> >> >> Are you sure it's a rule you are looking for? If you used
> >> >> the upsizing wizard, it should have implemented this as a
> >> >> constraint.
> >> >> What are you using to manage SQL Server and where are you
> >> >> looking? You really don't want to address this by modifying
> >> >> system tables.
> >> >> To view information as well as constraints, rules on a
> >> >> table, you could execute:
> >> >> EXEC sp_help YourTable
> >> >> To check for constraints, you can execute:
> >> >> EXEC sp_helpconstraint YourTable
> >> >>
> >> >> -Sue
> >> >>
> >> >> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
> >> >> <Arne@.discussions.microsoft.com> wrote:
> >> >>
> >> >> >I seem to have a rule on one of my columns which prevents me from entering a
> >> >> >value above 25000 in an integer column.
> >> >> >I am not able to find the rule so that I can delete it.
> >> >> >Is there a system table that I should look for?
> >> >> >This table was upsize from Access to SQL 7.0
> >> >>
> >> >>
> >>
> >>
>|||Glad it's fixed! Thanks for posting back the results.
-Sue
On Thu, 20 Jan 2005 13:43:09 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
>Sue,
>I finally found the offending trigger. Thanks.
>Arne.
>"Sue Hoegemeier" wrote:
>> The only way I can think of that you can get a message like
>> that is through a trigger. If it was a rule or a constraint,
>> you'd get a much more verbose message indicating that it
>> violated a check constraint or a rule, the column it was on,
>> the name of the constraint if it violated a check
>> constraint, etc.
>> Check for triggers on the table. In Enterprise Manager,
>> right click on the table, select All Tasks and then select
>> manage triggers.
>> -Sue
>> On Thu, 20 Jan 2005 10:45:03 -0800, "Arne"
>> <Arne@.discussions.microsoft.com> wrote:
>> >Sue,
>> >I am inside enterprise manager. I try to change the quantity from 6000 to
>> >26000 in an integer column. I get a message that says the current Maximum is
>> >25,000.
>> >We create a new column called quantityNew and with the same datatype and
>> >content. QuantityNew can be changed with no problems.
>> >
>> >Arne
>> >
>> >"Sue Hoegemeier" wrote:
>> >
>> >> Constraints don't typically hide so...let's start over.
>> >> Could you please post what you are doing and what tool or
>> >> application you are using? And post the exact error message
>> >> you are receiving?
>> >>
>> >> -Sue
>> >>
>> >> On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
>> >> <Arne@.discussions.microsoft.com> wrote:
>> >>
>> >> >Sue,
>> >> >I executed the two command that you suggested. There seem to be another
>> >> >hidden constraint that I can't find.
>> >> >
>> >> >"Sue Hoegemeier" wrote:
>> >> >
>> >> >> Are you sure it's a rule you are looking for? If you used
>> >> >> the upsizing wizard, it should have implemented this as a
>> >> >> constraint.
>> >> >> What are you using to manage SQL Server and where are you
>> >> >> looking? You really don't want to address this by modifying
>> >> >> system tables.
>> >> >> To view information as well as constraints, rules on a
>> >> >> table, you could execute:
>> >> >> EXEC sp_help YourTable
>> >> >> To check for constraints, you can execute:
>> >> >> EXEC sp_helpconstraint YourTable
>> >> >>
>> >> >> -Sue
>> >> >>
>> >> >> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
>> >> >> <Arne@.discussions.microsoft.com> wrote:
>> >> >>
>> >> >> >I seem to have a rule on one of my columns which prevents me from entering a
>> >> >> >value above 25000 in an integer column.
>> >> >> >I am not able to find the rule so that I can delete it.
>> >> >> >Is there a system table that I should look for?
>> >> >> >This table was upsize from Access to SQL 7.0
>> >> >>
>> >> >>
>> >>
>> >>
>>

Rule disappeared

I seem to have a rule on one of my columns which prevents me from entering a
value above 25000 in an integer column.
I am not able to find the rule so that I can delete it.
Is there a system table that I should look for?
This table was upsize from Access to SQL 7.0Are you sure it's a rule you are looking for? If you used
the upsizing wizard, it should have implemented this as a
constraint.
What are you using to manage SQL Server and where are you
looking? You really don't want to address this by modifying
system tables.
To view information as well as constraints, rules on a
table, you could execute:
EXEC sp_help YourTable
To check for constraints, you can execute:
EXEC sp_helpconstraint YourTable
-Sue
On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:

>I seem to have a rule on one of my columns which prevents me from entering
a
>value above 25000 in an integer column.
>I am not able to find the rule so that I can delete it.
>Is there a system table that I should look for?
>This table was upsize from Access to SQL 7.0|||Sue,
I executed the two command that you suggested. There seem to be another
hidden constraint that I can't find.
"Sue Hoegemeier" wrote:

> Are you sure it's a rule you are looking for? If you used
> the upsizing wizard, it should have implemented this as a
> constraint.
> What are you using to manage SQL Server and where are you
> looking? You really don't want to address this by modifying
> system tables.
> To view information as well as constraints, rules on a
> table, you could execute:
> EXEC sp_help YourTable
> To check for constraints, you can execute:
> EXEC sp_helpconstraint YourTable
> -Sue
> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
>
>|||Constraints don't typically hide so...let's start over.
Could you please post what you are doing and what tool or
application you are using? And post the exact error message
you are receiving?
-Sue
On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
>I executed the two command that you suggested. There seem to be another
>hidden constraint that I can't find.
>"Sue Hoegemeier" wrote:
>|||Sue,
I am inside enterprise manager. I try to change the quantity from 6000 to
26000 in an integer column. I get a message that says the current Maximum is
25,000.
We create a new column called quantityNew and with the same datatype and
content. QuantityNew can be changed with no problems.
Arne
"Sue Hoegemeier" wrote:

> Constraints don't typically hide so...let's start over.
> Could you please post what you are doing and what tool or
> application you are using? And post the exact error message
> you are receiving?
> -Sue
> On Thu, 20 Jan 2005 06:11:04 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
>
>|||The only way I can think of that you can get a message like
that is through a trigger. If it was a rule or a constraint,
you'd get a much more verbose message indicating that it
violated a check constraint or a rule, the column it was on,
the name of the constraint if it violated a check
constraint, etc.
Check for triggers on the table. In Enterprise Manager,
right click on the table, select All Tasks and then select
manage triggers.
-Sue
On Thu, 20 Jan 2005 10:45:03 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
>I am inside enterprise manager. I try to change the quantity from 6000 to
>26000 in an integer column. I get a message that says the current Maximum i
s
>25,000.
>We create a new column called quantityNew and with the same datatype and
>content. QuantityNew can be changed with no problems.
>Arne
>"Sue Hoegemeier" wrote:
>|||Sue,
I finally found the offending trigger. Thanks.
Arne.
"Sue Hoegemeier" wrote:

> The only way I can think of that you can get a message like
> that is through a trigger. If it was a rule or a constraint,
> you'd get a much more verbose message indicating that it
> violated a check constraint or a rule, the column it was on,
> the name of the constraint if it violated a check
> constraint, etc.
> Check for triggers on the table. In Enterprise Manager,
> right click on the table, select All Tasks and then select
> manage triggers.
> -Sue
> On Thu, 20 Jan 2005 10:45:03 -0800, "Arne"
> <Arne@.discussions.microsoft.com> wrote:
>
>|||Glad it's fixed! Thanks for posting back the results.
-Sue
On Thu, 20 Jan 2005 13:43:09 -0800, "Arne"
<Arne@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
>I finally found the offending trigger. Thanks.
>Arne.
>"Sue Hoegemeier" wrote:
>