Home > DeveloperSection > Category

Latest blog on category "Database"

Temporary Tables Magic Table and Injection in SQL

Tempopary tables are created at runtimes and ability to perform all the operation like the normal table. These tables have limited scope. This table is stored in tempdb.

By Allen Scott posted   2 months ago

User Define function in Sql Server

User Defined Functions play a major role in SQL. User Defined functions can be used to perform a complicated logic, can accept parameters and return data. Many a times we have to write complex logic which cannot be written using a single query. In such case, UDFs role is important. For example, we can call user defined function in a where clause or use a user defined function in a JOIN.

By Elena Glibart posted   4 months ago

Create database mail profile in sql server step by step.

In this article I would discuss about the Database Mail which is used to send the Email using SQL Server.


Create sql server agent job to run stored procedure

This Article describes how to create a Microsoft SQL Server Agent job step that executes Store procedure in SQL Server by using SQL Server Management Studio.


SQL View

In this blog describe the concept of sql view in sql server. SQL view is a virtual table. Here we give simple example of view.


CURSOR in SQL Server

In this blog describe the concept of cursor in sql server and how to create cursor in sql server, types of cursor. Here, I’m trying to demonstrate the good examples of cursors.


Creating, Inserting, Updating and Deleting in SQLite

In this blog, I’m explaining how to create and use the sqlite database in our application.


Locks in SQL Server

In this article, I’m explaining the locks in sql server and its types.


Checkpoint in SQL Server

In this blog, I’m explaining the checkpoint in sql server.


Views in SQL Server

In this blog, I’m trying to explain the views in sql server and how to create it.


User Defined Function in SQL Server

In this blog, I’m explaining user defined functions in sql server.


Transaction in SQL Server

In this blog, I’m trying to explain the transaction in sql server.


Rules in SQL Server

In this blog, I’m explaining the rules in sql server and how to create it.


Default Constraint in SQL Server

In this blog, I’m explaining the default constraint in sql server and how to create it.


Stored Procedure in SQL Server

In this blog, I’m trying to explain the stored procedure in sql server.


Keys in SQL

In this blog, I’m explaining the keys in sql and how to create it.


Create Table Statement in SQL

In this blog, I’m trying to explain the create table statement in sql.


Difference between GRANT and WITH GRANT in SQL Server 2008 R2

This blog provides an overview of the difference between GRANT and WITH GRANT using SQL Server 2008 R2.

By Vijay Shukla posted   3 years ago

Difference between char, varchar and nvarchar in sql server

char, varchar and nvarchar are SQL Server data type that used for allocated memory in storage device.


Views and Materialized Views in Oracle

It might be great confusion to the novice regarding views and Materialized views in SQL.

By Shankar M posted   3 years ago

Simple popup panel in HTML

In this blog, I have described how to create a simple popup window or display page as popup window. There are simple CSS file and JavaScript that used for open model popup. Steps are given below.


Trim method in SQL Server

SQL server does not have Trim method, but for trimming blank spaces (leading and trailing) from string we have used LTRIM and RTRIM method in SQL Server.


Count table size in SQL Server

This blog have to described, how to retrieve table size.


New features in SQL Server 2012

Microsoft recently lunched SQL Server 2012. We are known, SQL Server 2012 is enhancing of SQL Server 2008, but we not aware, what are new features Microsoft include in SQL Server 2012.


Changed Data Type of column in SQL Server

In this blog I have described how to changed data type of existing column of table. For demonstration I have used a table that given below.


Don't want to miss updates? Please click the below button!

Follow MindStick