Search Results

Search found 27497 results on 1100 pages for 'sql joke'.

Page 517/1100 | < Previous Page | 513 514 515 516 517 518 519 520 521 522 523 524  | Next Page >

• Table lock after integrity maintanence completion

  - by bdhar

  I am using SQL Server 2000. I have a database with n number of tables in it. I have configured a maintenance plan. If I enable integrity check and run the plan, I am not able to enter any data through VC++/ADO. Is there anything I have to check?

  Read the article

• mysql procedure to update numeric reference in previous rows when one is updated

  - by markcial

  There's a table like this one ______________________ | id | title | order | |----------------------| | 1 | test1 | 1 | |-----|--------|-------| | 2 | test2 | 2 | |-----|--------|-------| | 3 | test3 | 3 | |-----|--------|-------| | 4 | test4 | 4 | '----------------------' when i introduce in my mysql shell a single update to a row $sql UPDATE `table` SET order=1 WHERE id=3; And then procedure or method resamples order column in the before update lower values to get its order renewed like this ______________________ | id | title | order | |----------------------| | 1 | test1 | 2 | |-----|--------|-------| | 2 | test2 | 3 | |-----|--------|-------| | 3 | test3 | 1 | |-----|--------|-------| | 4 | test4 | 4 | '----------------------' Any help would be appreciated, thanks!

  Read the article

• Invalid authorization specification error with Classic ASP accessing MSSQL DB

  - by Scott

  Hi, I am getting the following error: Invalid authorization specification I've narrowed down the error to my connection string. I have verified the server name, database, user & password are correct. Here is the string: "Provider=SQLOLEDB;Server=xxxxx.db.12345.hostedresource.com;Database=foo;UID=fooUser;PWD=fooPW" The SQL server is hosted on Godaddy so I don't have access to its settings. Please help, I've scoured the internet for a solution!

  Read the article

• Why does my count(*) query time out but the inline view whose records it is counting does not?

  - by RenderIn

  Can't figure this one out... when I execute a select query it shows an explain plan cost of ~4500 and takes ~3 seconds to return. When I wrap that query (no changes) inside of: select count(*) from ( /*query here*/ ) It times out. It's at 5 minutes and counting now. I tried this in SQL Developer and Aqua Data Studio -- same results.

  Read the article

• SSIS 2005 - How to figure out what job a sysdtslog90 entry was run under?

  - by GordyII

  Given a entry in a sysdtslog90 table in SQL Server 2005 from an SSIS package, how do you figure out what database agent job the entry was run under?

  Read the article

• capturing user IP address information for audit

  - by Samuel

  We have a requirement to log IP address information of all users who use a certain web application based on JEE 5. What would be an appropriate sql data type for storing IPv4 or IPv6 addressses in the following supported databases (h2, mysql, oracle). There is also a need to filter activity from certain IP addresses. Should I just treat the representation as a string field (say varchar(32) to hold ipv4, ipv6 addresses)

  Read the article

• How to disable sql creation for JPA entity classes

  - by Samuel

  We have some JPA entity classes which are currently under development and wouldn't want them as part of the testing cycle. We tried commenting out the relevant entity classes in META-INF\persistence.xml but the hbm2ddl reverse engineering tool still seems to generate SQL for those entities. How do I tell my code to ignore these classes? Are there any annotations for these or should I have to comment out the @Entity annotation along with my changes in persistence.xml file.

  Read the article

• SQL Server 2005 Convert Ascii to Unicode (UTF-8 -> nvarchar)

  - by Guazz

  I have data in an nvarchar field with data in ascii format: "Zard Frères Guesta" How do I convert it to a readable(unicode) format in t-sql?

  Read the article

• How do I select distinct rows where a column may have a number of the same values but all their 2nd

  - by Martin Rose

  I have a table in the form: test_name| test_result | test1 | pass | test2 | fail | test1 | pass | test1 | pass | test2 | pass | test1 | pass | test3 | pass | test3 | fail | test3 | pass | As you can see all test1's pass while test2's and test3's have both passes and fails. Is there a SQL statement that I can use to return the distinct names of the tests that only pass? E.g. test1

  Read the article

• Does anyone use the PL/SQL Web Toolkit?

  - by colinjameswebb

  Does anyone use the PL/SQL Web Toolkit at all? We use it for internal reporting where I work. However, does anyone have any experiences of it for producing client-facing websites? General advantages/disadvantages compared to other web languages, such as JSP, PHP etc

  Read the article

• Linq to SQL - Returning two values with one query

  - by Sir Psycho

  Hi, Is it possible to return a single value and an enumerable collection using LINQ to SQL? The problem is, I'm trying to do paging across a large recordset. I only want to return 10 rows at a time so I'm using .Skip(20).Take(10) approach. However I need to know the total number of records so I can show an appropriate page x of y. Trying to avoid two separate queries. Thanks

  Read the article

• php file for connecting the iphone to server

  - by alecnash

  Need to create a php file so I can send data to an sql server and get data from the server. There must also be a json support because I am doing this for an iphone app. Could you please help me and give me a source code example. Thanks in advance.

  Read the article

• MySQL and SQLite differences in SQL

  - by Darth

  I'm writing java application that is using both SQLite and MySQL using JDBC. Are there any differences in SQL for those databases? Can I use same queries for both SQLite and MySQL, or is there any db specific stuff, that doesn't work on the other one? As far I've worked only with MySQL, so I don't really know much about SQLite.

  Read the article

• Sql Select Query Question. Merge Rows

  - by Jono

  I have a single MYSQL Question and need help ASAP. Database: Email | Name | Tag [email protected] |Test Person | TagOne [email protected] |Test Person | Tag Two Need an SQL query that will return Email | Name | Tag [email protected] |Test Person | TagOne, Tag Two Any help?

  Read the article

• Mysql Avg function for recent 15 records by date (order date desc) in every symbol

  - by venkatesh

  i am trying to create a statement in sql (for a table which holds stock symbols and price on specified date) with avg of 5 day price and avg of 15 days price for each symbol. table description: symbol open high close date the average price is calculated from last 5 days and last 15 days. i tried this for getting 1 symbol: SELECT avg(close), avg(`trd_qty`) FROM (select * from cashmarket WHERE symbol = \'hdil\' order by `M_day` desc limit 0,15 ) s ...but I couldn't get the desired the list for showing avg values for all symbols.

  Read the article

• Saving formatted text from richtextbox

  - by phenevo

  Hi, Is there any way, to save formatted in database from richtextbox? I've got richtextbox and some parts of text in this are bold. string s=richtextbox.Text obviously doesn't work. And If I can get this formatted text how to save it in Ms Sql Server 2005 ?

  Read the article

• Order By Problem T-Sql

  - by Nick LaMarca

  I have a sql statement I am using a simple sort such as the following Select numbers From theTable Order By numbers What I get in return is the following 1 11 12 14 2 21 22 23 3 35 37 etc... I want it to be ordered in normal order 1 2 3 4 5 6 etc...

  Read the article

• Convert historic dates from utc to local time

  - by Espo

  I have an sql table with data like this: | theDate (datetime) | theValue (int) | ---------------------------------------- | 2010-05-17 02:21:10 | 5 | | 2009-03-12 04:11:35 | 23 | | 2010-02-19 18:16:53 | 52 | | 2008-07-07 22:54:11 | 30 | The dates are stored in UTC format in a datetime column, how can I convert them to local time (Norway)? Remember that the UTC-offset is not the same all year because of winter/summer-time.

  Read the article

• Native XML WebService Without Authentication

  - by tom

  So this my first question here, let's look how it works. I'm working on a project, which has to to provide a "Native XML WebService" on a SQL Server 2005. The web service and the WSDL generation works fine. But there are troubles with the authentication. Is it possible to turn the authentication off (The tests and the documentation by Microsoft say no.)? And if so how?

  Read the article

• What is the best way to determine if table already has record with specific ID?

  - by iburlakov

  Hello. I have a short question. Im my current project I'm using LINQ-to-SQl. That is the best way to determine if table has record with specific ID? Thanks in advance.

  Read the article

• Transitioning from php to python/pylons/SQLAlchemy -- Are ORMs the standard now?

  - by EmpireJones

  Should I invest a lot of time trying to figure out an ORM style implementation, or is it still common to just stick with standard SQL queries in python/pylons/sqlalchemy?

  Read the article

• Can DataObjects.NET support SQL identity columns?

  - by Mark

  While there's lots to like about DataObjects.NET, I've found help resources to be a lean, and can't find a solit example of using DataObjects.NET with RDBMS generated primary keys. It would seem as though D4O won't do inserts against SQL Server unless it's in controll of the key. Has anyone solved this in the wild?

  Read the article

• Select distinct values from multiple columns

  - by nuhusky2003

  I had a table (Some_Table) with two columns: A B ------------------- 1 test 2 test 3 test1 4 test1 i would like to return DISTINCT values for column B and it's associated value in column A (first in distinct set), so something like this: A B ----------- 1 test 3 test1 What is the sql?

  Read the article

• crystal report Vs microsoft sql server reporting service

  - by DATT OZA

  hello, i am developing wpf application.. i need your suggestions. i have to make reports in my application... so which one is best, by crystal report or by using sql server reporting service.. friends what you say ? give ur suggestion which one is best and why ???

  Read the article

• cannot access sql server after publishing site in iis7

  - by vinu

  I am created a website using visual studio 2010. On the time of the development of website I am able to access the database.. but after publishing the site using IIS7..i was unable to access the database..the exception occured during that time was "the connection is in the closed state".in IIS7 When I changed the application pool identity to localsystem, it worked. Data base is installed in the same machine. and server is SQL SERVER 2008 R2

  Read the article

< Previous Page | 513 514 515 516 517 518 519 520 521 522 523 524  | Next Page >