create a stored procedure,query for display deposit details | SQL interview questions| Sql Query Exercises|
create stored procedure for display deposit details
Table Scripts:
Create Table Customer
(
CustomerId int Primary Key,
FirstName varchar(100),
LastName varchar(100),
Email varchar(100),
DOB date,
Gender varchar(20)
)
insert into Customer values(1,'Arun','kumar','[email protected]','10-26-1996','Male')
insert into Customer values(2,'Sara','James','[email protected]','03-14-1990','Female')
insert into Customer values(3,'Piyoosh','Chowla','[email protected]','06-20-2001','Male')
insert into Customer values(4,'Haris','Usman','[email protected]','05-09-2000','Male')
insert into Customer values(5,'Veena','Vijay','[email protected]','02-17-1998','Female')
create Table Deposit
(
DepositNo Varchar(15),
CustomerId int Foreign key references Customer(CustomerId),
DepositDate datetime,
DepositAmount numeric(18,2)
)
insert into Deposit values('00001',1,'2020-07-20 10:16:02.690',4000)
insert into Deposit values('00002',3,'2020-07-20 15:08:22.340',5000)
insert into Deposit values('00003',2,'2020-07-20 18:33:08.735',4500)
insert into Deposit values('00004',1,'2020-07-22 03:11:37.116',3500)
insert into Deposit values('00005',4,'2020-07-23 21:44:21.439',6000)
Sql Query for jobs
# / @sqlqueryforjobs
# • Write a query to find the stock of ea...
# • Write a Query to find Diffrence of ea...
# • Write a Query to Get Largest Sold Pr...
Playlists:
• SQL Query Interview Questions
• Stored Procedure in sql
• Sql Basics Through Query
• User Defined Functions in sql
• Build in functions in sql
• Views in sql
sql sever interview query questions,
sql server interview questions,
sql server interview questions,
sql server interview questions and answers
#sql #sqlserver #sqlab #sqlinjection #mssql #sqldeveloper #sqlsaturday
#sql #programming #database #sqlserver #coding #developer #programmer #software #datascience #code #computerscience #data #dataanalytics
#technology #computer #development #bigdata #backend #coder #codinglife #microsoft #sqldatabase #softwaredeveloper #informationtechnology #programminglife #softwaredevelopment #programmerslife #sqlforbeginners #sqltraining #sqlinterviewquestions #mssqlserver