Tuesday 26 February 2013

Creating my first aspx page

         Yesterday Sudeep gave us the task of creating an aspx page and connecting it to the database. We have started working on it and will try to finish the task as soon as possible.
                

TSQL Programming

  From last two days,we have started learning TSQL Programming. TSQL is non procedural or 4th Generation language because in TSQL we need to specify only what is the problem to solve and no need to specify how to solve the problem step by step hence working with TSQL will be easy but because of non-procedural value it is not possible to solve some complex queries .
  To overcome this problem Microsoft provides programming language feature into SQL which also are collectively called as TSQL Programming.

We have done  some basic programming using :
  •  Conditional Control Statements
  • Looping Control Statements
  • Cursor
Since we completed practicing all basic queries, now we have started with TSQL Programming which is the last part of SQL Server.