Create Table Statement in SQL
In this blog, I’m trying to explain the create table statement in sql. You need tables in database to store data. Create Table statement is used to c
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.GRANT and WITH GRANT: The difference between
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. But there is little difference between them which described below:
Views and Materialized Views in Oracle
Views and Materialized Views in OracleIt might be great confusion to the novice regarding views and Materialized views in SQL. Indeed, they are define
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. Below line of code return all table’s size which associated with current database. Steps are given below
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. CREATE T
Difference between Store Procedure and UDF User Define Function
In this blog I am trying to differentiates between Store Procedure and UDF User Define Function:Store Procedure:1.Stored procedure may or not return v
Drop Column in SQL Server
In this blog, I have described how to drop the column from existing table. For demonstration, I have used a table that given below. CREATE TABLE [dbo
Add New Column in Table in SQL Server
In this blog I have described how to add new column in existing table. For demonstration I have used a table that given below.CREATE TABLE [dbo].[EmpI