Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

functions in sqlserver ?

Home
Forums

functions in sqlserver ?

SUNIL GUTTA

12yAsked Jan 21, 2014, 2:30 AM1.2k

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 STUFF,OVER,COLESELE 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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Biswa Pujarini Mohapatra12y ago
Accepted 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
SUNIL GUTTA12y ago
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 .
Biswa Pujarini Mohapatra12y ago
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