Hi vb, What you suggested is exactly what I did when I discovered that update doesn't work within a function. The sp code was re-worked into a...
I changed my stored procedure into a function but SS complained about an update being an illegal call within a function. I am missing some kind of...
Thanks Bambola, I was thinking .. I now have my stored procedure that returns an ID sucessfully. I call it succesfully from a front end app as...
Thanks Negative, I have corrected the stored procedure as follows... --****************************************** CREATE PROCEDURE sp_GetNextKey...
Ok Guys, Here goes. I have something I am working on....my first stored procedure. Excited. It just this second worked so I tell right away. My...
Hi Guys, Sorry for the delay. Very busy for two days. Now going to analyse and test all the options that you have presented and figure out which one...
I realise at some point today after re-reading the articles that I didn't really know what a calculated column was. I eventually figured it out by...
I am terribly sorry guys but I tried both options and neither worked. Not sure what I may be doing incorrectly. Many many thanks for your help.
Hello, I have just started using SQL SERVER 2000 and I need urgent help on setting default values. Lets say I have 2 fields: 1.AID Integer...
Separate names with a comma.
