Database

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?

<a href="http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx">http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx</a>[<a href="http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx" target="_blank" title="New Window">^</a>]

There is no hard-coded limit to the number of users that can attach to SQL Server Express but their CPU and memory limits impose practical limits on the number of users that can achieve acceptable response times from a SQL Server Express database.

In C# class, I have written this statement

public class DBConnectionSQL
    {
        string connectionPath = "Data Source=Niladri135\\SQLEXPRESS;Initial Catalog=test;Integrated Security=True";
        string command = "";

            
        public void InsertRecords()
        {

            SqlConnection connection = new SqlConnection(@connectionPath);
            DateTime currentValue  = System.DateTime.Now;
            command = "Insert Into test_Datetime (COL1, COL2,DATE) values('value 1', 'value 2'," + "'" +  currentValue + "'" +  ")";
            try
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand(command, connection);
                cmd.ExecuteNonQuery();
            }
            catch (SqlException sqlExcep)
            {
                string msg = sqlExcep.Message;
            }
            finally
            {
                connection.Close();
            }
        }
    }