Articles - Database (SQL Server)

0

Like

I was trying to retrieve data from excel in T-SQL using the following statement:

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=C:\MyPath\MyFile.xlsx;;HDR=YES;IMEX=1', [Sheet1$]) ...Read more
0

Like

If you have worked with multiple instances of a database, there is a high chance that you have faced issues with constraints default names. You generated the script for tables/schema changes and try to run on another instance of that database, where some constraint is being dropped from a table, and you get error message. ...Read more
Posted by: Muhammad Idrees
On 11 Jun 2018 | Views: 126 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

This simple SQL Q & A article will explain what is ‘nchar’ & ‘nvarchar’ data-type and the difference between them. ...Read more
Posted by: Shivprasad H. Bist
On 06 Sep 2017 | Views: 230 | Categories: Database (SQL Server)
0

Like

In this post we will see different ways to calculate running total using T-SQL. I am using Microsoft SQL SERVER 2008 R2. ...Read more
Posted by: Muhammad Idrees
On 06 Aug 2017 | Views: 273 | Categories: Tips & Tricks, Patterns, Other, Database (SQL Server)
0

Like

In this post, I will explain how to script multiple objects using SQL Server Management Studio. You may be aware of generating script by right clicking on specific object (Table / Stored Procedure / Function / View etc), or also you may generate scripts by right clicking on the database node, select Tasks, and then click on Generate Scripts... option. ...Read more
Posted by: Muhammad Idrees
On 26 Jul 2017 | Views: 202 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

In this post, I am sharing a solution for a problem I faced while I started using Power BI. When you try to connect with SQL Server as Data Source, you may encounter this error message:

The user was not authorized ...Read more
Posted by: Muhammad Idrees
On 26 Jul 2017 | Views: 207 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

I created small utility program for different routine tasks to run on different schedules, one of which is to take database backup to a local folder, and it was working fine. To have access it across network for selected users, and making it available for copy/move to other backup devices, we shared this folder on network. ...Read more
Posted by: Muhammad Idrees
On 26 Jul 2017 | Views: 190 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

In this article we will explain basic fundamentals of the MSBI and SQL Server technology. ...Read more
Posted by: Shivprasad H. Bist
On 02 Jan 2017 | Views: 239 | Categories: Database (SQL Server)
0

Like

In this article learn to install SQL Server 2014 step by step using our example . ...Read more
Posted by: Shivprasad H. Bist
On 29 Dec 2016 | Views: 208 | Categories: Database (SQL Server)
0

Like

In this video we will learn SQL Server step by step in 16 hours. ...Read more
Posted by: Shivprasad H. Bist
On 12 Dec 2016 | Views: 214 | Categories: Database (SQL Server)
Page 1 of 11
Other lins

.Net Techies
Other lins