Monthly Archives: April 2012

Is jQuery Ajax?

You can do¬† of lot of things with jQuery like click ona button and it it creates new content for you. Click on another it and disppears itself. The question is “Is jQuery Ajax?”.   Ans. jQuery is not aJax … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

SQL Interview Questions

Basic questions Q.How do you query a database? A. We use select statement against a table. We can choose the particular fields that we want or we can pull everything in the table using * for fields. Q.You have student … Continue reading

Posted in Uncategorized | Leave a comment

JOIN using LIKE in SQL

Q. Can I join tow tables using like (more flexible criteria) than exact match? Ans. Yes [sql] — create test table first create table #A ( id varchar(10) ) create table #b( number varchar(5) ) insert into #A values(‘123’) insert … Continue reading

Posted in SQL Server 2008 | Leave a comment

Word to XML : Object reference not set to an instance of an object

Word to XML Mapping You are working with Word. You are mapping a field to XML and you end up getting this error Object reference not set to an instance of an object Cure The error can result if the … Continue reading

Posted in Troubeleshoot | Leave a comment

BETWEEN DATES SQL Server 2008

When dealing with dates, remember there is not such field as date in SQL Server 2005/2008. There is datetime field. For reference there is a date type in MySQL which I think is very useful. There could be problems when … Continue reading

Posted in SQL Server 2008 | 1 Comment

Using SQL BETWEEN in SQL SERVER 2008

In SQL sever 2008, when you use between the lower limit and the upper limit are inclusive in inclusive in the result. create table #temp( id int primary key identity, name varchar(20) ) insert into #temp values(‘a’) insert into #temp … Continue reading

Posted in Software Development | Leave a comment

The column ‘LOCK_ID’ was specified multiple times for ‘BB’.

SQL Server 2008 Error Message: The column ‘LOCK_ID’ was specified multiple times for ‘BB’. Example: select BB.LDC_ACCT_ID from ( select * from STUDENTS S JOIN RECORDS R on S.STUDENT_ID = R.STUDENT_ID ) as TEMP If you run this query in … Continue reading

Posted in SQL Server 2008 | Leave a comment

Using SVN Server on Mac LION OSX

On Windows we are familiar with Visual SVN (Server) and Tortoise SVN (Client), What are my options on Max OSX Lion/Tiger/Mountain Lion? Well Mac OSX Lion comes with SVN Server built in. That means you do not need to install … Continue reading

Posted in Software Development | Leave a comment

Regular Expressions in Visual Studio 2010

Regular Expressions is a power tool that is used in Web Application for verifying valid emails address, password strength among other things. If you have not worked in Web Development environment, you are missing on this powerful tool. Interesting regular … Continue reading

Posted in Software Development | Leave a comment

Cannot cannot to SQL Server database but can connect to Server

Problem You can connect to SQL Server 2005/2008 instance in SQL Server Management Studio (SSMS). It list all the databases but when you try to create a query or right click on a database and select properites, you see this … Continue reading

Posted in Uncategorized | 2 Comments