我有一个表,User表,有三列(id、name和age(。如何创建一个存储过程来单独获取名称和年龄?
像这样尝试
CREATE PROCEDURE GetName
AS
BEGIN
SELECT Name,Age
FROM User
END
尝试下面的-
CREATE PROCEDURE GetUserDetails
AS
BEGIN
SET NOCOUNT ON;
SELECT Name, Age from User
END
GO