SQL Constraints

SQL Constraints

I want to discuss about SQL Constraints. Column level constraints : limits only column data Table level constraints : limits whole table data Common types of constraints include the following: NOT NULL Constraint: Ensures that a column cannot have NULL value. DEFAULT Constraint: Provides a default value for a column when none is specified. UNIQUE […]

Continue reading


Sql DateTime

Sql DateTime

In this article we discus about SQL DateTime Format. SQL Server provides a number of options you can use to SQL DateTime Format. One of the first considerations is the actual date/time needed. The most common is the current date/time using getdate(). This provides the current date and time according to the server providing the […]

Continue reading


C# search in Data Table

I want to discuss about c# search in Data Table Search DataTable by Column Name: Example:

You can search group of value from datatable using DataView . First create dataview from datatable. And then Filter in dataview by column name and order by. Example:

  Then copy dataview to datatable:

Another way, […]

Continue reading


WordPress Yoast SEO

WordPress Yoast SEO

WordPress Yoast SEO improve your site’s SEO on all needed aspects. Technical optimization for your site. Automatically optimizing and inserting the meta tags and link elements that Google and other search engines like. With the Yoast SEO plugin you can control which pages Google shows in its search results and which pages it doesn’t show. […]

Continue reading


SQL Basic Query

SQL Basic Query

I want to discuss about SQL Basic Query. Microsoft SQL and Oracle PLSQL is import for DB sql query. SQL queries can be written in the box located under the “Execute SQL” tab. Click ‘Run SQL’ to execute the query in the box.

We have capitalized the words SELECT and FROM because they are […]

Continue reading