无法在 SSMS 中创建存储过程 [英] Unable to create a stored procedure in SSMS

问题描述

我正在尝试在 SSMS 中创建一个存储过程以将查询结果导出到 CSV.但是我在创建时遇到以下错误.

I am trying to create a stored procedure in SSMS to export the query result to CSV. But I am getting below error while creating.

SQL 语句:

CREATE PROCEDURE SelectUsers
AS
    SELECT * 
    FROM [IMBookingApp].[dbo].[usertest]
    INTO OUTFILE 'C:/S3/users.csv'
    FIELDS TERMINATED BY ','
    ENCLOSED BY '"'
    LINES TERMINATED BY '\n';
GO;

错误

Msg 156, Level 15, State 1, Procedure SelectUsers, Line 4 [Batch Start Line 0]
关键字INTO"附近的语法不正确

Msg 156, Level 15, State 1, Procedure SelectUsers, Line 4 [Batch Start Line 0]
Incorrect syntax near the keyword 'INTO'

任何帮助将不胜感激.

推荐答案

您可以参考此博客，这肯定会解决您的问题.https://www.sqlservercentral.com/博客/export-a-ssms-query-result-set-to-csv

You can refer to this blog and this is going to resolve you issue for sure. https://www.sqlservercentral.com/blogs/export-a-ssms-query-result-set-to-csv

这篇关于无法在 SSMS 中创建存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！