使用sqlserver2005中的存储过程从表中插入数据 [英] insert data from a table using stored procedures in sqlserver2005

问题描述

嗨

我需要编写具有一个参数(必须是表名)的存储过程，该参数必须从外部给出.

然后在给定表名的同时，必须对表数据进行脚本化并另存为.xl扩展文件


为此，我必须编写存储过程，请紧急发给我

解决方案

写道:​​

请紧急发送给我

这很不礼貌.您的帮助需求对我们而言并不紧急，我们会在我们的时间和时间表允许的情况下免费为您提供帮助.如果您想给出最后期限，请找人帮助您.

您希望存储的proc将表作为.xl文件保存到服务器吗?您是说.xls吗?您是否想要任何特定的格式?为什么要将其保存在服务器上?

hi

i need to write stored procedure which have one parameter(this must be table name) which have to give from outside.

and then while table name is given that table data have to be scripted and save as .xl extension file


for this i have to write stored procedure please send me urgently

解决方案

wrote:

please send me urgently

This is rude. Your need for help is not urgent to us, we are helping you for free, as our time and schedule permits. If you want to give a deadline, pay someone to help you.

You want your stored proc to save the table to the server as a .xl file ? Do you mean .xls ? Do you want it in any particular format ? Why do you want to save it on the server ?

这篇关于使用sqlserver2005中的存储过程从表中插入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！