How to run SQL Script from a particular folder using Command Prompt


To run SQL Script stored in a particular folder using Command Prompt:


REM - Run SQL Script to prepare the database environment

 ECHO Preparing Databases...

 SQLCMD -E -i C:\ETL_Solution\SetupFiles\Setup.sql

Comments

Post a Comment

Popular posts from this blog

Calculating Age of the person in T-SQL

One of common calculations, we have to do in ETL is calculating age of the person from the date attribute And this is how I have calculated Age of the person. Select BirthDate , CASE             WHEN Month ( GetDate ()) < Month ( c . [BirthDate] )                 THEN DateDiff ( yy , c . [BirthDate] , GetDate ()) - 1             WHEN Month ( GetDate ()) = Month ( c . [BirthDate] )             AND Day ( GetDate ()) < Day ( c . [BirthDate] )                 THEN DateDiff ( yy , c . [BirthDate] , GetDate ()) - 1             ELSE DateDiff ( yy , c . [BirthDate] , GetDate ())  ...
Read more

Removing and Manipulating Time portion from DateTime in SQLServer

Image
One of the common transformation we would have to do as part of ETL would be manipulating Time portion. Please see some of below code, which would help to resolve some of the time related transformation Case1 - Getting only Date portion from DateTime /* Removing Time portion from DateTime */   Select -- Standard date with time   getdate () As DateWithTime , -- Returns Date Portion Only   dateadd ( d , 0 , datediff ( d , 0 , getdate ())) As DateOnly Result as below: Case2 -  /* Removing Seconds from DataTime */ /* Removing Seconds from DataTime */ declare @t datetime set @T = GETDATE () SELECT @T as Original , DATEadd ( ss ,- datepart ( ss , @t ), @t ) as wihtout_sec -- if no milisecs , DATEADD ( mi , DateDiff ( mi , 0 , @t ), 0 ) as OneMore_Variation Case3 - We want to Keep Hours but remove Minutes and Seconds from DateTime /* Keep Hou...
Read more

Sharepoint Integrated Mode License

Does SSRS 2012 Sharepoint Integrated Mode install requires a SQL Server license?   These are the General Licensing Terms for Server Product installs. Item 1 states that you must assign the license to a single server. So if the SSRS component was installed on a separate server to the database engine then it will also need a SQL Server license.   Server Licenses You have the rights below for each server you properly license. ·       You must assign each license to a single Server. ·       One license is required for every two Physical Processors on the Server. ·       For Standard licenses, you may use one Running Instance of server software in the Physical OSE and, for each license assigned, one Running Instance in up to two Virtual OSEs on the Licensed Server. ·       For Standard licenses, if all permitted Virtual OSE Instances are used, you may use the Instanc...
Read more