Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 1047/1278 | < Previous Page | 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054  | Next Page >

• Matrix Transpose TSQL

  - by rmdussa

  Can we do matrix transpose (rows become columns and columns become rows) in standard SQL? 1 2 3 4 5 4 5 6 6 7 7 8 9 8 9 1 3 4 5 6 2 4 5 6 7 changes to 1 4 7 1 2 2 5 8 3 4 3 6 9 5 6 4 6 8 5 6 5 7 9 6 7 how about no of rows < no of column ? let's consider the no of rows it's fixed.

  Read the article

• id autoincrement/sequence emulation with CassandraDB/MongoDB etc

  - by abovesun

  Hi, I'm trying to build small web-system (url shortcutting) using nonsql Cassandra DB, the problem I stack is id auto generation. Did someone already stack with this problem? Thanks. P.S. UUID not works for me, I do need to use ALL numbers from 0 to Long.MAX_VALUE (java). so I do need something that exactly works like sql sequence

  Read the article

• When we say dbms is it files?

  - by PrithviRaj

  Hi all, when we say rdbms that means it may be oracle, my sql, ms access etc.. But for dbms what are the examples. Is there any example or it just the concept?.

  Read the article

• "Select NOT IN" clause in Linq to Entities

  - by lnetanel

  Hi, Is there a way to use the "NOT IN (select XXX...)" clause in Linq to Entities? All the questions I found were regarding a list of objects (IN (1,2,3)) but I want to generate a query with the following syntax: "select * from table1 where field1 not in(select subfield from subtable)" Be aware that this is Linq to Entities and not Linq to Sql... Is it possible? Thanks!

  Read the article

• Mysql Groupby and Orderby problem

  - by luvboy

  Here is my data structure when i try this sql select rec_id, customer_id, dc_number, balance from payments where customer_id='IHS050018' group by dc_number order by rec_id desc; something is wrong somewhere, idk I need rec_id customer_id dc_number balance 2 IHS050018 DC3 -1 3 IHS050018 52 600 Thanx

  Read the article

• Linq Query with aggregate function

  - by Billy Logan

  Hello everyone, I am trying to figure out how to go about writing a linq query to perform an aggregate like the sql query below: select d.ID, d.FIRST_NAME, d.LAST_NAME, count(s.id) as design_count from tbldesigner d inner join TBLDESIGN s on d.ID = s.DESIGNER_ID where s.COMPLETED = 1 and d.ACTIVE = 1 group by d.ID, d.FIRST_NAME, d.LAST_NAME Having COUNT(s.id) > 0 If this is even possible with a linq query could somebody please provide me with an example. Thanks in Advance, Billy

  Read the article

• Lazy Loading wpf Combobox items

  - by Chris McGrath

  I have an IEnumerable< which lazy loads it's data. I want to just set a Combobox's ItemsSource to the IEnumerable, but when I do it goes and loads all the data anyway (which removes the point of lazy loading). I've tried it with Linq-To-Sql as well since it seems to be a similar theory and it also loads all the data. Is there an easy way to do this?

  Read the article

• Web Data controls

  - by Nani

  Hi, I need to implement Grouping, Sorting, Collapsable for a sql datasource. I shouldn't use third party tools. From last 2 days I was searching net, but dint got the solution. Plz help me in getting these functionalities using any kind of web data control(grid view, repeater, ..) Thank You

  Read the article

• LINQ Equivalent for Standard Deviation

  - by Steven

  Does LINQ model the aggregate SQL function STDDEV() (standard deviation)? If not, what is the simplest / best-practices way to calculate it? Example: SELECT test_id, AVERAGE(result) avg, STDDEV(result) std FROM tests GROUP BY test_id

  Read the article

• List of Lua derived VMs and Languages

  - by Shane Holloway

  Is there a compendium of virtual machines and languages derived or inspired by Lua? By derived, I mean usage beyond embedding and extending with modules. I'm wanting to research the Lua technology tree, and am looking for our combined knowledge of what already exists. Current List: Bright - A C-like Lua Derivative http://bluedino.net/luapix/Bright.pdf Agena - An Algol68/SQL like Lua Derivative http://agena.sourceforge.net/ LuaJIT - A (very impressive) JIT for Lua http://luajit.org MetaLua - An ML-style language extension http://metalua.luaforge.net/

  Read the article

• ASP.NET messageboard that is PnP?

  - by Jim Beam

  What are some of the better messageboard components that are available for an ASP.NET site. I currently have a site in C#/Ajax (FW 3.5) that I would like to add a messageboard to (also have a SQL Server db). Can someone recommend a component that can be easily added?

  Read the article

• Restore Oracle XE data from *.DBF

  - by asero

  Is it possible to restore oracle database from *.DBF files? If yes, then how? I really find it hard to deal with backup and restore things in Oracle compared to SQL Server. I have a backup of the whole oraclexe folder including these files.

  Read the article

• Asynchronous Webpart

  - by Phong Dang

  Dear all, I have a DataGrid control on webpart. DataSource of it connect to SQL. How can we use Asynchronous mode in this case ? Please help me ! Thanks / Phong Dang.

  Read the article

• How can I query all Childcontrols of a Winform recursively?

  - by codymanix

  Iam using windows forms. How can I query all child controls of a Form recursively which have a certain type? In SQL you would use a selfjoin to perform this. var result = from this join this ???? where ctrl is TextBox || ctrl is Checkbox select ctrl; Can I also do this in LINQ?

  Read the article

• High Availability ASP.Net MVC

  - by user360730

  When building an ASP.NET MVC application with High Availability is it best practice to keep the session state on the SQL Server, if there is no state server available?

  Read the article

• Performance Related features for migration from .net 2003 Framework 1.1 to .net 2008 framework 3.5?

  - by KuldipMCA

  I am work on VB.net 2003 Framework 1.1 for last 3.5 years in windows Application. We are currently migrating to VB.net 2008 framework 3.5, but i don't know about the features which related to ADO.net and which is important to performance. I know linq to SQL but our architecture is made in .net 2003 so we should follow this. Any features which is very important to enhance the performance?

  Read the article

• SqlDataAdapter Update

  - by Santhosh

  Can any one help me why this error occurs when i update using sqlDataadapter with join query Dynamic SQL generation is not supported against multiple base tables.

  Read the article

• Creating a file based on the byte() in VB.net

  - by acadia

  Hello, I am retrieving an image from the SQL database into Byte() variable in vb.net Dim img as byte()=dr(0) How do I create a file in my C:\images\ directory from the above img. I want to read the img and then create a file with name bimage.gif Please help

  Read the article

• PHP beautifiers (libraries for formatting code)

  - by takeshin

  Previously, my intention was to ask: Do you know any open source SQL formatter/beautifier library for PHP projects? But I think, I'd better ask: Which code formatting libraries written in PHP are the best? Let's list them all in one place. My types: for CSS syntax: Css Tidy for PHP: PEAR's PHP_Beautifier for HTML syntax: Tidy

  Read the article

• cheap and good hosting site

  - by Alexander

  I need to host my ASP.NET website which uses a SQL database in it. I looked at discountasp.net which is quite popular and they have the offer of 6 months free but I have to pay it annually which is $75/year. I don't have that much money. I am looking at $5 or below per month. Please let me know of any info you guys have

  Read the article

• .net Compact Framework 4.0

  - by Daniel

  Will their be a new release of the compact framework with VS2010 and .net 4.0 and if so what new features will it include? WPF? linq to SQL? etc

  Read the article

• Dynamic find methods Vs conditional statements in rails

  - by piemesons

  Hello Student.find_all_by_name_and_status(‘mohit’, 1) As this will create a exception 'No method exception' first then it will be handled by dynamic Method handler and this will not Student.find(:all, :conditions => [‘name = ? and status = ?’ ‘mohit’, 1]) Does Student.find(1) Will generate method missing exception and will it prevent SQL injection?

  Read the article

• printing invoices

  - by stuarty

  Hi I have invoice data stored in SQL now I want to print those invoices, It would probably take me less than an hour to print them manually but that is not the point I want to do it programmatically using c# What is the quickest simplest way? Excel? Links to some examples? TIA Stuart

  Read the article

• PHP MySQL join table

  - by Jordan Pagaduan

  $sql = "SELECT logs.full_name, logout.status FROM logs, logout WHERE logs.employee_id = logout.employee_id"; tables -- logs logout I'm having error on this. I search join tables in google. And that's what I got. What is wrong with this code?

  Read the article

• Is there a boolean literal in SQLite?

  - by Benjamin Oakes

  I know about the boolean column type, but is there a boolean literal in SQLite? In other languages, this might be true or false. Obviously, I can use 0 and 1, but I tend to avoid so-called "magic numbers" where possible. From this list, it seems like it might exist in other SQL implementations, but not SQLite. (I'm using SQLite 3.6.10, for what it's worth.)

  Read the article

< Previous Page | 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054  | Next Page >