Search Results

Search found 43979 results on 1760 pages for 'sql down under'.

Page 429/1760 | < Previous Page | 425 426 427 428 429 430 431 432 433 434 435 436  | Next Page >

• 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 to integer-divide round negative numbers *down*?

  - by Conrad Albrecht

  Seems like whenever I divide a negative int by a positive int, I need it to round down (toward -inf), not toward 0. But both C# and C++ round toward 0. So I guess I need a DivideDownward() method. I can write it in a few lines with a test for negative and so on, but my ideas seem klugey. So I'm wondering if I'm missing something and if you have an "elegant" way to round negative division downward.

  Read the article

• how to put a drop down list in a flex advanced data grid

  - by Setori

  How can one put components into an advanced data grid? I wish to have a standard row with string items, in this row there is a date selector I want to put in, and in another cell of the row I want to put a drop down list box containing text "40" and "20" or you can manually edit the cell so that it displays what ever input you decide (other than 40 and 20) thanks so much

  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 to make grid column as drop down list for all rows using jquery

  - by kumar

  Hello friends.. colNames: ['A','B','C','D'], colModel: [ { name: 'A', index: 'A', width: 90 }, { name: 'B', index: 'B', width: 100 }, { name: 'C', index: 'C', width: 70 }, { name: 'D', index: 'D', edittype: 'select', width: 100, editoptions: { value: { 1: 'Yes', 2: 'No'}} } ], My concersn here is.. I am displying A B C D values from db2... for Last Column D I need to put defalut drop down list for all the rows. Thanks can any body help me out.. thanks

  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

• 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

• 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

• Scale down WebView content in iphone App

  - by TechFusion

  Hello, I am looking to display multiple web content in one main view. I have created different WebView and make it's height and width to fit all in one view size of Landscape mode. How to scale down web view content to show data in small size (as per WebView height and width) ? I have built application using Interface builder.The view is interface with one tab bar of tab bar controller. Thanks,

  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

• How do I keep this from pushing down?

  - by Doug

  http://dougymak.com/jquery/test.html Playing with jQuery and upon pressing "More" on the top left, it pushes down the "Brown" layer. How can I keep the brown layer steady? It happens in Chrome, but not Firefox.

  Read the article

• How to detect : scrolling - up or down?

  - by Ilya Blokh

  System.Windows.Forms.Form has only one scroll event-Scroll, but it is necessary to recognize scrolling up and scrolling down.Could you tell me,how to do this?

  Read the article

• Can I trigger an Update Panel from a Drop Down list in a User Control

  - by Jisaak

  I have a user control in a master page with two drop down lists. When the user selects an item out of either ddl, I want to load a specific user control inside an update panel on the content page. I know how to load the controls in the update panel, but I can't figure out how to get the user control to trigger the update panel. Any suggestions are very much appreciated.

  Read the article

• Slowing down computer for debugging intermittent defect

  - by Paul Reiners

  Is there a way to slow down my development computer to try to replicate a defect that only occurs intermittently on a slow machine? (For what it's worth, Ableton Live has a CPU usage simulation feature, but I've never seen something like this for debuggers.)

  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

• need to get value from the database and populate a drop down list using jquery

  - by jarus

  hi i need to populate a drop down list when i select a certain value , and the options need to be queried from the database .. can i achieve this from jquery ? if i can then please i would appreciate any help..

  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

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

< Previous Page | 425 426 427 428 429 430 431 432 433 434 435 436  | Next Page >