Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • About
  • Toggle search form

Category: Sql Server 2016

Delete all rows from all tables in a Sql Server database

Delete all rows from all tables in a Sql Server database may not be an easy task. This because in a relational database you have foreign keys between tables, and to empty all tables you have to write delete statements in the correct order to avoid foreign key violations. I know that there are scripts…

Read More “Delete all rows from all tables in a Sql Server database” »

Sql Server

Search a string in stored procedures, functions and views in a SQL Server database

If you want to search a string in stored procedures, functions and views, maybe you can use some special tools. But, for instance, suppose that you can only use SQL Server Management Studio. Is there a way to do this? Yes…. You could use the following query: SELECT DISTINCT OBJECT_NAME(id) AS [OBJECT_NAME] FROM sys.syscomments WHERE…

Read More “Search a string in stored procedures, functions and views in a SQL Server database” »

Sql Server

SQL Server LEN function return 0 passing a string with one space

Try to answer this riddle: What is the result of this SQL Server query: PRINT LEN(‘ ‘) I would answer 1, since I passed a string with one space…. but it’s the wrong answer. In this case the LEN function returns 0! Why this behavior? If you check the Sql Server documentation at https://docs.microsoft.com/en-us/sql/t-sql/functions/len-transact-sql?view=sql-server-2017 this…

Read More “SQL Server LEN function return 0 passing a string with one space” »

Sql Server

Oracle JRE 7 Update 51 (64-Bit) or higher is required for Polybase

During the installation of Sql Server 2016 on a brand new server running Windows Server 2016, in the prerequisites checking phase I obtained the following error: “Oracle JRE 7 Update 51 (64-Bit) or higher is required for Polybase”. I solved the problem installing the following version of Java: Java SE Development Kit 7u79 available at…

Read More “Oracle JRE 7 Update 51 (64-Bit) or higher is required for Polybase” »

Sql Server 2016

Posts navigation

Previous 1 2

Copyright © 2023 The Dummy Programmer | Privacy Policy | Terms of use |

Powered by PressBook Masonry Dark