Menu

▼
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Wednesday, April 19, 2023

How do you optimize database queries in a .NET Core Web API?

›
Optimizing database queries in a .NET Core Web API is an important task to improve the performance of the application. Here are some best pr...
Thursday, March 23, 2023

Different ways to write a method that reads list of entities from SQL Server in C# language

›
There are different ways we can do same work. With evolution of .net technologies we have found different technologies to perform data opera...
Friday, December 10, 2021

How to split a comma separated string into multiple records using T-SQL function?

›
 Let's say you have a comma separated string like:  split,a,comma,separated,string   Now you need to convert the string to follow rows: ...
Thursday, September 2, 2021

SQL update from one Table to another based on a ID match

›
SQL update from one Table to another based on a ID match While working with SQL database you might often require to update one table data ba...
Monday, April 19, 2021

What is SQL? Explain DQL, DML, DDL, DCL and TCL statements with examples.

›
Learn about SQL and categories of SQL commands like DQL, DML, DDL, DCL and TCL statements with specific command examples.   SQL:   SQL stand...
1 comment:
Wednesday, April 7, 2021

What is the difference between primary key and unique key in SQL Server?

›
How to answer DBMS interview question about the difference between primary key and unique key This is very commonly asked interview questi...
2 comments: