How can I write a SQL count with group by clause using Propel ORM in Symfony?
- by Failpunk
How can I write the following SQL query using the Propel ORM?
SELECT species, COUNT(*) FROM Bird GROUP BY species;
Search Results
Search found 79317 results on 3173 pages for 'sql error messages'.
Page 513/3173 | < Previous Page | 509 510 511 512 513 514 515 516 517 518 519 520 | Next Page >
-
-
How do you extract just date from datetime in T-Sql?
- by Grand Master T
I am running a select against a datetime column in SQL Server 2005. I can select only the date from this datetime column?Read the article
-
How to move data from VistaDB to MS SQL Server?
- by Samnang
Currently, I have a blog that is using VistaDB as back-end database, but later I realize that I want to MS SQL Server instead. I was wondering there is any tools that are available for migration data like this problem?Read the article
-
Can I execute SQL statements directly in a JDO environment?
- by Carl Rosenberger
I am using Datanucleus JDO on top of HSqlDb. I would like to execute the following SQL statement to tell HsqlDb to set the write delay to 0: "SET WRITE_DELAY 0" Is there a way I can do this from a JDO PersistenceManager or a PersistenceManagerFactory? On a sidenote: I have tried to modify write_delay by using the following connection URL: jdbc:hsqldb:file:data/hsqldb/dbbench;write_delay=false It didn't work. I debugged the HsqlDb sources and I could still see the write delay being set to 10 seconds.Read the article
-
ASP.NET - Storing SQL Queries in Global Resource File?
- by Arthur Chaparyan
Is it a good idea to store my SQL queries in a global resource file instead of having it in my codebehind? I know stored procedures would be a better solution but I don't have that luxury on this project. I don't want queries all over my pages and thought a central repository would be a better idea.Read the article
-
Will Indexing Binary Columns Improve Performance for SQL WHERE BETWEEN statements?
- by thenonhacker
I have a table that has a binary column that represents IP Address data. One of the queries perform a BETWEEN comparison on that binary column. If I index that column, will performance improve for the BETWEEN comparison in the SQL Statement?Read the article
-
Is it poor practice to build an SQL query using WHERE 1=1 AND ...
- by Rob
I'm writing a script that builds an SQL query by concatenating the string and adding conditions to the WHERE clause as needed. Would it be better practice to use WHERE 1=1 so that the first condition is satisfied and the script can just concatenate an AND x = 'y' to the query, or should I write the extra code to check if a clause has been added and if not, add the AND ? Confusing question, I know. Let me know if I need to be more clear. RobRead the article
-
Can I use @table variable in SQL Server Report Builder?
- by edosoft
Using MS SQL 2008 Reporting services: I'm trying to write a report that displays some correlated data so I thought to use a @table variable like so DECLARE @Results TABLE (Number int, Name nvarchar(250), Total1 money, Total2 money) insert into @Results(Number, Name, Total1) select number, name, sum(total) from table1 group by number, name update @Results set total2 = total from (select number, sum(total) from table2) s where s.number = number select from @results However, Report Builder keeps asking to enter a value for the variable @Results. It this at all possible?Read the article
-
Are products like SQL Server and Oracle are "ORDBMS"?
- by n10i
According to wikipedia! http://en.wikipedia.org/wiki/ORDBMS IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success So, are these products true "ORDBMS" like PostgreSQL? or they are they are long way from it? can someone plz! point me to any link where i can read about the features still to be implemented by these RDBMS to become true ORDBMS!Read the article
-
How can I automate the "generate scripts" task in SQL Server Management Studio 2008 ?
- by Brann
I'd like to automate the script generation in SQL Server Management Studio 2008. Right now what I do is : Right click on my database, Tasks, "Generate Scripts..." manually select all the export options I need, and hit select all on the "select object" tab Select the export folder Eventually hit the "Finish" button Is there a way to automate this task? Edit : I want to generate creation scripts, not change scripts.Read the article
-
CF9's Apache Lucene vs SQL Server's full text search?
- by Henry
ColdFusion 9's full text search is now based on Apache Lucene. We also use SQL Server. Which one's better? Which one's easier? Thanks!Read the article
-
Is it necessary to create ASP.NET 4.0 SQL session state database, distinct from existing ASP.NET 2.0
- by Chris W. Rea
Is the ASP.NET 4.0 SQL session state mechanism backward-compatible with the ASP.NET 2.0 schema for session state, or should/must we create a separate and distinct session state database for our ASP.NET 4.0 apps? I'm leaning towards the latter anyway, but the 2.0 database seems to just work, though I'm wondering if there are any substantive differences between the ASPState database schema / procedures between the 2.0 and 4.0 versions of ASP.NET. Thank you.Read the article
-
How can I trim certain characters from a string in sql?
- by Matt
I would like to trim all special characters from a string in SQL. I've seen a bunch of people who use substring methods to remove a certain amount of characters, but in this case the length on each side of the string is unknown. Anyone know how to do this? Thanks, MattRead the article
-
How to concatenate all the records in a column returned by a query into one varchar string in T-SQL?
- by Ivan
A query (SELECT/FUNCTION/VIEW/PROCEDURE) returns a column of varchar records. I need to concatenate them all into one single varchar line. How do I best do it in T-SQL?Read the article
-
Will performance of a SQL server degrade if the DB can't fit in the memory?
- by Carl Hörberg
Will the performance of a SQL server drastically degrade if the database is bigger than the RAM? Or does only the index have to fit in the memory? I know this is complex, but as a rule of thumb?Read the article
-
Setting up a linked server to another server which isn't in a domain without using SQL authenticatio
- by Telos
Server A (SQL2005) is in our primary domain, but server B (SQL2000) is just in a windows workgroup. We are not allowed to join it to the domain, or bad things happen... We also can't enable SQL authentication on server B. We've got domain accounts for A, and matching local accounts on server B. I can connect to B from my local PC or A using SSMS and a domain login, but I can't get the linked server to connect. Any ideas how to do this?Read the article
-
Linq to SQL: How to delete using only the primary key?
- by Jeremy
How do I delete a record using Linq to SQL using only the primary key, without having to retrieve the exsting record from the database?Read the article
-
How can I get a JSON object from a SQL Server table?
- by jlech
I have a view that I want to be converted into JSON. What is the SQL that I can use to produce on the server the JSON string needed to be returned?Read the article
-
How to convert a C# Queue into a binary datatype to be stored as a SQL Blob?
- by Soham
Hi All, How do I convert a C# Queue into a binary variable, so that I can store it as a blob in SQL? Help appreciated! SohamRead the article
-
Where does sql server stores the stored procedure code?
- by NoProblemBabe
I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?Read the article
-
In SQL, can we always write an inner join statement as a main query and subquery if we only want to
- by Jian Lin
In SQL, can we always write an inner join statement as a main query and subquery or vice versa if we only want to find the intersection? For example, select * from gifts g where g.giftID in (select giftID from sentGifts); can do a join and show the gifts sent in the sentGifts table, but it won't be able to show the sentTime because that is inside the subquery. But if all we care is to find the intersection, without caring what is being displayed, then we can always convert one to the other?Read the article
-
How to insert hyperlink into access database via sql?
- by CSharperWithJava
I have a fairly simple MS Access Database that contains some metadata about a bunch of documents and a hyperlink field that links to the document on our network drive. However, when I use a SQL INSERT statement to populate the hyperlink field, the value I give it only becomes the display text, not the actual link. How can I make the value a functional hyperlink? I'd think that the hyperlink data type would actually create hyperlinks. I'm using Access 2002 SP3.Read the article
-
How rigid is the max size of a VARCHAR in SQL Server?
- by thinknow
i.e. if I create a VARCHAR(50) field, what happens if I try to assign it a value that's 100 characters long? Will SQL Server let me do this? Is it somehow less efficient?Read the article
-
Is it possible to use SQL Server Compact Edition in an Open Source project?
- by Sergi
I am aware of other solutions like System.Data.Sqlite or Firebird through Dblinq, but since nothing beats SQL Compact Edition (integration-wise) with Visual Studio, I would like to use it and to know if its license allows its usage in Open Source projects. Thanks.Read the article
-
Which is faster in SQL, While loop, Recursive Stored proc, or Cursor?
- by Casey
Which is faster in SQL, While loop, Recursive Stored proc, or Cursor? I want to optimize the performance in a couple of spots in a stored procedure. The code I'm optimizing formats some strings for output to a file.Read the article
