public void Turns_Alter_Proc_Into_Create_Proc_Statement() { var script = @" alter procedure do as select 2; create table blah(i int)"; var parser = new DdlScriptParser(SqlServerVersion.Sql120); var statements = parser.GetStatements(script); Assert.AreEqual(1, statements.Count); Assert.AreEqual(@"CREATE PROCEDURE do AS SELECT 2; CREATE TABLE blah ( i INT );", statements.FirstOrDefault()); }
public void Finds_Create_Proc_Statement() { var script = @"if object_id('do') is not null begin drop procedure do end ; go create procedure do as select 2; create table blah(i int)"; var parser = new DdlScriptParser(SqlServerVersion.Sql100); var statements = parser.GetStatements(script); Assert.AreEqual(1, statements.Count); Assert.AreEqual(@"CREATE PROCEDURE do AS SELECT 2; CREATE TABLE blah ( i INT );", statements.FirstOrDefault()); }