Viewing 15 posts - 136 through 150 (of 581 total)
1. the so-called read-only access may not be enforced only by SQL server permissions. There are things which a DBA is trusted not to do.
2. DENY CREATE TABLE or GRANT...
July 1, 2006 at 1:42 am
What do you mean by 'the second table'? Where has this second table come from, and how does it get itself involved in my SQL statement?
June 30, 2006 at 6:16 pm
function dbo.fn_char16tobin8 (@hexstr as char(16))
binary(8)
June 30, 2006 at 11:56 am
Your default will still work even if the column is nullable. But if you can't allow the column to contain nulls under any circumstances (e.g. mistake in app code), and using...
June 30, 2006 at 11:30 am
Get out of my face
June 30, 2006 at 9:22 am
June 30, 2006 at 9:20 am
alter table Table_name add Age_range as cast(Age_start as varchar(10)) + '_' + cast(Age_end as varchar(10))
June 30, 2006 at 9:10 am
You should use an indexed calculated column since that way the data is maintained automatically and can't be overwritten:
June 30, 2006 at 9:00 am
Is the datetime an end time, or a duration (i.e. 0 duration = 1 jan 1900)? In the former case, you could use the code below (though you will have...
June 30, 2006 at 8:46 am
Peter, can you come up with an example in which my solution doesn't give the right result? (Clue: the answer is no.)
June 30, 2006 at 7:05 am
A compromise between
1. a lookup table with app,user,dtype (which would involve some odd joins anyway with the <> and the ELSE) and
2. just putting a slab of code...
June 30, 2006 at 6:59 am
Viewing 15 posts - 136 through 150 (of 581 total)