Developer Publish

SQL Server 101 – Get the identity of inserted row

May 24, 2020 no comments

If you are looking at a way to find the identity of the inserted row in SQL Server , you can use the SCOPE_IDENTITY(). How to get the identity of the inserted row in SQL Server ? SCOPE_IDENTITY, IDEN...

SQL Server 101 – Search tables for a specific column name

May 23, 2020 no comments

You might want to search all the tables in your database for a specific column name in order to rename or perform some cleanup. How to search tables for a specific column name in SQL Server ? SELECT ...

SQL Server 101 – Get the size of all tables in database

May 23, 2020 no comments

You might have a scenario where you want to find out how much space that each of the tables in your database is taking so that you can take action on it. There are various ways which one could use to...

SQL Server 101 – Get the Date part from DateTime

May 10, 2020 no comments

You can use the convert function in SQL Server to retrieve only the date part from the date time. How to get the Date part from DateTime variable in SQL Server ? Here’s a sample code snippet de...

SQL Server 101 – Return the Current DateTime

May 10, 2020 no comments

If you want to return the current date time in SQL Server , the easiest way to do it is using the GETDATE() function. How to return the Current DateTime in SQL Server ? The GETDATE() function returns...

SQL Server 101 – Check if a column exists in a table

May 10, 2020 no comments

If you need to check if a column exists in a table or not in SQL Server , below is a sample code snippet that demonstrates how to do it. How to check if a column exists in a table in SQL Server ? The...

SQL Server 101 – How to add a column with a default value to exi...

May 10, 2020 no comments

There are times when you want to add an column with a default value to the existing table in SQL Server and you can easily do that with the DEFAULT keyword. How to add a column with a default value t...

SQL Server 101 – How to Delete Top N records ?

May 10, 2020 no comments

Assume that you have a table named “Employee” in MS SQL Server and you would like to delete the top 1000 rows from the table. You can use the SQL Query with the TOP (N) as option as shown...

GraphQL.NET 101 – What is GraphQL?

May 7, 2020 no comments

Problem You are new to GraphQL and would like to know more about GraphQL. Solution GraphQL is an open source data query language for API’s and a runtime for fulfilling queries with the existing...

Free Workshop – Learn about GraphQL and .NET integration with Az...

May 4, 2020 no comments

Want to know what GraphQL from the Azure Advocates and how to use it in your .NET application? Here’s a good GraphQL workshop to start with. The workshop is built by Chris Noring and Jen Looper...