Search Results

Search found 32117 results on 1285 pages for 'sql wait stats'.

Page 535/1285 | < Previous Page | 531 532 533 534 535 536 537 538 539 540 541 542  | Next Page >

• 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

• Looking for open sourced BI (My Sql)

  - by fatnjazzy

  Hi, I know that there are few open sourced / Free BI projects and I am looking recommendations. I have a growing Mysql database that i got tired from writing sql queries + gui + filtering over and over again. if i am not able to find a free one than my budget will be: (1$ - 2500$ ) My needs are: Mysql 5 Connection. user permissions export options Basic Dashboard -- nice to have: Web Based GUI Development framework integration in PHP

  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

• Comparing XML in SSRS

  - by silves89

  I'm new to SSRS. We'll have two slightly different chunks of XML in a single row of an SQL Server database table. In an SSRS report we'll want to show only the differences between the XML chunks. I don't know how to do this, but I suspect the XML Type in SQLServer 2005 might be useful, or XSLT transformations in SSRS. Could anyone point me in the right direction?

  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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• how to generate primary key values while inserting data into table through pl/sql stored procedure

  - by thulasi policherla

  hi friends, I am trying to insert data into particular table through pl/sql stored procedure,my requirement is while inserting i should generate PRIMARY KEY values for particular column and also i should return that PRIMARY KEY value to output and one more thing is that for another column i should validate my string such that it should contain only characters not integers. please help me in writing code for the above requirement Thanks and regards thulasi policherla

  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

• Where can I get 64 bit OLEDB and/or ADO.Net drivers for Sybase ASE?

  - by Craig

  I'm new to Sybase and so far it's a monumental pain just to connect to it! Where in the world can I get 64 bit drivers for Sybase ASE 15 so that I can connect from my 64 bit SQL 2008? Our Sybase servers are 32 bit and there are no 64 bit drivers on the media :(

  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

• What is the best approach using JDBC for parameterizing an IN clause?

  - by Uri

  Say that I have a query of the form SELECT * FROM MYTABLE WHERE MYCOL in (?) And I want to parameterize the arguments to in. Is there a straightforward way to do this in Java with JDBC, in a way that could work on multiple databases without modifying the SQL itself? The closest question I've found had to do with C#, I'm wondering if there is something different for Java/JDBC.

  Read the article

< Previous Page | 531 532 533 534 535 536 537 538 539 540 541 542  | Next Page >