While writing SQL Server queries, often I need to extract date part from DateTime columns/variables and it’s very easy to do that: SELECT convert(varchar,getdate(),101) Bonus: How To Retrieve Time Part Alone From DateTime Field Here is the bonus tip to get the time part alone from DateTime fields SELECT convert(varchar,getdate(),108) Hope this helps you.
If you are a web developer then you MUST use jQuery for writing java script. There is no excuses for not to use jQuery and I personally feel it’s a big mistake if jQuery is not used. You want to ask me “Why should I use jQuery?”. Well jQuery is lightweight, awesome, brilliant, exceptionally good …
Problem Today I was struck with an annoying problem while generating LINQ to SQL dbml file for a stored procedure using Visual Studio 2008. When the stored procedure is dragged and dropped on the DBML designer, Visual Studio is generating wrong signature for the stored procedure output: instead of returning a result set as output, …
Fixing LINQ to SQL Issue: Stored Procedure Definition Returns int Instead of ResultSet Read More »
We are developing a web site for one of our customers using ASP.NET MVC. MVC framework is awesome, it provides a very clean architecture for separating UI, business logic & data . For the past 2 weeks I was developing the prototype using Visual Studio 2008 and today the prototype is deployed on one of …
How to Fix 404 Errors of ASP.NET MVC Website Deployed On IIS 6 & Windows Server 2003 Read More »
While analyzing performance of queries we may need to find out the amount of time taken by SQL queries. In order to find the exact amount of time taken by queries, we should clear the SQL Server buffers that cache the data and store procedure execution plans . The following two commands clear SQL Server …
When I tried to access a MySQL database deployed on DreamHost servers from my laptop using mysql command line client and “MySQL Query Browser” I was greeted with the following message MySQL Error Number 1130 Host ‘59.96.189.41’ is not allowed to connect to this MySQL Server. if you want to check the network connection, please …
Fixing the Error “Host ‘xx.xx.xxx.xx’ is not allowed to connect to this MySQL Server” Read More »
All of us would be aware of RULES in SQL Server. A RULE is very similar to a check constraint; however there are few differences between them. Most of the articles in web would have covered how to create a rule, bind a rule to table columns, and unbind the rule and dropping it. But …
How To Check If A Rule Is Bound To A Column In SQL Server 2000 And SQL Server 2005 Read More »
Microsoft’s free XML Notepad 2007 application is a great advantage for all those who are working in the XML programming world. The tool was first introduced in the year 1998. The initial version of it was developed in C++. Later the tool is developed in C# language and its available over internet as free download …
Microsoft’s Free XML Notepad 2007 – A Boon For XML Developers Read More »
As part of one of requirements in our application we had to appended a FlowDocument objects to another FlowDocument object. The requirement looked very simple and I tried the following which loops through the Blocks of source FlowDocument and appends them to target FlowDocument object. sourceDocument = (FlowDocument)XamlReader.Load(memoryStream); // foreach (Block aBlock in sourceDocument.Blocks) { …
How To Merge Two FlowDocument Objects Using C# Code[WPF] Read More »
Google Indic Transliteration is yet another innovative service from Google. It allows users to type in English and transliterate(note that this is not same as not translation) the text to any of the supported Indian languages – Hindi, Tamil, Telugu, Kannada and Malayalam. For instance, If you type “Amitabachan blog”, Google Indic Transliteration for Hindi …
