Database

<code>
CREATE PROCEDURE ia.SP_StaffPhysicianSelectCommand
(
@Param2 varchar(35)
)
AS
SET NOCOUNT ON;

-- Declare local variables
declare @firstName nvarchar(35)
declare @middleName nvarchar(35)
declare @lastName nvarchar(35)
declare @count int
declare @pos int
declare @oldPos int
declare @Param2 nvarchar(35)

-- Initialize local variables
set @oldPos = 0
set @count = 0
set @Param2 = 'a c'

-- Parse the name parameter
set @pos = charindex(' ', @Param2)
while (@pos > 0)
begin
	set @count = @count + 1
	if (@count <= 2)
		begin
			if (@count = 1)
				-- First name
				set @firstName = substring(@Param2, @oldPos, @pos - @oldPos)
			else
				-- Middle name
				set @middleName = substring(@Param2, @oldPos, @pos - @oldPos)
		end
	else if (@count = 3)
		begin
	 		-- Last name
			set @lastName = right(@Param2, len(@Param2) - @oldPos + 1)
			break
		end

	-- Set a position marker and iterate
	set @oldPos = @pos + 1
	set @pos = charindex(' ', @Param2, @pos + 1)

	-- If there are no further spaces, but the end of the string
	-- has not been reached, place the remainder into the next 
	-- open slot
	if (@pos = 0 and @count < 3)
		begin
			if (@count = 1)
				set @middleName = right(@Param2, len(@Param2) - @oldPos + 1)
			else 
				set @lastName = right(@Param2, len(@Param2) - @oldPos + 1)
			set @count = @count + 1
		end
end

-- Evaluate the count: if only 2 words were found, 
-- assume they were a first and last name, adjut the 
-- values accordingly
if (@count = 2)
	begin
		set @lastName = @middleName
		set @middleName = null
	end

-- Finally, select the matching names
SELECT 
	docIndex, docLName, docFName, docMName 
FROM 
	dbo.tblStaffPhysicians
WHERE 
	docFName like '%' + @firstName + '%' AND
	((docMName is null and @middleName is null) OR (docMName like '%' + isnull(@middleName, '') + '%')) AND 
	docLName like '%' + @lastName + '%'	
ORDER BY docLName, docFName
</code>

public static int x;<br />
myID = form1.x;

Class Form2{<br />
    private int var;<br />
    Form2(int x){<br />
       var = x;<br />
    }<br />
}

public static int x;
myID = form1.x;

<br />
declare @a int,<br />
@b int,<br />
@c int,<br />
@d int<br />
select @a = 1, @b= 2<br />
<br />
select @c = 3, @d= 4<br />
<br />
select @a as ColA, @b as ColB, @c as ColC, @d as ColD

<br />
<br />
select Select1.A, Select1.B, Select2.C, Select2.D<br />
from<br />
(select A, B, PriKeyCol from Table1) as Select1<br />
	inner join<br />
(select C, D, ForKeyCol from Table2) as Select2 on select1.PriKeyCol = select2.ForKeyCol