Tables



Tables in SQL Server


Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.


Types of Tables are listed below:

TableDescription
Partitioned TablesPartitioned tables are tables whose data is horizontally divided into units which may be spread across more than one filegroup in a database.
Temporary TablesTemporary tables are stored in tempdb. There are two types of temporary tables: local and global. They differ from each other in their names, their visibility, and their availability.LOCAL TEMPORARY TABLES have a single number sign (#) as the first character of their names; they are visible only to the current connection for the user, and they are deleted when the user disconnects from the instance of SQL Server.GLOBAL TEMPORARY TABLES have two number signs (##) as the first characters of their names; they are visible to any user after they are created, and they are deleted when all users referencing the table disconnect from the instance of SQL Server.
System TablesSystem tables in SQL Server stores the data that defines the configuration of the server and all its tables in a special set of tables. Users cannot directly query or update the system tables. The information in the system tables is made available through the system views.
Wide TablesA wide table has defined a column set, which is an untyped XML representation that combines all the sparse columns of a table into a structured output. Wide tables use sparse columns to increase the total of columns that a table can have to 30,000. Sparse columns are ordinary columns that have an optimized storage for null values.

Connection String

SQL Server Connection String Formats

posted on 2019-08-27 05:53:53 - SQL Server Tutorials


UNION

union in SQL server

posted on 2019-08-09 23:05:33 - SQL Server Tutorials


System Functions

System Functions in SQL Server

posted on 2019-08-09 06:14:33 - SQL Server Tutorials


Prompt Examples

ChatGPT Prompt Examples

posted on 2023-06-21 22:37:19 - ChatGPT Tutorials


Use Cases

Chat GPT Key Use Cases

posted on 2023-06-21 21:03:17 - ChatGPT Tutorials


Prompt Frameworks

Prompt Frameworks

posted on 2023-06-21 19:33:06 - ChatGPT Tutorials