I want to do a case sensitive search in my SQL query. But by default, SQL Server does not consider the case of the strings. Any idea on how to do a case sensitive search in SQL query? 11 Answers 11
Great forum! I’m a total newbie to SQL but a quick learner. I have a large database of content, >140k posts. Some posts have Featured Images, others do not. I would like to edit post_content on posts with Featured Image. I do not need to know anything about the Featured Image, only that the post … Read more
I was trying to create a table as follows, create table table1(date1 datetime,date2 datetime); First I tried inserting values as below, insert into table1 values(’21-02-2012 6:10:00 PM’,’01-01-2001 12:00:00 AM’); It has given error saying, Cannot convert varchar to datetime Then I tried below format as one of the post suggested by our stackoverflow, insert into … Read more
I’m working on the design for a RoR project for my company, and our development team has already run into a bit of a debate about the design, specifically the database. We have a model called Message that needs to be persisted. It’s a very, very small model with only three db columns other than … Read more
Entering the following command into a PostgreSQL interactive terminal results in an error: ALTER TABLE tbl_name ALTER COLUMN col_name varchar (11); What is the correct command to alter the data type of a column? 3 Answers 3
I have seen many queries with something as follows. Select 1 From table What does this 1 mean, how will it be executed and, what will it return? Also, in what type of scenarios, can this be used? 15 Answers 15
I have the following query: $query = UserSubject::where(‘user_id’, Auth::id())->select(‘subject_id’)->get(); and as expected I get the following result: [{“user_id”:8,”subject_id”:9},{“user_id”:8,”subject_id”:2}] Is there a way of copying the above result into another table so that my table looks like this? ID|user_id|subject_id 1 |8 |9 2 |8 |2 The problem I have is that the $query can expect any … Read more
How to copy/append data from one table into another table with same schema in SQL Server? Edit: let’s say there is a query select * into table1 from table2 where 1=1 which creates table1 with the same schema as well as data as in table2. Is there any short query like this to only copy … Read more
I’m reading through some old code at work, and have noticed that there are several views with an order by 1 clause. What does this accomplish? Example: Create view v_payment_summary AS SELECT A.PAYMENT_DATE, (SELECT SUM(paymentamount) FROM payment B WHERE PAYMENT_DATE = B.PAYMENT_DATE and SOME CONDITION) AS SUM_X, (SELECT SUM(paymentamount) FROM payment B WHERE PAYMENT_DATE = … Read more
I’m trying to delete orphan entries in a mysql table. I have 2 tables like this: Table files: | id | …. ———— | 1 | …. | 2 | …. | 7 | …. | 9 | …. table blob: | fileid | …. ———— | 1 | …. | 2 | …. | … Read more
