如图上表
我想查询所有的记录怎么写?

create proc query_all
as
select * from your_table
go
exec query_all
go

我给你示例，你自己看：

USE [MySchool]
GO

/****** 根据用户名(帐号)查询管理员记录信息 ******/
CREATE PROCEDURE [dbo].[P_Admin_Select]
    (
        @loginId Varchar(50)
    )
AS
    Select AdminId,LoginId,LoginPwd From Admin Where LoginId=@loginId
Go



/****** 查询年级记录信息 ******/
CREATE PROCEDURE dbo.P_Grade_Select
AS
    Select GradeId,GradeName From Grade
Go



/****** 通过年级名称得到年级ＩＤ ******/

CREATE PROCEDURE dbo.P_Grade_GetGradeIDByGradeName
    (
        @gradeName Varchar(50)
    )
AS
    Select GradeId,GradeName From Grade Where GradeName=@gradeName
GO



/****** 通过年级ＩＤ得到班级名称集合 ******/

CREATE PROCEDURE dbo.P_Class_SelectClassesByGradeID
    (
        @gradeId int
    )
AS
    Select ClassId,ClassName,GradeId From Class Where GradeId=@gradeId
Go



/****** 通过班级名称得到班级ＩＤ ******/
CREATE PROCEDURE dbo.P_Class_GetClassIDByClassName
    (
        @className Varchar(50)
    )
AS
    Select ClassId From Class Where ClassName=@className
Go   



/****** 添员学员 ******/
Create PROCEDURE dbo.P_Student_Insert
    (
        @LoginId Varchar(50),
        @LoginPwd Varchar(50),
        @UserStateId Int,
        @ClassId Int,
        @StudentNO nvarchar(255),
        @StudentName nvarchar(255),
        @Sex nvarchar(255)
    )

AS
    Insert Into Student Values(@LoginId,@LoginPwd,@UserStateId,@ClassId,@StudentNO,@StudentName,@Sex)
Go



/****** 返回所有学员信息 ******/
CREATE PROCEDURE dbo.P_Student_Select
AS
    Select * From Student
Go

   

/****** 根据学员用户名(登录ＩＤ)得到学员实体 ******/

CREATE PROCEDURE dbo.P_Student_GetStudentByLoginId
    (
        @LoginId Varchar(50)
    )
AS
    Select * From Student Where LoginId=@LoginId
GO



/****** 根据学员用户名(登录ＩＤ)删除学员 ******/
CREATE PROCEDURE dbo.P_Student_Delete
    (
        @LoginId Varchar(50)
    )
AS
    Delete From Student Where LoginId=@LoginId
GO



/****** 根据学员用户名(登录ＩＤ)修改学员 ******/
CREATE PROCEDURE dbo.P_Student_Update
    (
        @LoginId Varchar(50),
        @LoginPwd Varchar(50),
        @UserStateId Int,
        @ClassId Int,
        @StudentNo nvarchar(255),
        @StudentName nvarchar(255),
        @Sex nvarchar(255)
    )

AS
    Update Student Set LoginPwd=@LoginPwd,UserStateId=@UserStateId,ClassId=@ClassId,
    StudentNo=@StudentNo,StudentName=@StudentName,Sex=@Sex Where LoginId=@LoginId
GO