Viewing 15 posts - 181 through 195 (of 582 total)
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,...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
select
top 1 Hid, HDatefrom
TheTableorder
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
Impossible to say what's happening without seeing the differences between the two plans in more detail.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
And divide that by 2 for unicode strings!
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
Viewing 15 posts - 181 through 195 (of 582 total)