NOEXEC Command of SQL Server

Rakesh Kalluri

11y1.7kCode

In this code we will get to know how to use NOEXEC command.

--Create Student
if object_id('Student') is null
create table Student(id int identity(1,1) ,Name varchar(20),Marks int)

--Insert Some Sample Data to Source_Student
insert Student (Name,Marks) values('Rakesh',500)
insert Student (Name,Marks) values('Raju',400)

set noexec on
select * from Student
set noexec off