Answer Posted / foram

select month(getdate())
select month(dateparametername) from tablename
---here u will get number of month
or

select datename(month,getdate())
select datename(month,dateparametername) from tablename
to get name of month

What is a collation in ms sql server?

1132

---

How do we synchronize On-Premise SQL server with SQL Azure?

124

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1662

---

What are the encryption mechanisms in sql server?

1077

---

What are window functions in sql server?

1065

---

What is the difference between a view and a stored procedure?

1087

---

What are the database objects? : SQL Server Architecture

1094

---

How to insert stored procedure result into temporary table?

1062

---

What is use of except clause? How it differs from not in clause?

1061

---

What is the primary use of the model database?

1128

---

What is the difference between upgrade and migration in sql server?

1145

---

Explain about integration services of Microsoft SQL server?

1082

---

How to use copy and concatenate commands in SQL?

1192

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

995

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1087

---