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
Create User Login in SQL Server 2008 R2
Create user with the query CREATE LOGIN [Login_Name] WITH PASSWORD='password' MUST_CHANGED, DEFAULT_DATABASE=[
Retrieve SQL Server Installation Date Time
Question: How do I retrieve SQL Server Installation date? Answer: Run the following query and it will give you the date of SQL Server Installation.
Insert Multiple Rows into Single Table
Here we describe how to insert records into table in multiple ways. Currently when developers have to insert any value into the table they have to write multiple insert statements.
Distinct Data in SQL Server
How do I display only unique records from my table? For demonstration first we create a table--USE DATABASE USE AVI --CREATE TABLE CREATE TABLE Pr
SQL Keys
A key is a single or combination of multiple fields in a table. It is used to fetch or retrieve records/data-rows from data table according to the condition/requirement.