Primary keys in SQL tables allow us to uniquely identify the rows. These keys also allow us to establish the relationship between tables based on foreign key-primary key concept. Though we can have different id field names in CRM tables, the standard primary key feature is well maintained with field names like “_” (e.g. Case_CaseId).… Read More »
Usually in SQL, date gets saved as ‘2009-07-27 00:00:00.000’ but when we run the query or call date from any application the SQL gives us the date in desired format like ’07/27/2009’. How does it work? SQL has set of formats according to the different languages for example ‘British’, ‘Dutch’, ‘German’, ‘English’ etc. By Default… Read More »
If you are facing this error while executing the query from the ASP page: And you find that the sql query working fine in the SQL Query Analyzer. It might be a problem with Query Time out duration. Solution: We can set the CommandTimeOut property of the ADODB command object. The default value is 30… Read More »