Support us .Net Basics C# SQL ASP.NET Aarvi MVC Slides C# Programs Subscribe Download

Part 1 – Connecting to SQL Server




2 comments:

  1. Dear venkat,
    I Request to you Please tell me What is difference between Cte,Declared Table,Temparary Table When Use over other...

    Best Regards,
    Susheel Singh

    ReplyDelete
    Replies
    1. cte w call common table expression where we store the value of query in result and then same result we can use to get for multiple use

      like

      with result_cte (col1,col2)
      (
      select * from table name
      )

      that query value will store in result then u can apply for next level for use.

      table is collection of row and colums . in database we create table to store value as per codd rules one field can have only one value and apply constrain part as well

      see simple table creation

      create table emp (id int)

      temparary table is making for temporary purpose . that is two type . if u use single # sign before table and crteate table then its known as loacal temp table and when we create ##sign for create table then we call as global table . both table store in temp system database .

      Delete

It would be great if you can help share these free resources