pls help me out with this SQL query

Also, i wouldn't check strings like that, i would make use of LIKE keyword:

Hi Tapan,

I had asked couple of C#(VB.NET) questions yesterday, I believe, the page is no longer active. Can you please help me out with those questions please ?

1. Please review the following vb.net code and answer the corresponding questions.

Public Function ParseClassesOfService(ByVal str As String) As List(Of ClassOfService)

Dim classList As New List(Of ClassOfService)

Dim serviceClass As ClassOfService

For Each text As String In str.Split(CChar(" "))

serviceClass = New ClassOfService

serviceClass.Code = text.Substring(0, 1)

classList.Add(serviceClass)

Next

Return ClassList

End Function

A. How many characters is the service class code according to this function?

What is this function doing?

Thanks

Thank you Tapan,

so the current query would be :-

Select *

From [Course] course with (nolock)

Join [Student] student with (nolock)

On course.[Course_ID] = student.[Course_ID]

Where student.[Name] = 'John Doe'

correct ?

You are joining on wrong column.

 

 

Do something like this if student table contains the foreign key named course_id.

 

On course.[Course_ID] = student.[Course_ID] 

 

this join won't return anything and hence you will not find the row with John Doe.

 

Please mark it as an answer if it addresses the issue.