15 results found
MSSQL Server throw: Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF. When I trying to insert data to table.
How can I convert DateTime to Date data type in SQL Server? I tried to use Cast() method but it was not formatted correctly for me.
How to calculate distance between two positions in SQL Server base on latitude and longitude in the map?
How to backup and restore the Microsft SQL Server database in Linux Ubuntu 18.0.4? I don't want to open publish port because hacker maybe attacks my server.
Which is the correct order of execution for statements in a SELECT query?
I'm a beginner in SQL server. I know the concept of constraint in SQL but I don't know what are the Constraints in SQL Server?
What is the difference between VIEW and TABLE in SQL Server? Please explain to me if you know the difference between them.
What is the difference between TRUNCATE and DELETE in SQL Server? Please explain to me if you know them
What are the pros and cons of the stored procedure SQL server? Please explain to me why I should use it in my code.
What is the difference between Union and Union All in MS SQL Server? When we need consider to use them?
What is the difference between Clustered and Non-clustered index in SQL Server?
What is the difference between IN and EXISTS clause in SQL Server? Which case we should use them? and What is the performance of them?
What is the difference between WHERE and HAVING clauses in SQL Server? They all use to filter data but I don't know when we use it.
In this article, I collect top some essential SQL serverinterview questions and answers for developers. it's content questions for all levels from junior to senior. MSSQL Server is an RDBMS so many popular in the world, SQL Server is a product of Microsoft so when ifyou arefamiliar with .Net almost you will use SQL Server to store data.
After many years working with .Net and MS SQL server, I collect some Ms Sql interview questions and answers with the hope that it'll help you have a general view about SQL Server and get more confident when you prepare for an interview.
Error string or binary data would be truncated. the statement has been terminated when update the query.