functions in sqlserver ?

Question

Hi These days while facing interviews facing some typical scenarios to get required output .. What i need is just in order to implement what i think actually there are functions already available in sqlserver like STUFFOVERCOLESELE like this many I request can anyone give me You tube videos link on this functions like above can help it . If no videos links atleast givvme a best resource to know such stuff in simple manner My best Regards

Biswa Pujarini Mohapatra · Answer

Coalesce : http://www.codeproject.com/Tips/605339/Using-Coalesce-in-sqlserver http://www.codeproject.com/Articles/713126/SQL-Server-What-Exactly-is-COALESCE-Function SQL SERVER Ranking Functions - RANK DENSE_RANK NTILE ROW_NUMBER http://www.besttechtools.com/SQLArticles.aspx?ID=Rank all the in-built functions http://www.queryingsql.com/p/functions-in-sql-server.html?spref=bl#.Ut4sto26atU

Biswa Pujarini Mohapatra · Answer

use this threads http://www.w3schools.com/sql/sql_isnull.asp http://www.w3schools.com/sql/sql_functions.asp http://technet.microsoft.com/en-us/library/ms174318.aspx

SUNIL GUTTA · Answer

Yes the msdn link is much helpful :) Ty for that but i need only some most used functions like mentioned above in a single article or a video tutorial :) For Further help Thank you .