Ashwani .Net

Dear Readers, In this Article i am going to introduce "What is the difference between TABLE SCAN , INDEX SCAN and INDEX SEEK". Table Scan:  These all are related to Optimization technique in SQL Server. When we are fetching data from table, By default we are scanning whole table to get our particular data. This is called Table Scan. Ex : Select * From Employee  Index Scan :   Now we are creating index For Employee Table on there id . Ex :  CREATE INDEX index_employee_id ON Employee(id); Now we will run same Query "Select * from Employee", In this case we will scan only Index. So it is called Index Scan. Index Seek : In this case after creating Index we are executing "Select * from employee where id=1". Means we are fetching data with Id. As we are created index on Employee table by there id . So it is called Index Seek.

Hi Techies,            Today i am going to provide you a solutions for copy data from database and save that data in csv or any type of format in same or another location.  So, For this type of work i used to BCP ( Bulk copy process ) using " xp_cmdshell " command in sql server.  For this process we need Admin rights on SQL Server and  xp_cmdshell access rights.  After taking rights we have to write bellow query in stored procedure.  -------------------------------------------------------------------------------------------------------------- --EXEC ExportTest Create Proc ExportTest AS BEGIN         declare @cmd varchar(1000)     set @cmd ='bcp "SELECT * FROM databasename.[dbo].[tablename]" queryout "C:\\FileTest\test.csv" -c -t ,  -S 10.XXXXXXXX -U username-P Password-T'    exec xp_cmdshell @cmd END -----------------------------------------------...

# Angular Step By Step  Hello Techies,        In this post i am going to guide you to install Angular and create and run your first app. Please follow bellow steps.. Step 1 (Node NPM Installation) Node Js ( NPM)  should be installed on system. So for installation of Node Js follow bellow steps. Open  https://nodejs.org/en  .  Download stable Version (LTS) of Node js. After complete the installation open CMD and check the version. Step : 2 (Install Angular by NPM) Type " npm install -g @angular/cli "  2.  Select folder where you are going to create Angular Project.  3. Type ng new 'your app-name' EX:  ng new my-dream-app And Relax it will take some couple of minute to create app , because its downloading all the package from server by npm in you local system. Type : " cd my-dream-app " to select project which is created.  Now Type " ng serve " to run the project...