It might be already known to you but I thought for sharing because I frequently use this command and it is very useful command. When someone wants to determine detail of a function or stored procedure he/she can use this useful command. The syntax is very simple. Just write sp_helptext Storedprocedure/ functionname For example …
There are various functions available in SQL Server and it is good to know all of them you never know when they will be helpful to you. So lets start one by one. 1) LEN :- By the name it is clear that LEN function give length of the parameter For example :- DECLARE …
Problem:- Most of the time we require data in which we require first value and last value from different group of rows. Now how easy we can get result this is one of the challenge for us. Solution:- Lets understand this by an example. Suppose you have a sales table in which you maintain …