I have one column like this in SQL Server and I need get this codes ## Title## حساب-س1-2564492-305-151ساير سپرده ها حساب-س151.305.881307.1ساير سپرده ها حساب-س1-1547032-305-151ساير سپرده ها حساب-…
If there is data linked to an order number, how do i pull some but not the other (not exists?)?
I’m using Toad for Oracle. I currently have Order Numbers with items in both our yard and our warehouse. I’m looking to see items that ONLY have items in the yard. Essentially I need a count of the …
I need to migrate data from one old table to a new table by storing appropriate CityId instead CityName
I’m migrating data from one table to another table in SQL Server, In this process what I need to do is “I have 10 columns in old table one column is ‘CityName’ which is varchar and in the new table, I …
How to add a character to specific index in string
I have a db with email-addresses which are 15 characters in total. Some are 14 characters long and they have the same in common, they miss a 0 in their name at the 3th index. I had a what similar …
how could i add the value of below three fields of a table and store it into user define fields from DB2 query
I am looking for a solution to add the below three decimal fields and store them in a user defined field, these three fields belongs to 1 table and I need to sum the value of it. Kindly help! I have …
Get table name from SQL query
I am using golang SQL parser to fetch query related information from actual SQL query string. I am able to find the type of query using following code: queryType := sqlparser.StmtType(sqlparser….
Check If a Column Exists in Laravel Migration File
Already I have a table name table_one. Now I want to add two more columns to it. Everything works fine so far. But in my method, I want to check a column exists or not in my table like dropIfExists(‘…
List of all table and column level privileges for a MySQL database
What is the easiest way to list all table-level and column-level privileges for a MySQL database? I need to know what level of customized access has been granted for a specific database and which users have fine-tuned access to certain tables and/or columns. Answer To list table level privileges, you can quer…
IF Exists then update in mysql
New to MySQL, need help in translating the next query to MySQL If exists (select * from INFORMATION_SCHEMA.COLUMNS where table_name= ‘MyTable’ and column_name = ‘MyColumn’) begin …
How to save unicode character in SQL database
I am trying to save ThinSpace (u2009) to the database using ADO.NET classes, but instead I am getting “?” symbol in db in place of ThinSpace. String that I save to db in UTF8 format. var …