Viewing 15 posts - 181 through 195 (of 581 total)
To expand on previous posts: Numerics don't have a format (until they are turned into strings, i.e. not numeric), so in that sense your request for division in scentific notation is misconceived. However, float...
June 27, 2006 at 8:46 am
Yes, there isn't really any more advice we can give unless you are more specific about your requirements, e.g., by posting the ASP code, or whatever SQL code you have come...
June 27, 2006 at 7:49 am
Implicit conversion from data type datetime to float is not allowed. Use the CONVERT function to run this query.
I would use something like decimal(20,10):
June 27, 2006 at 7:45 am
Yes, sorry, not clear. I was referring to the maximum capacity of 8000, as mentioned in the post above.
The point being that insofar as you need to avoid overflow,...
June 27, 2006 at 4:54 am
Yes, SQL server supports a WHILE loop. But don't forget that you are translating from a primarily procedural laguage to a primarily relational language. So some of the things you...
June 27, 2006 at 4:43 am
select
top 1 Hid, HDatefrom
TheTableorder
June 27, 2006 at 4:21 am
You can get alphabetic and numeric order to coincide for strings containing positive integer literals by left-padding your strings with zeros. Better, use an indexed calculated column CASTing the values...
June 27, 2006 at 4:06 am
Unless you store a datetime when the record is inserted, I'm afraid it looks as though the information is not represented in your data.
June 27, 2006 at 3:51 am
SQL only has atomic values and relations/recordsets (tables, views etc.). Use a table variable with two columns: an identity(0,1) column to order the values (acts like the accessor subscript in...
June 27, 2006 at 3:46 am
Impossible to say what's happening without seeing the differences between the two plans in more detail.
June 26, 2006 at 6:01 pm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_9ooj.asp
- from BOL v8.
It may not be relevant, but interestingly in BOL v9 the following is inserted just before the final paragraph:
OPENROWSET and OPENQUERY support pass-through queries in...
June 26, 2006 at 4:59 pm
No sensible or reliable way of doing that. Once any triggers on the parent table have run, SQL won't let you intervene until any deletes have been cascaded. That's why they...
June 26, 2006 at 4:33 pm
You could use an 'instead of delete' trigger on the parent table to join to the child records and do whatever it is you want to do in the trigger...
June 26, 2006 at 12:46 pm
For v9+, sys.key_constraints, sys.indexes, sys.idex_columns, sys.foreign_keys, sys.foreign_key_columns and object_name() should give a most of what you need.
June 26, 2006 at 9:04 am
Viewing 15 posts - 181 through 195 (of 581 total)