Category: MS SQL Management Studio
-
SQL SERVER – ENABLE QUERIES THAT REQUIRE TABLE RECREATION
At Sql Server Management studio sometime We run queries that changes tableĀ propertiesĀ or structure. At this point We get an error message that says something like: “Please drop and recreate table…”. The solution for it is here:
-
MS SQL Server Editions
Ā MS SQL Server Editions Also include Express editions http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
-
Step by step of executing SSIS 2012 package through stored procedure
Step by step of executing SSIS 2012 package through stored procedure http://blogs.msdn.com/b/biblog/archive/2013/05/07/step-by-step-of-executing-ssis-2012-package-through-stored-procedure.aspx
-
Multiplication Table – Stored Procedure
ALTERĀ PROCEDUREĀ [dbo].[Mulsp]Ā @SizeĀ INT AS BEGIN DECLAREĀ @XĀ INT=2 DECLAREĀ @YĀ INT=1 BEGINĀ try DROPĀ TABLEĀ [dbo].[multable] ENDĀ try BEGINĀ catch ENDĀ catch CREATEĀ TABLEĀ [dbo].[multable] ( c1Ā INT ) –createĀ theĀ rowsĀ DECLAREĀ @CNĀ NVARCHAR(max)=” DECLAREĀ @TSqlĀ NVARCHAR(max) WHILEĀ @xĀ <=Ā @Size BEGIN SELECTĀ @cnĀ =Ā ‘c’Ā +Ā Cast(@xĀ ASĀ NVARCHAR) PRINTĀ @cn SETĀ @TSql=‘alterĀ tableĀ MulTableĀ addĀ ‘Ā +Ā @cnĀ +Ā ‘Ā int’ PRINTĀ @Tsql EXECĀ sys.Sp_sqlexec @Tsql SETĀ @x=@xĀ +Ā 1 END –atĀ thisĀ pointĀ buildĀ eachĀ lineĀ queryĀ SETĀ @X=1 DECLAREĀ @EachLineQueryĀ NVARCHAR(max) WHILEĀ @YĀ <=Ā @Size BEGIN SETĀ @EachLineQuery=‘insertĀ intoĀ MulTableĀ valuesĀ (‘ WHILEĀ @xĀ <Ā @Size BEGIN SETĀ @EachLineQuery=@EachLineQueryĀ +Ā Cast(@x*@yĀ ASĀ NVARCHAR) +Ā ‘,’ SETĀ @x=@xĀ +Ā 1 END SETĀ @EachLineQuery=@EachLineQueryĀ +Ā Cast(@x*@yĀ ASĀ NVARCHAR) +Ā ‘)’ EXECĀ sys.Sp_sqlexec @EachLineQuery PRINTĀ @EachLineQuery SETĀ @EachLineQuery=” SETĀ @y=@yĀ +Ā 1 SETĀ @x=1 END SELECTĀ * FROMĀ Ā Ā multable END