C#中使用SQLDMO的StoredProcedure对象(存储过程)创建数据表「建议收藏」

大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。

Jetbrains全系列IDE使用 1年只要46元 售后保障 童叟无欺

                …….
                SQLDMO.StoredProcedure strProc = new SQLDMO.StoredProcedure();
                // Assign a name to stored procedure
                strProc.Name = “createCustomerTable”;
                // Write a Stored Procedure Script and pass it as a string.
                strProc.Text = “CREATE procedure createCustomerTable as begin ” +
                    “CREATE TABLE [ChangeMemberID] ([CusID] [int] NOT NULL ,[ChangeDate] [smalldatetime] NULL ,”+
                 “[MIDO] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,”+
                 “[MIDN] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] ” +
                    “END”;
                // Add the Stored Procedure to Database
                nDB.StoredProcedures.Add(strProc);
                // Execute the stored procedure to create table
                nDB.ExecuteImmediate(“createCustomerTable”, 0, 0);

                /* Remove the stored procedure from database. The index starts from 1.*/
                foreach (SQLDMO.StoredProcedure tmpSP in nDB.StoredProcedures)
                {

                    //find the StoredProcedure named “createCustomerTable”
                    if (tmpSP.Name == “createCustomerTable”)
                    {

                        nDB.StoredProcedures.Remove(tmpSP.ID, “”);
                        break;
                    }
                }