Search Results

Search found 37012 results on 1481 pages for 'sql query'.

Page 474/1481 | < Previous Page | 470 471 472 473 474 475 476 477 478 479 480 481  | Next Page >

• How to change this mysql select into sql server select statement?

  - by Pandiya Chendur

  I use this mysql statement for concating description which has a length greater than 30.. select if (CHAR_LENGTH(description)>30,CONCAT(SUBSTRING(description,1,30), '.....'),description) as description from table How to change this mysql select into sql server select statement?

  Read the article

• Where to find an SQL database for medical information?

  - by iamrohitbanga

  Where can I find sample data of medical information? Data on medicines, diseases, etc. and preferably in a format easy to import into an SQL database.

  Read the article

• Does SQL Server have any kind of magic undo feature?

  - by Andrew G. Johnson

  Long story short is I tried to quickly update a single row in SQL Server using the Management studio and just typed UPDATE table SET column='value' and forgot the WHERE other_column='other_value' portion. Went for lunch, came back and theres 15 unread emails waiting for me. Happened about an hour ago, waiting for the database guy to come back to see when the last backup was. There's no magic UNDO feature though is there?

  Read the article

• Eclipse Galileo SQL Editor: is there a code formatter (tidy) function?

  - by Jason Tholstrup

  I do like the SQL editor now bundled with Eclipse but I can't seem to find a way for it to format my code like eclipse will with my java. Did I miss something, or does anybody have any alternatives? Thanks ====EDIT==== I'd also be happy if there was an alternate plug-in that someone could recommend.

  Read the article

• How to use Linq To Sql to get Users who has less than 2 photos?

  - by Mike108

  The scenario is I want to get the users who has less than 2 photos. There are two table: [Users] (UserId, UserName) [UserPhotos] (PhotoId, PhotoName, UserId) UserId is a Foreign Key but I do not want to use association like user.Photos. A user may have none photo in the [UserPhotos] table. How to use Linq To Sql to get List<User> who has less than 2 photos?

  Read the article

• In SQL Server, how to quickly get a general idea of an instance?

  - by Yousui

  Hi guys, If you are a new sql server dba and you just get an account of an instance. What would you do to know the instance and databases? How to quick get a general idea of this instance and databases? Great thanks.

  Read the article

• In SQL Server, how do I know what transaction mode I'm currently using?

  - by Yousui

  Hi guys, In SQL Server, how do I know what transaction mode I'm currently using? Such as autocommit, explicit, or implicit. And how can I change one mode to another using tsql? Great thanks.

  Read the article

• List of SQL Server errors that should be retried?

  - by Christopher

  Is there a concise list of SQL Server stored procedure errors that make sense to automatically retry? Obviously, retrying a "login failed" error doesn't make sense, but retrying "timeout" does. I'm thinking it might be easier to specify which errors to retry than to specify which errors not to retry. So, besides "timeout" errors, what other errors would be good candidates for automatic retrying? Thanks!

  Read the article

• Would server traffic software (something like Piwik or Google) make a good case for using No SQL?

  - by Scott Faisal

  We are trying to develop a company specific tracking software but not interested in Google or Piwik. Essentially we would have a JavaScript tracking code also. The data that it would capture, would that be best suited for traditional RDMS or can we get a NO SQL solution ? Any thoughts or ideas welcome.

  Read the article

• what the IIS featuer need to install or change in pc have windows 7 home to work sql server 2005 ss

  - by bassam

  what the IIS featuer need to install in pc have windows 7 home to work sql server 2005 (32 bit) ssrs not work i change all windows featuer in the PC what i need to install in pc

  Read the article

• SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !

  - by anilkumarn

  Once i run this query, getting the following error. please help. select OrderDetails.Sku,orderdetails.mf_item_number,orderdetails.Qty,orderdetails.Price,Supplier.SupplierId, Supplier.SupplierName,Supplier.DropShipFees, cost = (Select Supplier_Item.Price from Supplier_Item,orderdetails,Supplier where Supplier_Item.SKU=OrderDetails.Sku and Supplier_Item.SupplierId=Supplier.SupplierID ) from orderdetails,Supplier,Group_Master where invoiceid='339740' and OrderDetails.Mfr_ID = Supplier.SupplierId and Group_Master.Sku = OrderDetails.Sku Msg 512, Level 16, State 1, Line 2 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , , = or when the subquery is used as an expression.

  Read the article

• Command line Script for cleaning VS project + backing up SQL + zipping??

  - by tbone

  Does anyone happen to have some sort of a nice command line script they use that could do something like: Clean VS project (delete \bin folder contents, etc) Backup SQL Server database Zip all files up

  Read the article

• SQL: Is there a more efficient way to calculate elapsed hours, minutes, seconds?

  - by hamlin11

  I'm using Computed Columns to provide me with the following information: Hours, Minutes, and Seconds between a Start DateTime and Finish DateTime (Where Minutes and Seconds are between 0 and 59 and Hours can be any value 0 or greater) Computed Column for Seconds: datediff(second,[Start],[Finish]) % 60 Computed Column for Minutes: floor(datediff(second,[Start],[Finish]) / 60.0) % 60 Computed Column for Hours: floor(datediff(second,[Start],[Finish]) / 3600.0) Here's the table for reference Note: I'm also calculating TotalElapsedSeconds, TotalElapsedMinutes, and TotalElapsedHours in other computed columns, but those are easy. I just feel like I might be missing out on a nice built in function in SQL.

  Read the article

• Visual Studio 2010's SQL Schema & Data Compare - Can it be accesed from code?

  - by RichardJohnn

  The other day I tried out VS2010's SQL compare tools and thought they were awesome. I am wondering if there is any way to harness these tools in code written in VS 2010.

  Read the article

• How can I handle emailed job control files for SQL Server?

  - by ganesh

  How can I detect control files from any mailbox, scan that file, decrypt it and queue it as a job using job manager in SQL Server?

  Read the article

• Is it possible to use SQL XML to insert, and get output from each record?

  - by nbolton

  I would like to perform a SQL XML insert (on MSSQL), and in this case I need to insert a list of files into the DB (this is simple enough). However, there's an auto generated PK column (ID), and I need the ID for each newly created filename without performing a 2nd query. Is this possible? I guess it doesn't matter if the result is/isn't XML, but the input certainly has to be.

  Read the article

• how to determine date when service pack was applied to SQL Server instance?

  - by Oliver

  For an instance of SQL Server 2005/2008, how can one determine the date and time when a service pack was applied to the instance? Is there a system table or view that stores that information?

  Read the article

• which RDBMS or other tool provides good SQL syntax error messages?

  - by zzz

  I use MySQL and it gives no meaningful error messages beyond "syntax wrong close to something or other". This is in sharp contrast to the sort of nice, clear error messages we are used to getting from java compiler and similar. So, are there RDBMS or sql validation tools that provide clearer, meaningful error messages?

  Read the article

• How to install Visual Studio 2008 and MS SQL Server 2008 in Ubuntu ?

  - by Vicheanak

  Hi guys, I would like to install Visual Studio 2008 and MS SQL Server 2008 on Ubuntu OS which I have in my PC, however, I don't know how. May I have some tips please? Thanks.

  Read the article

• Why does SQL Server 2008 suggest I have the primary key column as an included column in an index

  - by Raine

  SQL Server 2008 is telling me to include the Primary Key in an index in the Included Column field. I thought the PK was automagically returned with all indexes?

  Read the article

• How to find size of a data type in pl/sql (oracle 9i)?

  - by Vineet

  hi, I want to find the size of any data type in pl/sql,for eg DECLARE x boolean; I want to find size of like X,is there any function like (sizeof() in C) or any how i can find it.Please let me know!

  Read the article

• Which user account to assign as owner when attaching an SQL Server database?

  - by FreshCode

  This is a simple database security & performance question, but I've always used either a special user (eg. mydbuser), or Windows' built-in NETWORK SECURITY account as the owner when attaching databases to my SQL Server instances. When deploying my database to a production server, is there a specific user I should stick to or avoid? I would think that using an account with a set password could open the database up to a potential security issue.

  Read the article

• Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ?

  - by HotTester

  Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ? Kindly clarify. Thanks.

  Read the article

• What is the correct SQL for a trigger to copy a record to an identical table?

  - by Owen

  I have two tables TABLE1 and TABLE2 with identical structures. I need a trigger to copy a record after insert from TABLE1 to TABLE2. What's the proper SQL for this?

  Read the article

• Where does sql server stores the stored proecdure 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

< Previous Page | 470 471 472 473 474 475 476 477 478 479 480 481  | Next Page >