In one of the articles , we explained How to Disable All Constraints in the Database temporarily in SQL Server ? , let’s look at the option of how to enable back the constraints in the SQL Server Database. How to Enable All Constraints back in the Database in SQL Read more
There are times when you may want to disable all the constraints in the your SQL Server Database tables when importing the data from the external data source . How to Disable All Constraints in the Database temporarily in SQL Server ? Below is a sample query that lets you Read more
Looking to add a column with default value to an existing table in SQL Server ? Below is an example and sample Data Definition Language Query for achieving the same. How to Add a Column with Default Value to Existing Table in SQL Server ? Assume that the table name Read more
Below is a sample query that demonstrates how to update a table by getting the data from the select query in SQL Server. Assume that there are 2 tables AbundantCodeEmployee and AbundantCodeDepartment which contains the id . The id(in department) in this example refers to the department head . The columns Read more
There are times when you want to apply some styles to a control in Windows Phone 8 but you may not want to start it from scratch . In these scenarios , the developers can use the property “BasedOn” to reference another style that is defined . For example , Read more
In one of the previous article , we demonstrated how to create an explicit style in Windows Phone 8 for TextBlock . In this article , we will explore how one can create an implicit style in Windows Phone 8. How to Create an Implicit Style in Windows Phone 8 Read more
The developers can utilize the style resources to create styles and use them within the Windows Phone Application. For example , the developers can create a style for the textblock with a key identifier in the app.xaml file and then reuse them in different screens of the application. How to Read more
Below is a sample code snippet that demonstrates the Immediate Query execution of LINQ Query in C#. Example of Immediate Query Execution of LINQ in C# .NET using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.DirectoryServices.AccountManagement; using System.IO; using System.Linq; using System.Net; using System.Net.Sockets; using System.Reflection; namespace AbundantCode { Read more
Below is a sample code snippet that demonstrates the deferred execution of LINQ Query in C#. Example of deferred execution of LINQ Query in C# .NET using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.DirectoryServices.AccountManagement; using System.IO; using System.Linq; using System.Net; using System.Net.Sockets; using System.Reflection; namespace AbundantCode { internal Read more
There are times when you want to specify the exit code from the Main function for example when working on the Console Application in .NET . How do Specify the Exit Code of Console Application in .NET? You can use the Environment.Exit to specify the exit code in the Console Read more