Viewing 15 posts - 11,941 through 11,955 (of 13,469 total)
you can try the isnumeric function:
WHERE ISNUMERIC(SOMEVARCHAR) = 1
but as others will tell you, it's not 100% reliable, because of the way it is structured; for exampel
select isnumeric('1E2')
select isnumeric('1d2')
all...
November 3, 2008 at 8:36 am
you need to change the isnsert so that it has your objnum in it, typcially by joining to the right table.
for example, if you have a lookup table that has...
November 3, 2008 at 7:02 am
in my experience, when the same query doesn't run right on two different servers, i check two items first thing: statistics and parameter sniffing.
statistics on one server might be up...
November 3, 2008 at 6:47 am
ok here's an example for you to play with to understand the concept:
create the two tables, and select from the two tables after every step;
this example says if columns 3,4,5,6,7...
October 31, 2008 at 10:03 am
all i meant was you are joining lots of tables in this query....if any two of the tables have a column named PARNT then you will get an error that...
October 30, 2008 at 11:54 am
first thing i notice is you declared 43 variables, but only use one of them; i guess there's more to this than you pasted?
next a minor thing is that your...
October 30, 2008 at 10:36 am
you could easily do this automatically in a trigger, especially by using the new COLUMNS_UPDATED() function that exists for triggers in SQL2005; if a change occurs, you could have a...
October 30, 2008 at 8:25 am
if your dev machine is running SQL Express or SQL Express Advanced, SQl Server Agenct does not exist; it's not part of the featureset, and i suspect that is what...
October 29, 2008 at 10:56 am
aw come on, you know what i mean...Dev is limited to a max of 10 connections, instead of limited only by memory in the full version, a couple of...
October 28, 2008 at 9:09 pm
the portion you pasted has a trailing slash and closing bracket for your CS2 connection...was that just a copy/paste error, or could it be the issue??
Password=xxxx"/>
October 28, 2008 at 10:10 am
compatiblility in that case means it won't fail on install...it'll install the tools no problem.
but as you've noticed it will not install everything. That is by design.
People are a bit...
October 28, 2008 at 9:55 am
you have to check the 2 digit months first, because months 10,11, and 12 all match the january single digit criteria!!
[font="Courier New"]
SELECT yearmonth,
CASE
WHEN (SUBSTRING ( [YearMonth] ,5,2)='10' ) THEN (SUBSTRING ( [YearMonth]...
October 28, 2008 at 9:41 am
in my case RB_TABLE has two indexes; that table has a clustered index one column, and a non-clustered on the exact same column for some reason; but looking at all...
October 28, 2008 at 5:44 am
OK Gail put your thinking hat on, because you've got to double check my work.
I'm combining a couple of scripts i had laying around to try and find statistics that...
October 27, 2008 at 5:25 pm
i know what you mean;
I wrote this neat function that returns the DDL of a table, along with it's indexes....you know, CREATE TABLE.....
works fine in any database, but of...
October 27, 2008 at 2:03 pm
Viewing 15 posts - 11,941 through 11,955 (of 13,469 total)