Free eBook – Introducing Microsoft SQL Server 2012 #sqlserver2012

Microsoft SQL Server 2012 is Microsoft’s first cloud-ready information platform. It gives
organizations effective tools to protect, unlock, and scale the power of their data, and it works
across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and
both private and public clouds. Continue reading Free eBook – Introducing Microsoft SQL Server 2012 #sqlserver2012

How to avoid Select *

It is commonly known that you should not use SELECT * when you are writing a query.
Most of the times, we only need a some of the columns that a table has and we should retrieve only those columns.
This are some of the disadvantages of using Select * :
Continue reading How to avoid Select *

How to get only the date from datetime

I have listed below two solutions for extracting a date from a datetime : Continue reading How to get only the date from datetime

How to delete column that has a foreign key in MsSql

Scenario :  Delete a column that has a foreign key. Continue reading How to delete column that has a foreign key in MsSql

How to create a foreign key in MsSql

Scenario : We have two tables 1 Customers 2 Sales

I have to make sure that all the client id's that are inserted in the Sales table exists in the Client table Continue reading How to create a foreign key in MsSql

%d bloggers like this: