Posts Tagged ‘SQL’

The post contains a simple query to find the number of columns in your sql sever table.


SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_CATALOG = 'databse_name' AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'table_name'

Last week i got a simple work to create a table with the result of different tables. We can also create a view to see a single result set from different table but my task was to create a table. (more…)

SQL Server doesn’t need any introduction as it is a widely used product from a technology giant Microsoft.

But very few of them actually know the history of sql server and obviously I m one of them few days ago. This post is about the same……. (more…)

When you are dealing with bulk data then all you have is a CSV file. Comma Separated Value File or CSV file is a data file which contains large amount of data separated by comma.

The scenario is you have to insert the given data in SQL Server and the question is What will you do?

Option 1: Map fields one by one

Option 2: Use a small function called Sql Bulk Insert to insert data in the table. (more…)