Software Applications Programming Errors and solutions.

This is sample of query for  SQL insert query validation constraints to limit number of records lets you want to insert only 1000 records in table . We can restrict number of rows, but need to add a column on which we can add some constraint ... check below example.! CREATE TABLE TAB_1000_ROWS AS SELECT ROWNUM COL1 FROM DUAL CONNECT BY ROWNUM <1001; ALTER TABLE TAB_1000_ROWS ADD CONSTRAINT CHECK_CONST CHECK (COL1 BETWEEN 1 AND 1000); ALTER TABLE TAB_1000_ROWS MODIFY COL1 NUMBER NOT NULL; ALTER TABLE TAB_1000_ROWS ADD CONSTRAINT UNIQUE_COL1 UNIQUE (COL1); -- or we can also use sequence with max as 100 and no-cycle! after insertion of 100 values it wont allow any new values to get inserted! will throw check or unique constraint! 

Azure characteristics Cloud Virtualized Pay per use Scalable (Elastic) Self Service Provisioning.(Automation) Azure service type- SOFTWARE AS A SERVICE(Saas) Platform-as-a-Service (PaaS)  INFRASTRUCTURE AS A SERVICE(IAAS) Azure management tools Azure portal Windows power shell Azure automation Azure CLI visual Studio Subscription ->Service Admin & Co-Admin & Role base access

How to fix the bootmgr Windows Boot Manager error "0xc000000e Windows Failed to Start: The boot selection failed because a required device is inaccessible". Without a Windows setup DVD or if the Windows setup DVD fails to repair the problem.You can get idea from below steps to resolve or fix this error.

ACKNOWLEDGEMENT It is our pleasure to present this project report on Abc First of all, let us thank Mr. TDN, the principal of XYZ Institute , for his  kind consideration. I express my deep gratitude and sincere thanks to the Head of the Department of Computer Technology of XYZ Institute ,Prof. TTT for his encouragement and support throughout the project.  I express my profound  gratitude to our project guide Mrs. yyy for her support given to us. We would like to give our sincere thanks to our ABC Technology staff of XTZ who lead us to satisfactory and timely completion of the project with their great technical support. We hope our work would be taken as a step towards the improvement of the present  condition.

Interview Cracking Steps 1) Resume : Mention all the skills and achievements. Be true to yourself and do not exaggerate. Develop good command on all the topics which you have mentioned in the resume.  Review your resume thoroughly and make sure it is error free and properly formatted. 2) List down the topics which you are strong at. Leverage this point to highlight your skills during your interview. Show your contributions as a team member which help to perform tasks easier. 3) List down the topics which you are weak at 4) Make a note of your recent achievements like issues, new implementations, automation, standardization and documenting. Make sure you have some stories to tell. This will help in giving a good idea about your skills and the interview would be held in these areas mostly. Interview: Common questions 1) Tell me about yourself- Make sure you are well prepared for this. This gives and idea about yourself as well as you communication skills. 2) Tell me the

Question -Employee_Details EmpID NVARCHAR(10) Emp_FirstName NVARCHAR(100) Emp_LastName NVARCHAR(100) DateOfJoining Datetime Employee_Salary EmpID NVARCHAR(10) Refers to Employee Details PayPeriodId INT Refers to Master_PayPeriod SalaryAmount Money DateofSalaryCreditedtoAccount Datetime Master_PayPeriod PayPeriodID INT PayMonthYear Datetime Employee Details Sample Data 000001 ABC XYZ 01-Jan-2000 000002 Rahul Y 13-Dec-2000 000003 Amit S 12-Apr-2000 000004 Shobit K 01-Jan-2000 000005 Harshit J 13-Dec-20

This is sample of queries to check in MS SQL 2012 How to Fix Error "ERROR 9002 LOG FILE IS FULL" You can check following way.