存储过程创建全局临时表

最新推荐文章于 2024-08-22 15:32:21 发布

lglgsy456

最新推荐文章于 2024-08-22 15:32:21 发布

阅读量1.8k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/lglgsy456/article/details/41744357

本文介绍如何使用SQL Server创建一个临时表，用于存储来自InstagramData数据库中的Post数据，并提供了一个存储过程示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE CreateTempTableForPostIdWithIdentity
-- Add the parameters for the stored procedure here
@StartWith int
AS

BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

--Create Temp Table
IF Object_id('Tempdb..##PostIdWithIdentity') IS NOT NULL
DROP TABLE ##PostIdWithIdentity

CREATE TABLE ##PostIdWithIdentity
(
ID int IDENTITY (1,1) not null,
PostId nvarchar(255),
Tags nvarchar(MAX),
primary key (ID)
)
truncate table ##PostIdWithIdentity
insert into ##PostIdWithIdentity(PostId,Tags) select Id,Tags from [InstagramData].[dbo].[Post]
Select Top(10)* from ##PostIdWithIdentity

-- Insert statements for procedure here
--SELECT row_number() over (order by Id asc) as id,Id as PostId,Tags From [InstagramData].[dbo].[Post]
END
GO