Database

select a.product as prodin,b.product as prodout
from product a, product b

prithaa wrote:

Please give sites which offers such query types

	@Filter		int,	@theRows	int output
AS
BEGIN	
SELECT		Field1,		Field2	
FROM		MyTable	
WHERE		FilterField=@Filter	

SELECT @theRows = @@ROWCOUNT
END

@Filter		int,	
@theRows	int output
AS
BEGIN	
	SET @theRows=(SELECT	Count(Field)	
                      FROM	MyTable	
                      WHERE	FilterField=@Filter)
END

safealloys wrote:

After creating table what next? -

safealloys wrote:

what next action after creating tables in SQL and creating interface in VB.net