InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:42:30 GMT20http://www.sqlservercentral.com/Forums/Topic970280-146-1.aspxor it shud be like belowcreate procedure aaasbegin if exists (select * from sys.objects where name='bb') begin drop procedure bb declare @a nvarchar(max) set @a='create procedure bb as begin print ''bb'' end' exec sp_executesql @a endendBut as Gail's suggestion.... why u want to do this??? is this some class room based question???Tue, 17 Aug 2010 06:38:51 GMTRamji29http://www.sqlservercentral.com/Forums/Topic970280-146-1.aspxWell, the GO in the 'middle' of procedure A ends the batch. Hence leaving a begin without an end and, in the second batch an end without a begin.GO is a batch breaker. It tells SSMS where to delimit the batches sent to SQL. So what you're telling SSMS is that the first batch it must send is[code="sql"]create procedure aaasbegin if exists (select * from sys.objects where name='bb') begin drop procedure bbGO[/code]As I'm sure you can see, that is not valid SQL.Again, I need to ask why you want a procedure to create a procedure? What's the point?Tue, 17 Aug 2010 06:06:23 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic970280-146-1.aspxHi,Thanks for reply[code]create procedure aaasbegin if exists (select * from sys.objects where name='bb') begin drop procedure bb go declare @a nvarchar(max) set @a='create procedure bb as begin print ''bb'' end' exec sp_executesql @a endend[/code]after run this code i got following error message[code]Msg 102, Level 15, State 1, Procedure aa, Line 9Incorrect syntax near 'bb'.Msg 156, Level 15, State 1, Line 7Incorrect syntax near the keyword 'end'.[/code]Tue, 17 Aug 2010 05:57:45 GMTTrouble Shooterhttp://www.sqlservercentral.com/Forums/Topic970280-146-1.aspxIs there a question here? Your code looks like it should work, just add an EXEC to run the dynamic sQL you generated.I do have to ask... Why?Tue, 17 Aug 2010 05:49:35 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic970280-146-1.aspxHi,I want to create procedure within proceduresomething like that[code]create procedure aaasbegin if exists (select * from sys.objects where name='bb') begin drop procedure bb go declare @a nvarchar(max) set @a='create procedure bb as begin print ''bb'' end' endend[/code]Thanks in AdvanceTue, 17 Aug 2010 05:47:19 GMTTrouble Shooter