Hi - I need some clarification here please. One developer here has created a table with a non-clustered key. He then goes and creates a clustered...
thanks Roji
thanks Adriaan point requiring clarification. will the UDF be evaluated all the way to the end even if the value has been identified say midway...
thanks All. this is just the point - normally I would put this into a table. I need a reason why it shouldn't be designed like this using UDFs. I...
thanks for the replies. the udf is being called - typically from other db procedures to evaluate the required number value of the parameter being...
Hi I am looking through a database schema where I have noticed that a particular function is code with a lot of select @ref = CASE @code WHEN...
apologies if this is not the right forum but I looked at the others and it seems this is more right than wrong. I'm reviewing a schema design and...
Hi thanks for your responses but I think I haven't made myself clear - apologies. I have created a NT domain group called 'developers' and have...
Hi All I'm setting up a new installation of sql server2005 as the database with all development being done with visual studio 2005 and foundation...
This is a repost from the sql 2000 forums. dineshasanka has replied and pointed me to some articles, and I am reading this at present. But is any...
thanks - I'll repost in correct forum.
Hi all apologies if this is not in the right area but I see no forum yet for sql server2005 questions. Background: I work for a software...
Separate names with a comma.