Database

 -- Created by NILADRI BISWAS
           ALTER FUNCTION [dbo].[fnSplit] 
           (@oldstring as varchar(100),@delimeter as varchar(1))
           RETURNS @mytab table(counter int,stringval varchar(100)) 
           AS
            Begin 
		
		Declare @newstring as varchar(100)
		Declare @pos as int
		Declare @i as int
		Declare @c as int	

		set @newstring = '';		
		set @i = 1
		set @c = 0

		set @pos = CHARINDEX(@delimeter, @oldstring) 

		WHILE (@i != 0)

			Begin

				set @c = @c +1
				insert into @mytab(counter,stringval) values(@c,@newstring + Substring(@oldstring,0, @pos))

				
				set @oldstring = Substring(@oldstring,@pos+1,len(@oldstring))

				set @pos = CHARINDEX(@delimeter, @oldstring)

				set @i = @pos;
				if (@i = 0)
                Begin
                    set @i = 0;
						set @c = @c +1
                
					insert into @mytab(counter,stringval) values(@c,@newstring + @oldstring)
					
                End

			End

			return 

End

-- Created by NILADRI BISWAS
       ALTER PROCEDURE dbo.SortedList
	-- Add the parameters for the stored procedure here
	(@DelimitedValues AS VARCHAR(50))
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	DECLARE @OUTPUT VARCHAR(30)
	DECLARE @TEMPOUTPUT VARCHAR(30)
    
	SET @OUTPUT = ''
	SET @TEMPOUTPUT = ''

	DECLARE @MYCURSOR CURSOR
	SET @MYCURSOR = CURSOR FOR

SELECT STRINGVAL FROM dbo.fnSplit(@DelimitedValues,',')
	ORDER BY RIGHT(REPLICATE('0', 11) + stringval, 10)

OPEN @MYCURSOR
	FETCH NEXT
	FROM @MYCURSOR INTO @TEMPOUTPUT
	WHILE @@FETCH_STATUS = 0

	BEGIN
	SET @OUTPUT =  @OUTPUT + @TEMPOUTPUT + ','

	FETCH NEXT
	FROM @MYCURSOR INTO @TEMPOUTPUT
	END
	CLOSE @MYCURSOR
	DEALLOCATE @MYCURSOR

SET @OUTPUT	 = SUBSTRING(@OUTPUT,0,LEN(@OUTPUT))

	PRINT @OUTPUT	
END

SELECT * FROM  
                           ( 

                                 ( STUDENTS AS A  LEFT JOIN SUBDETAILS AS B ON A.BID=B.BID)
                                   
                                  LEFT JOIN SUBJECTS C ON B.SUBID=C.SUBID
                            )

                           LEFT JOIN DETAILS D ON C.SUBID=D.SUBID 

                   WHERE D.HNO=1234 

                   AND B.BID=2 

                   AND B.SEMID=1

                   AND A.HNO=D.HNO

SELECT a.*
FROM ((Student AS a LEFT JOIN Subdetails AS b ON a.bid = b.bid) 
LEFT JOIN Subjects AS c ON b.subid = c.subid) 
LEFT JOIN details AS d ON c.subid = d.subid
WHERE (((b.bid)=2) AND ((b.semid)=1) AND ((d.hno)=1234) AND ((d.hno)=[a].[hno]));


PARAMETERS inBid Long, inSemid Long, inHno Long;
SELECT a.*
FROM ((Student AS a LEFT JOIN Subdetails AS b ON a.bid = b.bid) 
LEFT JOIN Subjects AS c ON b.subid = c.subid) 
LEFT JOIN details AS d ON c.subid = d.subid
WHERE (((b.bid)=[inBid]) AND ((b.semid)=[inSemid]) AND ((d.hno)=[inHno]) AND ((d.hno)=[a].[hno]));

Coming to your question directly, Do you use FLOAT or NUMERIC for financial transaction?

kikeman wrote:

I saw other forums that someone say that SQL Server Express is limited to 10 users only and 4G bytes of data. Is this true?

kikeman wrote:

Can I develop a distributed database?
So that, actually the DB is all over on the networked computers?