SQL Server Project, Realtime Scenario | SQL Server Interview Questions & Answers

SQL Server Project - You'll learn how to communicate with relational databases using Query language in SQL Server Project & Realtime Scenario. Practice with projects as well, learning how to modify data and create queries that connect with several tables.

SQL server function | SQL server queries

For SQL Quiz-

Find Us On FaceBook-

For Query check the comment box of the video.

[ssunitech]

CREATE FUNCTION FN_GETCOMPLETEDATE
(
)
RETURNS @DATES TABLE (STARTDATE DATE, ENDDATE DATE)
AS
BEGIN

DECLARE @ENDDTTMP DATE

IF @DATETYPE=2---MONTHLY
Begin
Begin
Insert Into @DATES (STARTDATE, ENDDATE)

End
END
IF @DATETYPE=1--Weekly
Begin

Begin


Insert Into @DATES


End

End

IF @DATETYPE=0 --- Daily
Begin
Begin
Insert @DATES
End
End

Return
End


Select * From FN_GETCOMPLETEDATE('2021-08-01', '2021-11-16', 2)

[amritasingh]

Keep uploading videos like this.
Thanks for your videos.