Is it possible to select entire row in a table and get sort of checksum? I am looking for a way to tell my code to update data only if at least one record has been changed. From perspective of data …
‘In’ clause in SQL server with multiple columns
I have a component that retrieves data from database based on the keys provided. However I want my java application to get all the data for all keys in a single database hit to fasten up things. I can …
Difference between database level trigger and server level trigger in SQL Server
Can anyone please tell me the difference between database level trigger and server level trigger in SQL Server ? Thanks in advance.
Database design, customers (companies / individuals) in the same table?
Found possible duplicate : Database design, multiple types of customers in the same table Hi everyone. I’m actually looking for a nice way to create a database with 2 kinds of customers : Individuals and Companies. This is for a website and I’m using CodeIgniter framework (not sure it’s impo…
How to create a huge string in Postgresql
For testing / debugging purposes, I need to get an enormous string into a field for one of my records. Doesn’t matter what the string is. Could be a million “*”s or the contents of Moby Dick…. …
How to get the totals of each column MySQL
I have an SQL query that get the number of jobs, gross weight etc for different companies. The result in MySQL Workbench looks like this: I would like to add another row at the bottom that …
Why can’t I use column aliases in the next SELECT expression?
Can I modify the next to use the column aliases avg_time and cnt in an expression ROUND(avg_time * cnt, 2)? SELECT COALESCE(ROUND(stddev_samp(time), 2), 0) as stddev_time, MAX(time) as …
Database design for InApp Purchases [closed]
I’m struggling with designing a proper database architecture for my problem. What I have: Player with unique playerID and other information (in the database). Items with a unique itemID and other …
SQL reporting invalid syntax when run in Power BI
I have written an SQL script which runs fine when executed directly in SQL Management Studio. However, when entering it into Power BI as a source, it reports that it has an incorrect syntax. This is …
Looking for help to make a select statement dynamic
I want to make a dynamic select statement that can select whatever table I ask for, same with table columns in my database. Here is my select class so far: <?php class select extends database{ …