Thanks Experts ! Your words increased my confident evel. I am sure i should clear my client interview. Again, Thanks for all experts.

Use

select

into

from

(or)

Insert into

select

I agreed your words. Nothing wrong with staying in India.But if i get US or UK based offers i am sure i will acquire some good onsite experience.(I mean I...

Gila and Vyas,

Suppose i need to find the length of a string.In that situation which function should i use ?

For example,

Declare @Str varchar(35)

Select @Str = 'Welcome to Sqlservercentral.com'

which statement should...

Thanks Gila and Vyas.:)

Really i am happy with your answer.But...Still i have some questions on spt_values table.

1) How many types are there like 'P' ?

2) I did search in Google,but i didn't get...

I mean where we have lot of SQL Developer vacancies with good package?

Irfan,

Might be lock acquired on the table.

Say for example,

Yesterday Scenario:

---------------------------------------------

Table Name : Emp

your query :

select Eno,Ename from Emp

Table status:

Assume,Nobody done any operations(insertion,updation)on this table.

Assume it gave you the result within...

Hi Vyas,

Can you tell me the difference between LEN('string') and Len(N'String') ?

Also for DataLength('string') and DataLength(N'string').

I am seeing this type of code first time.

Thanks in advance for your reply.

Jeff,

No..This is a different one.Yes i want to print ascii values of A-Z.

Can i use the same logic where you replied for my previous question ?

Kindly tell me, in which...

Jeff,

Can you explain me the logic ?

Also if i want to print A-Z in the mentioned format ,can i use the same logic or do i need to change your code ?

Jeff,

Can you explain me the logic used in your query ?

Really i am confused. I don't understand the link between 'BETWEEN 1 AND 6' and 'LEFT (@STR,number).Also what is the...

I forgot to include

select @InitialValue = @InitialValue + 1

Where exactly cross join is applied in real time ?That is under which circumstance we need to apply cross join ?