Date Formate in Sql

Show Current Date-   Show Current Date Then Use-     SELECT GETDATE()  AS CurrentDate OutPut-            2016-06-08 12:11:00.083  More Format In Date Then Use-   Ex. 1:  SELECT CONVERT(varchar(20),GETDATE(),100)  AS CurrentDate OutPut-           ...

Read More

Except vs NotNull in Sql Server

EXCEPT & INTERSECT command in SQL Server EXCEPT In this Article EXCEPT command use to commind two queries and find dinctinct records. EXCEPT returns any left query values which are not exist in right query. You can use Except command and easily find distinct value of one table when you want filter...

Read More

Sql Commands

Sql Select Query SQL Select all data from Table as you can see in my previous Article http://learningmvctutorial.blogspot.in/2017/03/sql-select.html Insert Query In SQL Server you can use Insert data in table help of Insert Query Syntax INSERT INTO TableName(ColumnName1,ColumnName2,ColumnName3) VALUES(@value1,@value2,@value3) ...

Read More

INSERT INTO statement in SQL

INSERT INTO SELECT Statement In this article describe about Insert data one table to existing table The INSERT INTO SELECT statement selects data from one table and inserts it into an existing table. Example In this article...

Read More

Sql Like Operator

The SQL LIKE Operator In this Article describe Like Operator. The SQL LIKE clause is used to compare a value to similar values using wildcard operators. The LIKE operator is used to search for a specified pattern 'start letter...

Read More

Html Formatting

Text Editing You can edit text easly in html using many predefine tags. HTML also defines special elements and tags for defining text with a special meaning. Using those type of Formatting elements like-  <b> - Use this element to bold text <strong> - This is also same bold tag but give Important text <i> - Use...

Read More

SQL Group By Clause

What is Group By clause ? In this Article Group by clause use in Select query in Sql Server when you fetch data with collection on basis particular unique field then use Group by Clause. Group by clause with where condition and...

Read More

IDENTITY_INSERT is set to OFF/ ON using SQL SERVER

In this Article introduce about IDENTITY_INSERT ON/OFF in SQL Server Discuss in detail with example see bleow discription in this Article What is IDENTITY_INSERT IDENTITY_INSERT When you create table in database then one field...

Read More

HTML Basic Important Points

HTML Basic Document In this Article Define Html Basics tag then you find easily that where we use. In this Define basics tag in follow example Example <html/> <head/> <title/>Demo Title</title> </head/> <body/> Demo you can write code </body> </html> Text Elements In This Article...

Read More

CSS Selectors

In this artical we define differntes types of selector see as above- What is Selector? Selector-CSS type selectors match elements by node name. Selector for a particular node name selects all elements of that type — that is, with that node name — in the document. andwe can define a selector is element which on we apply css propeties. ...

Read More

Types of CSS

In this Tutorial Describe Types of CSS Basically we define 3 types of CSS see above- Inline CSS Internal (embedded) CSS External CSS Inline CSS - In This CSS we add inline style. Inline styles are styles that are written directly in the tag like div,textbox button etc. Inline styles affect only the tag they are applied to and not effect other...

Read More

Ordered and Unordered list in Html

Types of list in html We define any defination and content in list form then we give order and unorder. Basically 3 types of list use in- Unorder list Order list Defination list Unordered list An unordered The list items are marked with bullets (typically small black circles). An unordered list is a list of items. This list...

Read More

Fetch Unique random Record in sql server

Fetch Unique random Record in sql server In This Artical You can easily fetch unique and random record And you get each time unique record if you execute this query every time you fetch unique and random record using Newid() function....

Read More

Operator in JavaScript

What is an operator? JavaScript has both binary and unary operators, and one special ternary operator, the conditional operator. A binary operator requires two operands, one before the operator and one after the operator: operand1 operator operand2 For example, 3+4 or x*y. A unary operator requires a single operand, either before or...

Read More

Conditional Statements in JavaScript

Conditional Statements In This Tutorial You want to perform different actions for different situvation. In JavaScript we have the following conditional statements: if statement . if-else statement . if...else if....else statement. switch statement. if statement - If statement if you want to execute some code only if a specified ...

Read More