Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Haja Mohideen
Starting Member
12 Posts |
 Posted - 2014-12-04 : 08:58:10
|
| In sql server we have different type table creation, It should difference from one to another. What we can achive or accomplish by this different type table creation that is mentioned below1) Permanent Table -- create table table_name2) Local Temporary Tables -- CREATE TABLE #table_name3) Global Temporary Tables -- CREATE TABLE ##table_name4) Table Variables -- DECLARE @people TABLE 5) C.T.E -- WITH Sales_CTE (Sales_id,city,state) Please give some detailed information or your valuable idea's or weblink that contain detailed information or some document. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-04 : 09:24:03
|
| you can look all these up in BOL or google them easily enough |
 |
|
|
|
|
|
When we need to create different type of table