Friday, June 10, 2022

Naming of Views, stored procedure, tables etc in SQL Server

 View:- VW_Student_Reg_Details, UVW_MST_TBL_STUD_PAYMENT_NEW

Stored Procedure:- spu_AddUpdate_RateMaster

                                Spu_Get_I_Status_PMU or FETCH_BATCH_CATEGORY_STUDENT_COUNT

                                USP_CA_SCHEDULE_EXAM_UPDATE_BATCH2nd, UPD_STU_REG(Update stored procedure)

                                SP_Insert_SD_Value or  SP_Add_InvoiceDetails

                                DELETEBY_ID, DELETEALL

                                EXISTANCE_OF_IdentityType


Table:- MST_BANK or T005_InvoiceDetails_History ( in old project, we want to change our tables with existing tables) or TBL_BATCH_EXTEND or PageName_master, MST_TBL_STUD_PAYMENT_NEW

stored procedure for view:- SP_VW_TRAINING_PARTNER_DETAILS

No comments:

Post a Comment