Search Results

Search found 28024 results on 1121 pages for 'sql 2014'.

Page 531/1121 | < Previous Page | 527 528 529 530 531 532 533 534 535 536 537 538  | Next Page >

• Easy way to view images in a database

  - by Vaccano

  I have a web service that I just coded up that drops an image (png) into my SQL Server 2008 database as a varbinary. Is there a easy tool out there that can let me see that image? I could code up a client, but I would rather just use a tool if one exists.

  Read the article

• Parse and extract required text from text files using C#

  - by SweetGangster

  I have some text files with some useful data wrapped in between HTML tags like <td>, <span>, etc. I want to write a program which extracts the data in between the tags. The text file contains other junk data too. I would also like to store these extracted data into SQL Table. Anyone who can guide me in right direction?

  Read the article

• SQL Randomization on Daily Basis

  - by mouthpiec

  Hi, I have an SQL listing shops, but i would like to random the results on a daily basis. For example today I list bat 2, 6, 9 etc and tomorrow, 6,1,7,9 etc Is there a way to implement this?

  Read the article

• Proper way to name booleans that are A or B not True False

  - by Hurricanepkt

  I have a field that indicates whether someone wars a commission or a fee. In sql its going to be a bit field. How should I name it?

  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

• Update a column based on a field from another table

  - by Sergio

  Hi: I'd like to update values in one table based on corresponding values from other tables. Say you want to update prices of pieces provided by one specific manufacturer whose name is in the table Manufacturers with the Pieces table containing only the id of the manufacturer. I've seen several solutions for MySQL here and for MS SQL Server here but none of them seems to work in SQLite. Any suggestion?

  Read the article

• Compare Tables in different databases with ADO.Net 3.5

  - by MicMit

  I need to compare tables with the same names in different databases ( Sql Server 2008 ). How using C# code and ADO.Net to identify additions, deletions, updates. Is DataReader going to work in this scenario without stored procedures ? DataReader seems to be suitable for single database connection, or am I missing something ?

  Read the article

• Update is not updating the whole string

  - by Malik

  Following is my SQL fiddle: http://sqlfiddle.com/#!2/f9bae/1 In which i am trying to check if the whole name is being verified by lookup table or not and if there is any error then it should get replaced by the correct value but the problem i am facing is that if any name contains more than one wrong values then query only update one part of that name and leave the rest unchanged , kindly let me know how can i modify my query for update so it'll update the whole name as per lookup table correct values. Thanks,

  Read the article

• Why does MySQL refuse pipe ('|') character in string on INSERT INTO

  - by Manuel Darveau

  If I try this statement: INSERT INTO TerminalEventChild (id,stringValue) VALUES (64,'version123|'); MySQL fail with : Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''version123' at line 1 SQLState: 42000 ErrorCode: 1064 If I remove the | character, everything works fine. Any idea?

  Read the article

• Saving data to a text file and loading it into a datagrid in C#

  - by Kasun

  I need to Pass some data to a text file and save that text file in a SQL Server 2005 database. Then I'll need to be able to load that textfile into a C# WinForms DataGrid. How do I do that in C#?

  Read the article

• how to this query in right syntax or right way??

  - by MZT

  i write this query using t-sql and give me an error (Incorrect syntax near the keyword 'OR') How to write it in correct way ? SELECT SUM(Quantity) FROM Invoices WHERE Invoices.InvoiceDocStatusID = CASE @InventoryType WHEN 1 THEN ((2)OR(1)) ELSE 2 END

  Read the article

• To store and search word documents using C#.NET,ASP.NET

  - by GayaMani

  i want to store a word documents (.doc) in the database and i need to provide search over a collection of Word documents and highlight the words too. I m using VS2005 -- ASP.NET, C#.NET, SQL Server.

  Read the article

• Move row from one table to another?

  - by lance

  I have two tables with the same column definitions. I need to move (not copy) a row from one table to another. Before I go off and use INSERT INTO/DELETE (in a transaction), is there a smarter way? SQL Server 2005

  Read the article

• How to calculate

  - by Bob

  Hi, I hv a table like this :- Item Qty Price A Price B abc 5 36.00 0 qwe 8 0 48.00 zxc 6 12.00 0 poi 4 10.00 0 lkj 9 12.00 0 mnb 3 0 14.00 vfr 7 0 6.00 How can I sum the value using SQL ie. if Price A is zero, it will pick Price B. The expected results will be as follows :- Item Value abc 180.00 qwe 384.00 zxc 72.00 poi 40.00 lkj 36.00 mnb 42.00 vfr 42.00

  Read the article

• accessing SQL syntax reference in mysql workbench

  - by dcompiled

  Finding it a little bit tedious migrating to the new Mysql Workbench (5.2.22) even though it has many more features than the older GUI tools. Right now I'm confused why I can't find an SQL reference when I open the Doc Library. Is there a way to access this info within the workbench, I'd prefer not to have to open a browser to access reference info on the web.

  Read the article

• Where binary in SQL

  - by fire

  I have an SQL statement: SELECT * FROM customers WHERE BINARY login='xxx' AND password='yyyy' There are no blob/binary fields in the table, do I need the BINARY after the WHERE what else does it do?

  Read the article

• getschema("foreignkeys") against SqlClient doesn't yield enough information

  - by csells

  I need two tables and two sets of fields, not the name of the foreign key and one of the table names. Does anyone know how to query SQL Server for complete foreign key information? Thanks!

  Read the article

• Repository Pattern: SaveOrUpdate() in Entity Framework and L2S

  - by JMSA

  These web articles uses separate Save() and Update() methods in the repository pattern. I am using repository pattern. How can I write a SaveOrUpdate() method in Entity Framework with the help of ObjectContext and in Linq-To-SQL with the help of DataContext? That is, how can I write a single method that shall do both save and update job?

  Read the article

• Mysql syntax help

  - by Karthick

  Query: select t1.col1 from table1 t1 inner join with (nolock) table2 t2 on t1.col2 = t2.col1 Am trying to use nolock option for optimized query in mySQL db, but for some reason the above query does not work and the error i receive is You have an error in your SQL syntax; Any thoughts?

  Read the article

• how to specify literal value in linq union

  - by lowlyintern

  I have the following SQL query, note I want the literal value '0' in the second field in the second SELECT statement from the ItemSale table. How do I express this in LINQ? I get the error message 'Invalid anonymous type member declarator'. SELECT BranchNumber,QuantitySold FROM Department UNION SELECT BranchNumber,0 FROM ItemSale How to express the '0' in LINQ? var unionQuery = (from dept in Department select new { dept.BranchNumber, dept.QuantitySold, }) .Concat(from item in ItemSale select new { item.BranchNumber, 0 });

  Read the article

• How to show 0 when no row found

  - by user1685991

  I have a SQL query in which I am passing sysdate to the query problem is that when there is no matching date in table with sysdate then it don't shows the zero even if there is nvl applied here is my query select * from molasses where trunc(trn_dte) = trunc(sysdate) But it show data only when current date is present in table but I want to show zero if no data found in table.please help me to do this in oracle 10 g. Because some times the situation is like above and I have to display zero when no data found

  Read the article

• Variables to input in file name for Reporting Services subscriptions

  - by kd7iwp

  Is there a list anywhere that lists all the variables I can use in file names for report subscriptions from within SQL Server Management Studio? I currently use @timestamp in my file names, but would like to use other options or even remove parts of the time stamp (for example, just use the date, not the time).

  Read the article

• PHPpgAdmin: How delete rows without using SQL

  - by xRobot

  In PHPmyAdmin I can delete rows without using SQL. Is there a way to do this in PHPpgAdmin ?

  Read the article

• Transforming OLTP Relational Database to Data Warehousing Model

  - by Russ Cam

  What are the common design approaches taken in loading data from a typical Entity-Relationship OLTP database model into a Kimball star schema Data Warehouse/Marts model? Do you use a staging area to perform the transformation and then load into the warehouse? How do you link data between the warehouse and the OLTP database? Where/How do you manage the transformation process - in the database as sprocs, dts/ssis packages, or SQL from application code?

  Read the article

• PL/SQL ANONYMOUS BLOCK REQUIRED

  - by aryan

  I HAVE TO RETRIEVE ID AND LAST_NAME FROM MY TABLE BUT THE THING IS THAT MY ID IS NOT CONTINUOUS AND THERE NO PATTERN FOR THE GAPS. NOW I WANT TO WRITE A PL/SQL ANONYMOUS BLOCK FOR THIS.

  Read the article

< Previous Page | 527 528 529 530 531 532 533 534 535 536 537 538  | Next Page >