Tag Archives: SQL

SQL Server Interview Questions and Answers Day -2

Before going through SQL Server Interview Questions and Answers Day – 2,  I would like to recommend you to go through previous article : SQL Server Interview Questions and Answers Day – 1 What is SQL command? SQL are a … Continue reading

Share Knowledge
Posted in INTERVIEW QUESTIONS, SQL SERVER | Tagged , , | 2 Comments

SQL Server Interview Questions and Answers Day 1

Day 1 – SQL Server Interview Questions and Answers What is SQL? SQL is the internationally recognized standard language for dealing with data in relational database. SQL is a language specifically and solely designed to create, operate on, and manage … Continue reading

Share Knowledge
Posted in INTERVIEW QUESTIONS, SQL SERVER | Tagged , , , , , | 2 Comments

Get Only DateTime Part without using Convert

All of us know many techniques to get DateTime part in SQL using Convert, but here I found something interesting when I was reading an article of BenNadel [ Who he is  ]  which will work without using Convert Take a look or … Continue reading

Share Knowledge
Posted in SQL SERVER, TIPS/TRICKS | Tagged , | Leave a comment

Convert nvarchar, money and smallmoney datatype to int

This article enables you to convert nvarchar, money and smallmoney values to int. Simply, we can use the given conversion syntax to convert Nvarchar, smallmoney and money datatype values to int values. or Illustration as Create a table and insert … Continue reading

Share Knowledge
Posted in SQL SERVER, TIPS/TRICKS | Tagged , | Leave a comment