Technology from Developers Eye

Shadow or Ghost in DB SQL

create database ShadowDB GO Use ShadowDB create table DemoTable(id int,name char(100)) create clustered index IDx_DemoTable on De...

Shadow or Ghost in DB SQL

Reviewed by Rupesh on 06:28 Rating: 5

SQL

Function returning Tables in SQL

Rupesh

Create Table DeptmentMaster ( DID int PRIMARY KEY identity(1,1), Dname varchar(25), Lname varchar(25) ) GO Create Table EmMa...

Function returning Tables in SQL

Reviewed by Rupesh on 05:54 Rating: 5

SQL

Query Execution Plan in SQL

Rupesh

set showplan_xml off set statistics profile off select * from sys.messages where message_id=3902 select * from sys.dm_exec_ca...

Query Execution Plan in SQL

Reviewed by Rupesh on 05:04 Rating: 5

SQL

Error & Exception in SQL

Rupesh

use demostart if object_id('ValidateProc') is not null drop proc ValidateProc go create procedure ValidateProc as sele...

Error & Exception in SQL

Reviewed by Rupesh on 04:48 Rating: 5

SQL

Event Notification in SQL

Rupesh

--Check if the database is enabled for Service Broker --If not then enable it IF EXISTS (SELECT * FROM sys.databases WHERE name = ...

Event Notification in SQL

Reviewed by Rupesh on 04:35 Rating: 5

SQL

Snapshot for Database SQL

Rupesh

use demostart go exec sp_helpfile --creating snapshot database create database demostart_Snapshot on(name=demostart_Data,filen...

Snapshot for Database SQL

Reviewed by Rupesh on 04:27 Rating: 5

SQL

CTE in SQL

Rupesh

USE demostart GO IF OBJECT_ID('Employees', 'U') IS NOT NULL DROP TABLE dbo.Employees GO CREATE TABLE dbo.Empl...

CTE in SQL

Reviewed by Rupesh on 04:20 Rating: 5

SQL

CROSS DB OWNERSHIP CHAINING

Rupesh

--Enabling cross database ownership chaining at server level sp_configure 'cross db ownership chaining',1 GO reconfigure G...

CROSS DB OWNERSHIP CHAINING

Reviewed by Rupesh on 23:17 Rating: 5

SQL

Contained database in SQL

Rupesh

A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the databas...

Contained database in SQL

Reviewed by Rupesh on 23:11 Rating: 5

SQL

Check Permissions in SQL

Rupesh

SELECT [UserName] = ulogin.[name], [UserType] = CASE princ.[type] WHEN 'S' THEN 'SQL User...

Check Permissions in SQL

Reviewed by Rupesh on 22:47 Rating: 5

SQL

filegroup in SQL

Rupesh

--Viewing the filegroup to which tables belong to SELECT d.[Name] 'File Group', OBJECT_NAME(i.[Object_ID]) 'Table Name...

filegroup in SQL

Reviewed by Rupesh on 22:43 Rating: 5

SQL

Enabling Change Tracking SQL

Rupesh

USE demostart GO CREATE DATABASE demostart GO USE demostart GO CREATE TABLE EmployeeMaster ( EmployeeID INT IDENTITY PRIMARY ...

Enabling Change Tracking SQL

Reviewed by Rupesh on 22:27 Rating: 5

SQL

COLUMNSTORE INDEX

Rupesh

CREATE NONCLUSTERED COLUMNSTORE INDEX [ColumnStore__InventoryInfo] ON [dbo].[Test_Person] ([InventoryMasterName] , [StateId],[InventoryAm...

COLUMNSTORE INDEX Reviewed by Rupesh on 22:08 Rating: 5

SQL

Transaction Isolation in SQL

Rupesh

Create database DemoStart GO Use DemoStart GO Create Table TranTable (Id int primary key, Name nchar(20),Address nVarchar(50)) GO d...

Transaction Isolation in SQL Reviewed by Rupesh on 22:01 Rating: 5

SQL

DB For Partitioning SQL

Rupesh

USE Master GO CREATE DATABASE DemoDBForPartitioning ON PRIMARY (NAME='DemoDBForPartitioning_1', FILENAME= 'C:\PartitionD...

DB For Partitioning SQL Reviewed by Rupesh on 21:45 Rating: 5

SQL

Ranking in SQL

Rupesh

use demostart CREATE TABLE StateInfo ( StateId char(10) primary key, StateName varchar(100), CityName varchar(100), CountryName varch...

Ranking in SQL Reviewed by Rupesh on 21:36 Rating: 5

SQL

Encryption in SQL

Rupesh

create database DEMOSTART Go Use DEMOSTART --Encryption through PassPhrase Method create table CreditDetails (CCardId int identity...

Encryption in SQL Reviewed by Rupesh on 21:30 Rating: 5

SQL

Dynamic Backup File in SQL

Rupesh

insert into TableMaster values(1,cast(getdate() as char(10))) select * from TableMaster USE MASTER; DECLARE @FileName NVARCHAR(1024) ...

Dynamic Backup File in SQL Reviewed by Rupesh on 21:11 Rating: 5

SQL

APPLY IN SQL

Rupesh

USE demostart GO IF EXISTS (SELECT * FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[Employee]') AND type IN (N'U')) BEG...

APPLY IN SQL Reviewed by Rupesh on 21:04 Rating: 5

SQL

RollUp ,CUBE Operator

Rupesh

CREATE TABLE InventoryInfo ( SL_No INT IDENTITY PRIMARY KEY, InventoryMasterName char(50), StateId CHAR(10) FOREIGN KEY REFERENCES Sta...

RollUp ,CUBE Operator Reviewed by Rupesh on 20:57 Rating: 5

SQL

Compute and Compute By

Rupesh

CREATE TABLE InventoryInfo ( SL_No INT IDENTITY PRIMARY KEY, InventoryMasterName char(50), StateId CHAR(10) FOREIGN KEY REFERENCES Stat...

Compute and Compute By Reviewed by Rupesh on 20:54 Rating: 5

SQL

SQL Advance

Rupesh

SQL Advance Reviewed by Rupesh on 20:08 Rating: 5

SQL

CURSORS SQL

Rupesh

---CURSORS--- ---Using cursors, we can retreive the first, next, previous,last rows in a resultset as well as the rows at a particular p...

CURSORS SQL Reviewed by Rupesh on 19:45 Rating: 5

SQL

TRANSACTIONS SQL

Rupesh

--TRANSACTIONS--- ---Group of SQL Statements which succeed or fail as a whole. --We can commit the data, rollback the data,set save poi...

TRANSACTIONS SQL Reviewed by Rupesh on 19:39 Rating: 5

SQL

TRIGGERS SQL

Rupesh

---TRIGGERS:-- --They are like stored procedures but with some differences:- ---Stored procedures have to be explicitly called by the u...

TRIGGERS SQL Reviewed by Rupesh on 19:31 Rating: 5

SQL

Output parameters in stored procedures SQL

Rupesh

--Use of output parameters in stored procedures--- --Output parameters are used where we want to pass value from a stored procedure to som...

Output parameters in stored procedures SQL Reviewed by Rupesh on 19:19 Rating: 5

SQL

Stored Procedures SQL

Rupesh

---Stored Procedures--- These are a group of SQL Statements which are executed as a Unit. We can write multiple statements in 1 procedu...

Stored Procedures SQL Reviewed by Rupesh on 19:17 Rating: 5

SQL

VIEWS SQL

Rupesh

---VIEWS-- ---Database objects which are used to represent an SQL Query that can be used to fetch data from a single or multiple tables. ...

VIEWS SQL Reviewed by Rupesh on 19:08 Rating: 5

SQL

JOINS SQL

Rupesh

--JOINS--- ---These are the SQL Queries which help us to retreive data from either single or multiple tables with or without conditions....

JOINS SQL Reviewed by Rupesh on 19:01 Rating: 5

SQL

SUBQUERIES SQL

Rupesh

-These are the SQL Statements which are embedded inside another SQL Statements. Example:- --1)To find the details of the person who earn...

SUBQUERIES SQL Reviewed by Rupesh on 13:09 Rating: 5

SQL

create another table which is a copy existing table

Rupesh

select * into salesunion--(NewTableName) from salesdetails(existing table)

create another table which is a copy existing table Reviewed by Rupesh on 13:05 Rating: 5

SQL

Union operators

Rupesh

--Two union operators:-- --1)Union 2)Union All: --Union:-All the unique values are displayed in the result. --Union All:-The differe...

Union operators Reviewed by Rupesh on 13:02 Rating: 5

SQL

ON DELETE CASCADE CLAUSE

Rupesh

It is used on Foreign keys when we are assigning the Foreign Key on a particular column. ---It automatically deletes the values from t...

ON DELETE CASCADE CLAUSE Reviewed by Rupesh on 12:59 Rating: 5

SQL

To drop the constraints

Rupesh

alter table tblName drop constraint CK__cons__balanc__060EWAE8

To drop the constraints Reviewed by Rupesh on 12:55 Rating: 5

SQL

view the names of constraints defined on a table

Rupesh

sp_helpconstraint Tablename

view the names of constraints defined on a table Reviewed by Rupesh on 12:54 Rating: 5

SQL

CONSTRAINTS on SQL

Rupesh

These are the objects used to validate the data entry in tables columns. -TYPES OF CONSTRAINTS:--- -1)Primary key:-Checks for duplicate...

CONSTRAINTS on SQL Reviewed by Rupesh on 12:52 Rating: 5

Home

Rupesh

Home Reviewed by Rupesh on 12:39 Rating: 5

SQL

IDENTITY COLUMNS

Rupesh

These are those columns which are used for auto-generation of integer values in a particular sequence. example:- we can use identity c...

IDENTITY COLUMNS Reviewed by Rupesh on 12:03 Rating: 5

SQL

Pattern matching with exact number of characters

Rupesh

select * from employee where ename like 'a_i_' --Use _ (underscore operator). ---One _ sign means exactly 1 character.

Pattern matching with exact number of characters Reviewed by Rupesh on 11:56 Rating: 5

SQL

To modify column name

Rupesh

sp_rename 'emp.eno','employeeno' Emp is table name . Eno is coloumn name New name employeeno

To modify column name Reviewed by Rupesh on 11:24 Rating: 5

SQL

To add additional column in a table

Rupesh

alter table emp add address varchar(30),phno varchar(15) sp_help emp

To add additional column in a table Reviewed by Rupesh on 11:20 Rating: 5

SQL

SQL Dev

Rupesh

SQL Dev Reviewed by Rupesh on 11:07 Rating: 5

WCF

RestAPI in WCF

Rupesh

Test

RestAPI in WCF Reviewed by Rupesh on 00:46 Rating: 5

SqlServer

Stored Procedure Unit Testing

Rupesh

1.Testing

Stored Procedure Unit Testing Reviewed by Rupesh on 00:33 Rating: 5

Total Pageviews

Blog Archive

Recent

Popular Posts

Tags

About Me

Blog Archive

Contact Form