Write some T-SQL script

This is a small project for testing and leading to long term project.

You need to provide working script in T-SQL that demonstrates each of these questions.

Suggested criteria for your answers:

• Use an OOP approach with all programming code encapsulated within methods.

• Avoid using "[login to view URL]", "Alert", "out" or any other direct-to-screen methods.

• Ensure all code is production-ready/release-quality. In other words, use the same standards, conventions, and quality that you deem acceptable to be used if you were working on the job.

• Keep your code as efficient as possible as you will be evaluated on this.

1) Write a function that reverses the order of words in a sentence.

2) Write a function that counts the number of primes in the range [1-N].

(A natural number is called a prime, a prime number or just prime if it has exactly two distinct divisors. Therefore, 1 is not prime number, since it has only one divisor, namely 1.)

3) Write a function f(a, b) which takes two character string arguments and returns a string containing only the characters found in both strings.

.NET ASP.NET C# Programming SQL Website Design

Project ID: #10090668

About the project