Pubudu Dewagama

Removing duplicates records in SQL Server table

In this example we are going to remove some duplicate records from the sql server table. According to below screen shot few records ha...

Removing duplicates records in SQL Server table

Reviewed by Pubudu Dewagama on 12:26:00 AM Rating: 5

In this post I am going to show how to get Table structure using SQL Query. select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=...

How can I show the table structure in SQL Server?

Reviewed by Pubudu Dewagama on 9:23:00 PM Rating: 5