資源簡介
為學生數據庫增加一個查詢男生或女生的存儲過程,并設計應用程序使用該存儲過程。
提示:
存儲過程語句如下:
ALTER PROCEDURE SelectManStudent(@Sex nchar(1))
AS
SELECT StudentNum,StudentName,StudentSex FROM Student WHERE(StudentSex=@Sex)
RETURN
代碼片段和文件信息
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????389120??2013-12-30?22:52??S11-1\D.accdb
?????文件??????10240??2013-12-30?23:27??S11-1\S11-1\bin\Debug\S11-1.exe
?????文件??????26112??2013-12-30?23:27??S11-1\S11-1\bin\Debug\S11-1.pdb
?????文件??????11600??2013-12-30?23:32??S11-1\S11-1\bin\Debug\S11-1.vshost.exe
?????文件????????490??2009-08-31?00:40??S11-1\S11-1\bin\Debug\S11-1.vshost.exe.manifest
?????文件???????2738??2013-12-30?23:27??S11-1\S11-1\Form1.cs
?????文件???????4798??2013-12-30?23:27??S11-1\S11-1\Form1.Designer.cs
?????文件???????6013??2013-12-30?23:27??S11-1\S11-1\Form1.resx
?????文件???????6527??2013-12-30?23:31??S11-1\S11-1\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????6307??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????694??2013-12-30?23:32??S11-1\S11-1\obj\x86\Debug\S11-1.csproj.FileListAbsolute.txt
?????文件????????975??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\S11-1.csproj.GenerateResource.Cache
?????文件??????10240??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\S11-1.exe
?????文件??????26112??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\S11-1.pdb
?????文件????????180??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\S11_1.Form1.resources
?????文件????????180??2013-12-30?22:42??S11-1\S11-1\obj\x86\Debug\S11_1.Properties.Resources.resources
?????文件????????486??2013-12-30?22:14??S11-1\S11-1\Program.cs
?????文件???????1342??2013-12-30?22:14??S11-1\S11-1\Properties\AssemblyInfo.cs
?????文件???????2862??2013-12-30?22:14??S11-1\S11-1\Properties\Resources.Designer.cs
?????文件???????5612??2013-12-30?22:14??S11-1\S11-1\Properties\Resources.resx
?????文件???????1092??2013-12-30?22:14??S11-1\S11-1\Properties\Settings.Designer.cs
?????文件????????249??2013-12-30?22:14??S11-1\S11-1\Properties\Settings.settings
?????文件???????3669??2013-12-30?22:37??S11-1\S11-1\S11-1.csproj
?????文件????????857??2013-12-30?22:14??S11-1\S11-1.sln
????..A..H.?????19456??2013-12-30?23:32??S11-1\S11-1.suo
?????目錄??????????0??2013-12-30?22:14??S11-1\S11-1\obj\x86\Debug\TempPE
?????目錄??????????0??2013-12-30?23:31??S11-1\S11-1\obj\x86\Debug
?????目錄??????????0??2013-12-30?23:31??S11-1\S11-1\bin\Debug
?????目錄??????????0??2013-12-30?22:14??S11-1\S11-1\obj\x86
?????目錄??????????0??2013-12-30?22:14??S11-1\S11-1\bin
............此處省略7個文件信息
-----------?---------??----------?-----??----
?????文件?????389120??2013-12-30?22:52??S11-1\D.accdb
?????文件??????10240??2013-12-30?23:27??S11-1\S11-1\bin\Debug\S11-1.exe
?????文件??????26112??2013-12-30?23:27??S11-1\S11-1\bin\Debug\S11-1.pdb
?????文件??????11600??2013-12-30?23:32??S11-1\S11-1\bin\Debug\S11-1.vshost.exe
?????文件????????490??2009-08-31?00:40??S11-1\S11-1\bin\Debug\S11-1.vshost.exe.manifest
?????文件???????2738??2013-12-30?23:27??S11-1\S11-1\Form1.cs
?????文件???????4798??2013-12-30?23:27??S11-1\S11-1\Form1.Designer.cs
?????文件???????6013??2013-12-30?23:27??S11-1\S11-1\Form1.resx
?????文件???????6527??2013-12-30?23:31??S11-1\S11-1\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????6307??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????694??2013-12-30?23:32??S11-1\S11-1\obj\x86\Debug\S11-1.csproj.FileListAbsolute.txt
?????文件????????975??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\S11-1.csproj.GenerateResource.Cache
?????文件??????10240??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\S11-1.exe
?????文件??????26112??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\S11-1.pdb
?????文件????????180??2013-12-30?23:27??S11-1\S11-1\obj\x86\Debug\S11_1.Form1.resources
?????文件????????180??2013-12-30?22:42??S11-1\S11-1\obj\x86\Debug\S11_1.Properties.Resources.resources
?????文件????????486??2013-12-30?22:14??S11-1\S11-1\Program.cs
?????文件???????1342??2013-12-30?22:14??S11-1\S11-1\Properties\AssemblyInfo.cs
?????文件???????2862??2013-12-30?22:14??S11-1\S11-1\Properties\Resources.Designer.cs
?????文件???????5612??2013-12-30?22:14??S11-1\S11-1\Properties\Resources.resx
?????文件???????1092??2013-12-30?22:14??S11-1\S11-1\Properties\Settings.Designer.cs
?????文件????????249??2013-12-30?22:14??S11-1\S11-1\Properties\Settings.settings
?????文件???????3669??2013-12-30?22:37??S11-1\S11-1\S11-1.csproj
?????文件????????857??2013-12-30?22:14??S11-1\S11-1.sln
????..A..H.?????19456??2013-12-30?23:32??S11-1\S11-1.suo
?????目錄??????????0??2013-12-30?22:14??S11-1\S11-1\obj\x86\Debug\TempPE
?????目錄??????????0??2013-12-30?23:31??S11-1\S11-1\obj\x86\Debug
?????目錄??????????0??2013-12-30?23:31??S11-1\S11-1\bin\Debug
?????目錄??????????0??2013-12-30?22:14??S11-1\S11-1\obj\x86
?????目錄??????????0??2013-12-30?22:14??S11-1\S11-1\bin
............此處省略7個文件信息
評論
共有 條評論