Nice attempt. Here in this article you should explain why SQL server does like this. I'm referring to the Index Statistitics. You can also mention in the article that if...

Thanks Steve for the correction.

Thanks,

Sandip

http://sqlcommitted.com

Good Question!!

Thanks you Kraig.

Sandip Pani

http://sqlcommitted.com

Thank you All.

According to me you all are right . I posted this question with 4 options i.e. 1,2,3 and 5. The option 4 was not added by me. The site admin...

According to me you all are right . I posted this question with 4 options i.e. 1,2,3 and 5. The option 4 was not added by me. The site admin...

Hope the below link will give better clarification

http://stackoverflow.com/questions/5967035/using-function-as-a-parameter-when-executing-a-stored-procedure

Let me know if you need more explanation

Not sure but if you are filtering the records using pattern matching use Not Like instead of !=.

Check this links

http://msdn.microsoft.com/en-us/library/ms156305.aspx

http://msdn.microsoft.com/en-us/library/ms157252.aspx

The second select statement will return 1, as it will fail only after 1st insert statemnt of dbo.cuss2.

In MS SQL SERVER 2005 the create stament will work if you remove the extra comma but in MS SQL SERVER 2008 it won't work as Date is a...

Please provide the Table structure and what exact output you want.

Declare @CDate nvarchar(max);

Declare @VDate nvarchar(max);

Set @CDate = Select substring(DateOfPayBill,3,5) AS Date from Tvarizi

Set @VDate = Select substring(Recievedate,3,5) AS Date from Tvarizi

It is throwing error because your "Select substring(DateOfPayBill,3,5) AS Date...

Can you tell me How are you getting

3 FL NULL

9 NY G in your result set

Provide the complete table structure and your requirement clearly ...

Are you looking for something like below.(not sure) :unsure:

Update B

Set B.L_RID=A.RID

from TableB B inner join TableA A on B.ID=A.ID