Mssql Server
15 results found
Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF.
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.
What is best way to convert datetime to date in Sql Server?
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.
Calculating distance between two positions(lat, long) in SQL Server
How to calculate distance between two positions in SQL Server base on latitude and longitude in the map?
How to backup and restore MSSQL Server database in Ubuntu
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.
Correct order execute of clauses in SELECT SQL statement?
Which is the correct order of execution for statements in a SELECT query?
What are the Constraints in SQL Server?
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?
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?
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 stored procedure Sql server?
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 difference between Union and Union All in MS SQL?
What is the difference between Union and Union All in MS SQL Server? When we need consider to use them?
What is difference between Clustered and Non-clustered in SQL Server?
What is the difference between Clustered and Non-clustered index in SQL Server?
What is the difference between IN and EXISTS 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 difference between WHERE and HAVING in SQL Server?
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.
Top SQL Server interview questions and answers for developer
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 by update in mssql server
Error string or binary data would be truncated. the statement has been terminated when update the query.