Run SQL Server Scripts using C#
In this article I will run a SQL Server script to backup a database using C# in visual studio. For this purpose, I am going to use the sqlcmd.
2012-04-27
14,991 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Linked server to MySQL Server.
In this article, we are going to create a linked server to the MySQL Database.
Once finished that task, we will select, insert, update and delete some data using SQL Server.
2012-04-17
9,221 reads
Sequences in SQL Server 2012
This article describes the sequence new feature used in SQL Server 2012
2012-04-13
9,167 reads
Bye Bye to the RAISERROR Function?
This article describes the use and advantages of the throw statement.
2012-04-03
2,599 reads
How to create a database backup using visual studio
This article describes how to backup a database using a C# Windows Form.
2012-03-30
12,748 reads
A Demo of the Power of Powershell
This demo will show you the how powerfull is powershell. We will use cicles and the get-content command.
2012-03-22
9,873 reads
Blogs
Daily Coping 18 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
I’ve added a new parameter to my permissions scripts (well, just the main two...
Creating TAIL on Windows for Text Files
By Steve Jones
UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about...
Forums
How to use PowerShell to set secure SA passwords for bulk servers
Comments posted to this topic are about the item How to use PowerShell to...
INSERT EXEC statement cannot be nested, the Simple Solution
Comments posted to this topic are about the item INSERT EXEC statement cannot be...
Cleaning Tables
Comments posted to this topic are about the item Cleaning Tables
Ask SSC