Software / Technology Tips

What is the result for this query although there null in address column SELECT EMPLOYEENAME,EMPLOYEEADDRESS FROM  EMPLOYEE WHERE ADDRESS=NULL Ofcourse will get a result set with no datarows Write a query like SELECT EMPLOYEENAME,EMPLOYEEADDRESS FROM  EMPLOYEE WHERE ADDRESS=NULL will get a result set with zero rows of data although there is rows having value null…

To create XML using LINQ as follows Step 1: XElement class takes care of converting the LINQ query resultant into data in XML format. So, declare the name space “using System.Xml.Linq;” Step 2: Now, the LINQ query should be written in the below format: DataClassesDataContext dlDC = new DataClassesDataContext(); var inventory = new XElement("InventoryINFO", from…

Upsizing Wizard is used to migrate the tables present in an access database to SQL server DataBase.It is found on the Access menu at Tools –> Database Utilities–> Upsizing Wizard. Although the upsizing wizard can handle many of the differences between sql and access and convert objects correctly, but it can’t handle all the differences. Before…

How to install ColdFusion 9 and 10 on same machine (on windows 7) ColdFusion 10 is out and most of the developers want to gets their hands dirty with ColdFusion 10. As well as they want to check their code compatibility with ColdFusion 10 also. So the basic thing is to install the ColdFusion 10…

What :  A loosely typed programming languages is typically one that does not require the data type of a variable to be explicitly stated. Example : As in JavaScript we can declare var count = 1;  which will automatically treat variable count as integer. Advantage: The advantage of loosely typed is that we don’t have…

At times during coding in Coldfusion, we get stuck at places, where we need to create variables dynamically. We may attempt with below code to create dynamic variables. Here I am expecting to create variables as variables.employee1, variables.employee2… and assign them some values but on execution the following error is thrown ColdFusion was looking at…

Suppose we need the following XML format, 1230098-ASU-DRED T E S T Final Arizona State University 686699454647 1230098-PSY-GREY T E S T Final Arizona State University 686699454649 Now the serialization classes will look like this, public class INVSSTDOCP { public ProductParam[] Parameters { get; set; } } public class ProductParam { public Key Key {…

1. UniqueKeyConstraint A UniqueKey in a datatable defines the uniqueness of records means the data present in the specified column is unique. Unique constraint can be added to a data table by using the UniqueConstraint constructor. Please look at the below codes. The code creates a unique constraint on the CustomerID table of the CustomerTable. …

Reporting mechanism has become more dynamic and flexible with Microsoft Dynamics CRM that provides  a Reporting Wizard  that enables Users to create basic reports on-the-fly  as well as custom reports and share them with the organization. Microsoft Dynamics CRM handles all the reports with Microsoft SQL Server Reporting Services (SRS), which is a separate application…

Case 3:   With Integer Data types: If integer datatype is used, DATALENGTH()  returns 4 and LEN() returns the number of digits. Example:                 DECLARE  @Value1 int, @value2 int SET @value1=2 SET @value2 =20000 SELECT  DATALENGTH(@value1) SELECT  LEN(@value1) SELECT  DATALENGTH(@value2) SELECT  LEN(@value2) The DATALENGTH()  returns 4 in both the cases because int always takes 4 bytes, whatever…