MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology

ADO.NET

s
ADO.NET Projects

ADO.NET Project 1

ADO.NET Examples

Examples

Working with Stored Procedures
Previous Home Next

"a precompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit". Stored procedures allow a more flexibility offering capabilities such as conditional logic .Bandwidth and execution time are reduced because stored procedures are stored within the DBMS,. because a single stored procedure can execute a complex set of SQL statements. SQL Server pre-compiles stored procedures such that they execute optimally and client developers are abstracted from complex designs. They would simply need to know the stored procedure's name and the type of data it returns.

To add a new stored procedure to the Northwind Microsoft SQL database, perform these steps.

  1. Load SQL Server Enterprise Manager, found in the Microsoft SQL Server program group.
  2. Expand the tree "Microsoft SQL Servers," "SQL Server Group," and locate your database server. With SQL installed locally, the default server will be (LOCAL
  3. Locate and expand the Student database. Select Stored Procedures. On the right side of the screen, you'll see any default stored procedures included with the student database.
  4. Right-click anywhere on the right pane of the Enterprise Manager and select New Stored Procedure.

     

    Simple insert Stored Procedure
    use student
    create procedure studentinsertproc
    @stdid text,@subid text,@subname text,@mark int
    as
    insert into student
    (stdid ,subid,subname,mark)values(@stdid,@subid,@subname,@mark)
    studentinsertproc '10001','101','computer graphics',85
    studentinsertproc '10002','101','computer graphics',65,
    studentinsertproc '10003','101','computer graphics',75
    studentinsertproc '10004','101','computer graphics',55
    studentinsertproc '10005','101','computer graphics',85
    studentinsertproc '10006','101','computer graphics',87
    select * from student
    
  5. select and press F5
Previous Home Next