Search Results

Search found 53054 results on 2123 pages for 'sql sample database'.

Page 559/2123 | < Previous Page | 555 556 557 558 559 560 561 562 563 564 565 566  | Next Page >

• How to connect to SQL Server from another computer?

  - by user198147

  Hi, I want to connect from home using MS SQL Server 2005 to another PC. I had a look on the msd...but before connecting it says I schould connect to another computer using the computer management and it didn't work out....I can only connect to computers from my workgroup? Thanks, Luisa

  Read the article

• Are there any utilities to extract binary data from SQL Server?

  - by Sean Taylor

  Are there any utilities available that allow you to bulk extract binary data from a SQL Server table? For example, I have a number of Word documents stored in a table and I would like to extract all of these documents into files. I know could do this by writing some .NET code, but I only need to do it once.

  Read the article

• 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;

  Read the article

• What should be the considerations for choosing SQL/NoSQL?

  - by Yuval A

  Target application is a medium-sized website built to support several hundred-thousand users an hour, with an option to scale above that. Data model is rather simple, and caching potential is pretty high (~10:1 ratio of read to edit actions). What should be the considerations when coming to choose between a relational, SQL-based datastore to a NoSQL option (such as HBase and Cassandra)?

  Read the article

• For SQL, when did it start to be desirable to always use the words "Inner Join" instead of implicitl

  - by Jian Lin

  For SQL, when did it start to be desirable to always use the words "Inner Join" instead of implicitly joining by: select * from t1, t2 where t1.ID = t2.ID; ? Is it just for style or to distinguish between outer join or are there other reasons for it?

  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. Rob

  Read the article

• How is this Nested Set SQL query converted into a LINQ query?

  - by Chad

  Querying a Nested Set Model table, here's the SQL... how can this be written in LINQ? SELECT parent.name FROM nested_category AS node, nested_category AS parent WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.name = 'FLASH' ORDER BY parent.lft; particularly, the FROM part... never tried to do anything like that in LINQ.

  Read the article

• 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 can I figure out my SQL Server address without having the Management Studio installed?

  - by Sergio Tapia

  I have Microsoft SQL Server 2008 installed. It appears in the add/remove programs window. How can I create/delete/alter tables and find the address of my server if I don't have Management Studio installed? I'd like to create the tables and such directly in Visual Studio 2010 premium.

  Read the article

• Is there any SQL Server studio managment and redgate sqlcompare/datacompare like tools for MySQL?

  - by Jack

  I'm looking for SQL Server studio management-like and redgate sqlcompare/datacompare-like tools for MySQL. What have you used that is as close to these tools or better for MySQL?

  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

• 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

• 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

• 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, Matt

  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

• 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! Soham

  Read 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

• How to SELECT the last 10 rows of an SQL table which has no ID field?

  - by Edward Tanguay

  I have an MySQL table with 25000 rows. This is an imported CSV file so I want to look at the last ten rows to make sure it imported everything. However, since there is no ID column, I can't say: SELECT * FROM big_table ORDER BY id DESC What SQL statement would show me the last 10 rows of this table? The structure of the table is simply this: columns are: A, B, C, D, ..., AA, AB, AC, ... (like Excel) all fields are of type TEXT

  Read 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

• 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

• 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

• 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

• 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

< Previous Page | 555 556 557 558 559 560 561 562 563 564 565 566  | Next Page >