Great! both of the codes are executed correctely. but whitch one is better?! select or return?
your code executed correctly, but I thought procedure cannot return output value!!
I have some question about your codes:
1- it's not so much...
Excellent!! Thank you Sandeep
but unfortunately I still have msg443 error on Delete line.
what should i do?!
I recommand to reduce time of process, optimize your queries by declare more conditions in "where" or "having". these conditions will help you to...
I have three errors in below code:
CREATE FUNCTION delUserGrp
SELECT * FROM [dbo].[user]
Separate names with a comma.