kaveer's blog

In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. Sample table Sample Data Create View Update View Drop View Please donate and support at https://www.paypal.me/Rajcoomar

Indexes are used in SQL server to quickly retrieve the information Type of Indexes In SQL Server indexes are one of the following two types: Clustered Index  Non-Clustered Index.  Clustered Index A clustered index is the index that will arrange the rows physically in the memory in sorted order. An advantage of a clustered index is that searching for a range of values will be fast. Non-clustered Index  A non-clustered index is an index that will not arrange the rows physically in the memory in sorted order.  An advantage of a non-clustered index is searching for the values that are in a range will be fast. You can create a maximum of 999 non-clustered indexes on a table Sample Table Create index Drop index Please donate and support at https://www.paypal.me/Rajcoomar

This SQL Server tutorial explains how to use the ALTER TABLE statement in SQL Server (Transact-SQL) to add a column, modify a column, drop a column, rename a column or rename a table with examples. Sample Table  Alter table add a column Alter table add multiple columns Amend Column Drop Column Please donate and support at https://www.paypal.me/Rajcoomar

The CREATE TABLE statement is used to create a new table in a database. The following constraint can be applied when creating a table: NOT NULL  - Ensures that a column cannot have a NULL value UNIQUE  - Ensures that all values in a column are different PRIMARY KEY  - A combination of a NOT NULL and UNIQUE. Uniquely identifies each row in a table FOREIGN KEY  - Uniquely identifies a row/record in another table CHECK  - Ensures that all values in a column satisfy a specific condition DEFAULT  - Sets a default value for a column when no value is specified INDEX  - Used to create and retrieve data from the database very quickly Using script Create temporary table Using GUI In SQL server management studio expand the database created and right click on "TABLES" from the context menu select NEW > TABLE Create your table and right click on the column that you want to make it as a primary key constraint and from the co...

Definition The CREATE DATABASE statement is used to create a new SQL database. Using Script Using GUI Open Microsoft SQL Management Studio  Connect to the database engine using database administrator credentials  Expand the server node  Right-click Databases and select New Database  Enter a database name and click OK to create the database Please donate and support at https://www.paypal.me/Rajcoomar

Implement Login/Sign up and authentication process to demonstrate my skills and understanding using technologies like ASP.NET C#, WebApi, Java and SQL server Tools Microsoft Visual Studio 2017 or latest Android Studio SQL server 2017 No-IP desktop application Additional Information and plugin To register For NO-IP service  Here For the tutorial on NO-IP and forwarding rule, click  Here To download and install UNITY.WEBAPI for repository pattern and dependency injection in ASP.NET WebApi click  Here Creating projects, solution and database Android studio Step 1 Step 2 Step 3 Visual Studio 2017 Step 1: Create a new project Step 2: Install Unity.WebAPI Open "Package manager console " and paste the following command SQL server Step 1: Create a database Right click on database folder in SQL server from the context menu select New Database Step 2: Login  Right cl...

Simple application to convert a number into word. This app may be quite handy when you have to fill a check or any other bank documents where you have to enter the amount both in figure and words Splash screen Splash screen will appear for about 3 seconds when the application is starting up public class SplashScreen extends AppCompatActivity { private final int SPLASH_DISPLAY_LENGTH = 3000 ; @ Override protected void onCreate ( Bundle savedInstanceState ) { super . onCreate ( savedInstanceState ) ; getWindow ( ) . setFlags ( WindowManager . LayoutParams . FLAG_FULLSCREEN , WindowManager . LayoutParams . FLAG_FULLSCREEN ) ; requestWindowFeature ( Window . FEATURE_NO_TITLE ) ; //2 lines of code make app fullscreen setContentView ( R . layout . activity_splash_screen ) ; new Handler ( ) . postDelayed ( new Runnable ( ) { @ Override public void run ( ) { ...

This is a simple Android application created with the intention to make user save money at the end of the month or while doing shopping. This application will compare the prices of a particular product at different stores and output the result. With this version 1.0, the user will have to feed the application with the store that they want to compare and prices of products but version 2.0 the user will only have to select their favorite stores and the application will automatically retrieve the product with the price using internet connection. MainActivity The main activity consists of the list previously added by the user. The user can perform actions like view the list, which will show the stores selected for that particular list and their products. If you want to delete the list long press on the list name and then in the pop-up menu select Delete. Simple and elegant drawer. To add a new list select Add List in the drawer menu or you can click on the float a...

Google reCAPTCHA implementation ASP.NET C# Steps to implement Google reCAPTCHA in your website using technologies such as ASP.NET C#, ASP.NET web API, HTML and javascript. First you need to use your google account to login to Google reCAPTCHA  to register a new site. Add a label of your choice in the label section and for web implementation select the reCAPTCHA V2 radio button. Next in the domain section you can add several domains, for testing purposes you can add localhost also followed by another domain in the next line. Accept the terms and conditions and click on the button register. After you click register, google will generate a site key and a secret key and  instructions how to integrate it on both client and server side. Create ASP.NET Web API Next step is to open Microsoft Visual Studio and create a new project by selecting File > New from the menu bar and then select Project.  Select ASP.NET Web Application(.NET Framework) in the p...