- sourcecode.zip
- SourceCode
- Csharp
- Components
- Business
- Data
- Interface
- Parent
- Web
- CSS
- Errors
- Images
- bg_navigation.gif
- delete.gif
- logobanner.gif
- new.gif
- top.jpg
- update.gif
- Login
- UserControls
- Scripts
- ThreeTierGenerator
- VB
- Components
- Business
- Data
- Interface
- Parent
- Web
- CSS
- Errors
- Images
- bg_navigation.gif
- delete.gif
- new.gif
- top.jpg
- update.gif
- UserControls
- demo.zip
- Demo
- ThreeTierDemo
- ThreeTierDemoVB
|
/*==========================================================================================
**
** FILE : ProcShowAdmin_Tb.sql
** Author:Stevan Rodrigues
**
**==========================================================================================
**
** (c) The contents of this file , and of any file or document derived from it , are copyright
** to Site Builders . Unlicensed alteration, change or copying in any form,
** whether written, by photocopy, by print or by any other methods of reproduction is
** strictly prohibited.
**
**==========================================================================================
**
** PURPOSE OF FILE :
**
** DETAILED DESCRIPTION OF FUNCTIONALITY
** LIST OF PARAMETERS USED
**
** LIST OF RETURN VALUES AND THEIR DEFINITIONS
** 0 : Successful
**=========================================================================================*/
if exists( select * from sysobjects where id = object_id(N'[dbo].[ProcShowAdmin_Tb]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop proc [dbo].[ProcShowAdmin_Tb]
go
create procedure ProcShowAdmin_Tb
as
set nocount on
Declare @ErrorNumber int,
@RowCount int
Select
AdminId,
FirstName,
LastName,
Username,
Password,
updatedDate
from Admin_Tb
-- error checking
select @ErrorNumber = @@error,
@RowCount = @@rowcount
if ( @ErrorNumber <> 0 )
begin
/*exec ErrorHandler @ErrorNumber, 'Admin_Tb', 'adding'*/
set nocount off
return 1
end
set nocount off
return 0
go
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
Stevan is a Microsoft Certified Solutions Developer in .Net Architecture (MCSD.Net Early Achiever – one among the first 2500 worldwide), Microsoft Certified Application Developer in .Net – MCAD.Net (Charter Member - one among the first 5000 developers worldwide).