Software Applications Programming Errors and solutions.

Question: Following are the Differences between count(*) and count(1) in SQL Answer: 1.COUNT(*) will include NULLS but it counts no.of ROWS in a TABLE, AND COUNT(column_or_expression) counts no.of NOT NULL values within a COLUMN. 2.COUNT(*) is depend on full table but COUNT(1) is depend on only one column and both are given same output.

Following at the Differences between collection and bulk binding in SQL To retrieve multiple rows we can use cursors or bulk collections. Cursors row by row mechanism so performance decreased. But collections not row by row process all rows retrieved at time so performance increased. And bulk bind means doing DML(data manipulation language) operations as a bulk. By using for all statement we can do bulk-binding. If you want to do bulk-bind first should use bulk collections .

To Get Name,SID for users for windows  there are many ways to get that . SID full name is Security Identifier. 1. You can execute regedt32.exe  command from run mode. Go to HKey_Users and you can see sid of user like following picture. 2.Second way you can use command on command prompt and run the following command. wmic useraccount where name='username' get sid To get details in file you can use below way. wmic useraccount where name='username' get sid > c:\sid.txt 3. To get All users SID you can use below command. wmic useraccount get name,sid To get details in file user below.. wmic useraccount get name,sid> c:\sid.txt

Sometime out Outlook Data file size become big and it's not getting decrease after deleting of lot of old mails then there is one option to decrease data file size of outlook. You need to use compact option of outlook file. Below are step to do it. 1. Delete items that are old dated and not required. 2. Go to File tab->Account Settings-> Account Settings. 3. Go to Data Files tab, select the data file that for compacting purpose then you can  click Settings     then Click On Compact Now.

Do you know that you can record steps that you are using for your work on windows by using step recorder. You need to just click on Start button then type step recorder in search box then you can open the step recorder. Then click on start to start your task recording when you want to stop your step recorder just click on stop. Then save as dialog box will be open you can save your file on selected location and file will be save in zip format. Once file saved you can open that file in Internet explorer browser. Its windows secret that I know most people do not know but it is very much helpful to make document for your task for future learning. File will be save in MHT format which is MHTML format.