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