Category: Sql Server 2016

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” »

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” »

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” »