Shulou(Shulou.com)05/31 Report--

How to use temporary tables in sqlserver? for this problem, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Usage: when used in complex queries, temporary tables can be used to temporarily store related records, which can improve efficiency and program readability. Similar to the my_cursor declare my_cursor cursor scroll for select fields in cursors, from tablename temporary tables are divided into user temporary tables and system temporary tables. The difference between the system temporary table and the user temporary table: 1) user temporary table: the name of the user temporary table begins with #; the cycle of the user temporary table exists only in the Session of the user who created the table and is not visible to other processes. This temporary table is automatically deleted when the process that created it disappears. 2) system temporary table: the name of the system temporary table begins with # #. The global temporary table is visible to the entire SQL Server instance, but when all the Session that accesses it disappears, it is automatically deleted, such as restarting the database. Create a temporary table format: 1) copy the code as follows: create table TempTableName (ID int IDENTITY (1Power1) not null, A1 varchar (50), a2 varchar (50), A3 varchar (50), primary key (ID)-defines ID as the primary key of temporary table # Tmp)

2) select [field 1, field 2dome.,] into # Tmp from table query temporary table data select * from # Tmp delete temporary table drop table # Tmp empty all data and constraints truncate table # Tmp of temporary table

This is the answer to the question about how to use the temporary table in sqlserver. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.