Boolean Geek

Search This Blog

Weakly VS Strongly Typed Languages

on February 25, 2019

Get link
Facebook
X
Pinterest
Email
Other Apps

Coming Soon..

Software Engineering

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How to Find a GUID in whole SQL database (Script)

Just recently, while working on a script, I came across a situation where I had to check where the values (data type GUID) in a column of a specific table in my database were coming from. My first instinct was to check the foreign key relation on that column. But, as soon as I checked for the foreign keys associated with my table, I realized that there weren't any foreign key relations for that specific columns. I got confused. I wanted to know where the values were referenced from. Then it dawned upon me that I can simply search for the GUID in the database and get to know where else these values exist. That way, I'll know where else these values exist in the database. I searched the web and found some solutions but then, I decided to challenge myself to make my own utility script. So, here it goes: USE YourDBName GO DECLARE @search nvarchar(100) = 'A37CC634-5289-413E-AD78-00191416284C' DECLARE @tablename NVARCHAR(100) DECLARE @columnname NVARCHAR(100) ...

How to find all tables having specified column name in a Database

SELECT s.name AS [Schema], o.name ObjectName, c.name AS ColumnName, t.name AS DataType, o.type_desc AS ObjectType FROM sys.columns c JOIN sys.objects o ON c.object_id = o.object_id JOIN sys.types t ON t.system_type_id = c.system_type_id JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE c.name = '(column_name)' AND t.name = '(data_type)' The script will return the result in this format:

Scale of decimal point numbers in SQL

Simply putting, scale of an SQL decimal number is the number of digits appearing after the decimal point. Examples: Scale of 9.8 is 1 Scale of 3.142 is 3 Scale of 17.123456789 is 9 How to find the scale of a decimal number? Sometimes, in the life of a SQL developer, there comes a scenario where you have to check for the scale of a decimal number to cater some changes made on other layers of development environment. For instance, if a UI change is made and it does not allow entering a value in a specific field that is more than, say, 2 decimal points, all values in the database for the specific field should be set to a scale of 2. A very easy way to find the scale of a decimal point using SQL is as follows: SELECT LEN(SUBSTRING((CAST(333.45657 AS nvarchar(max))),CHARINDEX('.',(CAST(333.45657 AS nvarchar(max))))+1,LEN(CAST(333.45657 AS nvarchar(max)))))

Powered by Blogger

Weakly VS Strongly Typed Languages

Comments

Post a Comment