Search Results

Search found 31421 results on 1257 pages for 'entity sql'.

Page 434/1257 | < Previous Page | 430 431 432 433 434 435 436 437 438 439 440 441  | Next Page >

• Can somebody explain the running total and SQL self-join in this tutorial to me?

  - by Philip Brocoum

  I was reading over the tutorial here: http://www.1keydata.com/sql/sql-running-totals.html and it all made sense until it suddenly got extremely ridiculously unbelievably complicated when it got to rank, median, running totals, etc. Can somebody explain in plain English how that query results in a running total? Thanks!

  Read the article

• Need to remotely create an ODBC connection to a SQl server.

  - by kris

  I have an Access 2007 database with a table in it that is linked to a SQL server. I need to roll this version of the database out to approximately 10 people in different states. In order to do that, they need an ODBC connection to the SQL server installed on their machines. I am looking for a way to do this remotely. Either through VBA in the database itself or perhaps a Batch file linked to their shortcut....I am open to ideas....

  Read the article

• Are there any good .Net libraries for building arbitrary sql commands? Not relational data.

  - by Burg

  I am looking for some library that takes the TextWriter approach to writing SQL commands (much like there is the HtmlTextWriter in .Net for writing html). I am NOT writing CRUD-type commands for relational data, I am writing arbitrary SQL (bulk inserts, table creation, creating backups, etc). Any suggestions are appreciated.

  Read the article

• Subsonic: How to exclude a table column so that its not included in the generated SQL query

  - by Fleents

  I need to insert a record to a table. Subsonic builds the query something like this (as far as i know): INSERT INTO Table1 (Title, Description, RowVersion) VALUES (@Title, @Description, @RowVersion) But i want to remove the RowVersion column from the SQL query bacause its autogenerated by the sql server. How can i do that?

  Read the article

• can i put password for sql database like (test.mdf) to secure it if no what is he best way to secu

  - by KHALID

  i devoleped windows application with c# and i use local sql database i want to secure it from admins - can i put password for sql database like (test.mdf) to secure it if no what is he best way to secure my database (in other words) can i keep my database not authenticated with windows and only be seen for auser i define

  Read the article

• Why doesn't SQL DISTINCT work with ORDER BY CAST?

  - by Tommy

  Including DISTINCT to an SQL query that also uses ORDER BY CAST(thecolumn AS int) as shown here seems to remove that sorting functionality. Any reason these cant work together? (Using sqlite with the C api) Thanks. EDIT: Started with - sprintf(sql, "SELECT DISTINCT rowX FROM TableX Order By Cast(rowX As int) LIMIT 150 OFFSET %s;", Offset); rowX is Type CHAR(5)

  Read the article

• How to run SQL that contains bind variables in the ODT Query Window?

  - by dnorthut

  How do you run SQL that contains one or more bind variables in the Oracle Developer Tools for Visual Studio Query Window? For example, the following works fine in SQL*Plus: variable x NUMBER; BEGIN :x := 0; END; / SELECT 1 FROM DUAL WHERE :x <> 1; When executed in the ODT Query Window, the following exception is raised in the Query output pane: ERROR ORA-01008: not all variables bound

  Read the article

• Where can I find the list of all SQL-standard-mandated aggregate functions? [on hold]

  - by einpoklum

  I know that different DBMSes support different aggregate functions; for example: MySQL's aggregates Oracle's aggregates I want to get the list of aggregates mandated by the SQL standard. Or, to be more precise, the lists of mandatory aggregates for SQL 1992, 1998, 2003, 2008 and 2011 - with 2011 being the most important to me. Edit: Of course if I buy a copy of the standards I could compile these lists myself. My question is whether they're accessible somewhere online.

  Read the article

• How do I combine 3 date columns from 3 tables in Foxpro sql?

  - by Tass-man

  I am writing a foxpro sql & need to combine three date columns from three different tables into a new date column. As an example if the three tables are A,B,& C and the date Columns are Adate, Bdate and Cdate, how do I combine them as distinct and separate dates into a column called TransDate and in the SQL? I would appreciate samples of the code if possible, as I am very new at this

  Read the article

• Can you set SQL Server permissions from a Silverlight app?

  - by Paul Smith

  Is it possible to create a Silverlight application which can be used to provide a nice user interface for managing SQL Server permissions? We want to create a simple admin app to allow certain users to create new users, disable old users, and manage specific permissions for those users, but we feel that SQL Server Management Studio is perhaps too complex.

  Read the article

• Is SQL DATEDIFF(year, ..., ...) an Expensive Computation?

  - by rlb.usa

  I'm trying to optimize up some horrendously complicated SQL queries because it takes too long to finish. In my queries, I have dynamically created SQL statements with lots of the same functions, so I created a temporary table where each function is only called once instead of many, many times - this cut my execution time by 3/4. So my question is, can I expect to see much of a difference if say, 1,000 datediff computations are narrowed to 100?

  Read the article

• Does SQL Server 2008 compress the results sent back to my web server?

  - by Jeff Meatball Yang

  I have a typical reporting application: Large report <-- HTTP Compression --> ASP.NET Web Server <-- ??? --> SQL Server 2008 Since I have so much (repetitive) data to send to the client, I would like both network hops to have compression. Is there a transport-level compression setting for SQL Server?

  Read the article

• SQL Insert into ... values ( SELECT ... FROM ... )

  - by Shadow_x99

  I am trying to insert into a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL-Engine of the day (MySQL, Oracle, SQLServer, Informix, DB2). I've been wondering if there is a silver-bullet syntax coming from an SQL Standards (For example, SQL92) that would allow me to insert the values without worrying about the underlying database.

  Read the article

• How do I deploy SDF files from SQL Server Compact version?

  - by pranay

  How do I deploy SDF files from SQL Server Compact Edition? Do I need to install SQL Server on client machines to deploy this file?

  Read the article

• How to wrap LINQ to SQL queries in stored proc?

  - by Satish

  LINQ to SQL internally generates SQL queries and fire on the database after submitting changes. Is there any way we can wrap all these queries in some stored procedure and execute this store proc everytime when anything gets inserted or updated in the database. Problem is only stored procedures are allowed to carry any insert or update or delete operations, direct queries are restricted for security purpose.

  Read the article

• What's the execute order of the different parts of a SQL select statement?

  - by Yousui

  Hi guys, What's the execute order of the different parts of a SQL select statement? Such as distinct from order by group by having multiline function(count, avg, max, min...) top(sql server) or limit(mysql) other parts Does the different databases have the same execution order? Great thanks.

  Read the article

• C# SQL: What is the best way to implement a dynamic table?

  - by SirMoreno

  I want to allow the user to add columns to a table in the UI. The UI: Columns Name:__ Columns Type: Number/String/Date My Question is how to build the SQL tables and C# objects so the implementation will be efficient and scalable. My thought is to build two SQL tables: TBL 1 - ColumnsDefinition: ColId, ColName, ColType[Text] TBL 2 - ColumnsValues: RowId, ColId, Value [Text] I want the solution to be efficient in DB space, and I want to allow the user to sort the dynamic columns. I work on .NET 3.5 MSSQL 2008. Thanks.

  Read the article

• Sql Server OLEDB provider error. The provider ran out of memory error.

  - by Serdal

  Sorry for my english :). I have a windows service. Service report some excel files weekly. But i got a"OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory" Ole Db error. Service use SQl Server 8.00.194 and it link another SQL Server. I do not know why i receive this error. Thanks for help.

  Read the article

• I need to parameterize against sql injection in asp classic, what things should I take some time to

  - by Tchalvak

  I can already see that I'm not going to enjoy the experience, but I have to do some sql cleanup on this 1000 file asp classic web-app, and before I get to hacking away at it I'd like to be aware of any major gotchas to watch out for with asp classic/sql parameter preparing/asp whitespace altering. What are some good quick overview resources, and what should I watch out for?

  Read the article

• Why doesn't Oracle SQL allow us to use column aliases in GROUP BY clauses?

  - by Mehper C. Palavuzlar

  This is a situation I'm generally facing while writing SQL queries. I think that writing the whole column (e.g. long case expressions, sum functions with long parameters) instead of aliases in GROUP BY expressions makes the query longer and less readable. Why doesn't Oracle SQL allow us to use the column aliases in GROUP BY clause? There must be an important reason behind it.

  Read the article

• Is it possible to specify a SQL Server schema name in a Rails ActiveRecord migration?

  - by Brian Sullivan

  The current convention where I work is to use SQL Server schemas like namespaces (e.g. Company.Employees, Company.Branches, etc.) Is it possible to get an ActiveRecord migration to use anything other than the default "dbo" schema in SQL Server?

  Read the article

• How to read data from SQL database and store it into an XML file ?

  - by Morano88

  I have a Silverlight application that reads its content from an XML file. User can enter data and It'll be stored in SQL database. How can I read the data from SQL database and store it into an XML file ? Thanks,

  Read the article

• How to know whether a sql Update statement executed successfully or failed ?

  - by Mike108

  How to know whether a sql Update statement executed successfully or failed ? I use sql server 2005.

  Read the article

• What is the difference between login and credential in SQL server 2008?

  - by ebeworld

  I am a bit confused SQL server windows login and credential. On books online, it says that credential can access resources beyond sql server, but as far as i see windows login might be able to do that that since it is mapped to a windows user. Am i missing something else? Thanks, in advance.

  Read the article

• whats best practice for Log Truncation in SQL Server?

  - by kacalapy

  i have a production DB in SQL server and wanted to put the final touches after the functionality is completed. prior to shipping it out i want to make sure i have some clean up in the SQL server DB and truncate and shrink log files? can i have a nightly job run to truncate logs and shrink files? this is what i have so far: ALTER proc [dbo].[UTIL_ShrinkDB_TruncateLog] as -- exec sp_helpfile BACKUP LOG PMIS WITH TRUNCATE_ONLY DBCC SHRINKFILE (PMIS, 1) DBCC SHRINKFILE (PMIS, 1)

  Read the article

< Previous Page | 430 431 432 433 434 435 436 437 438 439 440 441  | Next Page >