Sharepoint - Asp.net - MVC - C# - Sql server - Jquery - Javascript

Introduction Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified  tables . Triggers are bound to specific  tables. As per MSDN , triggers can be defined as the special kind of stored procedures. Before describing the types of triggers, we should first understand the Magic tables which are referenced in triggers and used for reuse. Magic Tables     There are two tables Inserted and deleted in the SQL Server, which are popularly known as the Magic tables. These are not the physical tables but the SQL Server internal tables usually used with the triggers to retrieve the inserted, deleted or updated rows. These tables contain the information about inserted rows, deleted rows and the updated rows. This information can be summarized as follows: Action      ...

Hi, here my planning is to i have string with several values like string abcd={a=1,b=2,c=3,......z=26}. this is i have to select particular values like {j=10,l=12,q=17}. so here is my code that will retrive data like above scenerio. try             {                 String sOrrData = e.Result.ToString();//assigning abcd string to this string.                 string sOrr = "";                 String[] sOrrValues ={"j","l","q" };                 for (int i = 0; i < sOrrValues.Length; i++)                 {       ...

Actually my code is this ,am  getting this error for substring . here am writing my code this error. try             {                 if (tbMeterID.Text == "")                     return;                 if (tbMeterID.Text.Substring(4, 1) == "E")                 {                    //do some thing                   } }  am change the code as below. am solved this prob like this way. if (tbMeterID.Text != "")  ...

What is Difference between ER Modeling and Dimensional Modeling? ER modeling is used for normalizing the OLTP database design. Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design. What is Degenerate Dimension Table? If a table contains values, which are neither dimension nor measures, then it is called a degenerate dimension  table. Why is Data Modeling Important? Data modeling is probably the most labor intensive and time consuming part of the development process. The goal of the data model is to make sure that the all data objects required by the database are completely and accurately represented. Because the data model uses easily understood notations and natural language, it can be reviewed and verified as correct by the end users. In computer science, data modeling is the process of creating a data model by applying a data model theory to create a data model instance. A data model theory is a formal data model description. In data modeling, we are stru...