June 19, 2020 at 2:34 am
Hi,
I have three stored procedures, as below
SP_Extract_Data
SP_Load_Data_Into_Temp
SP_Load_Data_Into_Real_Table
I know there is available tools can use to call the stored procedures:-
It can be applications such as C# Net
It can be SQL Server Itself SSIS
Or it can be create agent job to call
But beside of above, is any else more tools can recommend?
June 19, 2020 at 3:50 pm
SQLCMD can be used as well
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2020 at 5:06 pm
Powershell and visual basic script.
You also say "C# NET", but really any .NET language (or even non-.NET languages like VB6) can talk to SQL Server.
It really depends on what you are doing with those stored procedures as to what you can use. Based on the names of them only, I'm thinking these don't return any tables, but update and insert data into tables. If they do return table results, SSRS would be another option or Power BI.
And you could (but I wouldn't recommend) use Excel.
There are a LOT of tools that can run stored procedures.
If those are user-made stored procedures (which I think they are), I would strongly encourage you to not prefix the name with "SP_". A good read on this is available here:
https://bornsql.ca/blog/remember-this-if-you-want-to-use-sp_/
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply