Search Results

Search found 43986 results on 1760 pages for 'sql session state'.

Page 298/1760 | < Previous Page | 294 295 296 297 298 299 300 301 302 303 304 305  | Next Page >

• PL/SQL time segment calculation

  - by Steve

  Hi, I need to figure how much time passed between 2 times. For example: (14:00:00 - 13:15:00) * 24 = .75 I need this to later on convert KW to KWh, but that's not the point. I can not find out how to do this in PL/SQL. My date/time fields look like this in the DB: 1/23/2010 21:00:00 I would appreciate any suggestions. Steve

  Read the article

• Online validators, syntax checkers, testing tools (SQL, VB.NET, C#)

  - by Max Gontar

  I often need to verify some simple code before posting, and it's great if I have installed IDE, but what if not? It would be nice to have online free tools for SQL, VB.NET, C# code validation, or maybe even testing. EDIT What I actually mean are online live web tools, like JSLint for javascript. Have you seen any? Thanks!

  Read the article

• MS SQL and Indentity column

  - by andrew007

  Hi, I just noticed that if I have an identity column in a table, when I insert new rows MS SQL 2008 is automatically filling up the sequence if there are discontinuity. I mean, if in my identity column I have 1,2,5,6 if I insert other two rows in the table the system puts automatically 3,7 in the identity column. Do you know how to control this behavior? THANKS

  Read the article

• Does MySql have Server Management Objects equivalent to MSSql?

  - by dboarman-FissureStudios

  I am looking for resources and references for a MySql equivalent to MSSql SMO. Also, is SMO the newest technology for programmatic management of Sql server?

  Read the article

• Long time to load first sql connection in C# .NET

  - by Shrage Smilowitz

  For some reason it takes 7 seconds to open a connection to a sql server database for the firt time, subsequent connections takes a second. any idea what could be the reason? I'm using C# and asp.net

  Read the article

• SQL Server hosting

  - by user182945

  Do you know any cheap SQL Server 2008 hosting service. (I need to host a db that is going to be < 100 MB)?

  Read the article

• SQL Server: how can I know my stored procedure is optimum in performance

  - by RedsDevils

  Hi all, I would like to know how to measure/know that one's stored procedure is optimum in performance. That stored procedure can be inserting/deleting/updating or manipulating data in that procedure. Please describe the way/approach how to know performance in SQL Server. Thanks in advance!

  Read the article

• Can Entity Framework model be passed a SQL script to be run against the database

  - by Greg

  Is it possible to pass a SQL script to some method that Entity Framework has to run it against my model? e.g. equivalent of: context.ExecuteStoreCommand(<tsql script path>); Background: I want a way to reset the database during unit tests, and making a call to run the EF generated TSQL script (from Generate Database from Model) seems one way to achieve this.

  Read the article

• Get tree representation from t-sql stored procedure

  - by alex

  Hi, I want to get tree representation answer from my t-sql stored procedure. How can I do it ? Does .NET have a predefined types for working with xml-answers from stored procedures ?

  Read the article

• sql to compare two strings in MS access

  - by tksy

  I am trying to compare a series of strings like the following rodeo rodas carrot crate GLX GLX 1.1 GLX glxs the comparision need not be case sensitive i am trying to write a sql where i am updating the first string with the second string if they match approximately. Here except the second string all the other examples match. I would like to write a query which updates the strings except the second one. is this possible directly in a query in ACCESS thanks

  Read the article

• SQL Job: CmdExec with Multiple Arguments

  - by Vilasack Phothisan

  Is it possible to specify two arguments to CmdExec in SQL JOb Step? I have MyApp.exe Para1 Para2 but it only recognize para1.

  Read the article

• Suggestions on documentation of a DB model when using Entity Framework 4

  - by Junior Ewing

  Any experiences on how to document Entity Framework 4 based Database projects? There is the Document and Summary properties on the Entities, but if we want to regenerate the model from the database at some point, it will be lost! Is there some way to map documentation data inside SQL to the Entities in the EDMX file so it is safe. Suggestions of other best practices? Ideally I want to be able to augo generate html/helpfile documentation from the DB when we deploy.

  Read the article

• How to make a trasanction cover several stored procedure ?

  - by Bitnius

  I need to include several stored procedure in a single transaction in a single database, if any of stored procedure fail then roll back transaction of all stored procedure procesed in the scope. I work with SQL-SERVER 2008

  Read the article

• removing duplicates from table without using temporary table

  - by jest

  hi! I've a table(TableA) with contents like this: Col1 ----- A B B B C C D i want to remove just the duplicate values without using temporary table in Microsoft SQL Server. can anyone help me? the final table should look like this: Col1 ----- A B C D thanks :)

  Read the article

• Composite keys as Foreign Key?

  - by paulio

  I have the following table... TABLE: Accounts ID (int, PK, Identity) AccountType (int, PK) Username (varchar) Password (varchar) I have created a composite key out of ID and AccountType columns so that people can have the same username/password but different AccountTypes. Does this mean that for each foreign table that I try and link to I'll have to create two columns? I’m using SQL Server 2008

  Read the article

• Write a plugin/form for SQL server enterprise manager

  - by Daniil

  Is it possible to write a plugin or a form for SQL Server Enterprise Manager version 8? I'm doing some simple queries all the time to admin the databases. So wondering if I could write something for it.

  Read the article

• Use Tablediff to compare all tables

  - by Davie

  Hi, I have recently discovered the tablediff utility of SQL Server 2005. I have 2 instances of the same database each on a different server. Is it possible to compare all tables using tablediff without having to replicate the same command while only changing the table name? For example, compare table1 on server1 with table1 on server2 then compare table2 on server1 with table2 on server2, until all tables have been compared.

  Read the article

• Storing unicode strings to SQL Server via ActiveRecord

  - by ripper234

  I am using Castle ActiveRecord as my ORM. When I try to store unicode strings, I get question marks instead. Saving unicode strings worked perfectly when I was using mysql, but when I recently switch to SQL Server it broke. How should I go about fixing this?

  Read the article

• sql inner join problem

  - by Luke

  The following SQL query isn't working. I think the error is on the first line. SELECT SUBSTRING(tbl_news.comment, 1, 250) as tbl_news.comment, tbl_news.id, tbl_news.date, tbl_news.subject, tbl_users.username FROM tbl_news INNER JOIN tbl_users ON tbl_news.creator = tbl_users.id ORDER BY date DESC

  Read the article

• How do I accurately handle a batch seperator for SQL from C#

  - by Sam Saffron

  For Data Explorer I would like to add support for a Batch separator. So for example if users type in: select 'GO' go select 1 as go Go select 100 I would like to return the three result sets. Its clear that I need some sort of parser here, my hope is that this is a solved problem and I can just plug it in. (writing a full T-SQL parser is not something I would like to do) What component / demo code could achieve splitting this batch into its 3 parts?

  Read the article

• SQL table relationship not showing up in visual studio

  - by PFranchise

  Hey, I made several tables and relationships using SQL server manager. I then imported them to visual studio and it all appeared in the correct form, except one of the relationships did not appear. I have checked everything I could think of and it is the exact same as the other relationships. If you know anything I can check, I would appreciate it. Thanks I am using the entity framework, visual studio 2010.

  Read the article

• LINQ to SQL entity and data-context classes: business object encapsulation

  - by roosteronacid

  What are your favorite ways to encapsulate LINQ to SQL entity classes and data-context classes into business objects? What have you found to work in a given situation? Have you invented or taken to any specific patterns?

  Read the article

• Upload a file to sql database with delphi and after download

  - by Rapunzo

  I am working to make a basic file database, but I couldn't find the true codes. Can anyone help me to save an exe file to sql database after read, download and use when I need it? With Delphi

  Read the article

• Is PDO for SQL Server support query contain Link Server

  - by Permana

  Is PDO for SQL Server support query contain Link Server ? I try using mssql_connect but it didn't work. I have try PDO but it alwas return error on query() method.

  Read the article

• Display sql results in groups

  - by ktsixit

  Hi all, I have an sql query here and it returns a number of results. I'd like to show these results in groups. What I mean is, show the first 20 results in some part of the page, show the next 20 results in another part of the page etc... How can I do that?

  Read the article

< Previous Page | 294 295 296 297 298 299 300 301 302 303 304 305  | Next Page >