Hello!How can I make this function in MS SQL:
CREATE FUNCTION id_name() RETURNS INTEGER
AS 'SELECT MAX(ID)+1 FROM Test;'
Thanks!
![Big Smile [:D]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_u6uXrZF1HMtLfhqJ40L6uPL-1n47wWKtK7nFUCMksHnSUqQJz-uO0yfUHnlbzR982ap-b0HDwAEHFwUKyP9KSndV4i4A0HgGXAYpDFAJjiVdicJNRs7A=s0-d)
CREATE FUNCTION id_name ()
RETURNS integer
AS
BEGIN
declare @.Return integer
@.return =SELECT MAX(ID)+1 FROM Test
return @.return
END
Limno
|||CREATE FUNCTION id_name RETURNS INTEGERAS SELECT MAX(ID)+1 FROM Test
No comments:
Post a Comment