Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 270/1278 | < Previous Page | 266 267 268 269 270 271 272 273 274 275 276 277  | Next Page >

• Sql Server string to date conversion

  - by JosephStyons

  I want to convert a string like this: '10/15/2008 10:06:32 PM' into the equivalent DATETIME value in Sql Server. In Oracle, I would say this: TO_DATE('10/15/2008 10:06:32 PM','MM/DD/YYYY HH:MI:SS AM') This question implies that I must parse the string into one of the standard formats, and then convert using one of those codes. That seems ludicrous for such a mundane operation. Is there an easier way?

  Read the article

• INNER JOIN Returns Too Many Results

  - by Alon

  I have the following SQL: SELECT * FROM [Database].dbo.[TagsPerItem] INNER JOIN [Database].dbo.[Tag] ON [Tag].Id = [TagsPerItem].TagId WHERE [Tag].Name IN ('home', 'car') and it returns: Id TagId ItemId ItemTable Id Name SiteId 1 1 1 Content 1 home 1 2 1 2 Content 1 home 1 3 1 3 Content 1 home 1 4 2 4 Content 2 car 1 5 2 5 Content 2 car 1 6 2 12 Content 2 car 1 instead of just two records, which these names are "home" and "car". How can I fix it? Thanks.

  Read the article

• change string in mssql to abbreviate

  - by jeff

  How do I return the everything in a string from a sql query before a certain character? My data looks like this: HD TV HM45VM - HDTV widescreen television set with 45" lcd I want to limit or truncate the string to include everything before the dash. So the final result would be "HD TV HM45VM"

  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

• How to migrate the Access database to MOSS 2007 sql server with the use of SSMA (sql server migratio

  - by pointlesspolitics

  Hi, One of my friends got the access database with Forms (VBA) and wish to migrate all the database table to the newly installed MOSS 2007 site. He is using SSMI for this purpose. He cannot do it because there are plenty of errors and warnings. I think it is due to the old Access queries. Is there any other way to import the database to sql 2005 from access ? Thanks

  Read the article

• How Can I do this??

  - by ramadan2050

  I have a table records(ID, ParentID) containg this data ID ParentID 1 null 2 1 3 2 3 4 4 5 6 null 7 6 If you draw this table in hierarchy as a family 1,2,3,4,5 will be related to each other. I want to find a way, where I can pass an ID like 3 it give me the others family members using SQL or using C# 3 - result 1,2,4,5 2 - result 1,3,4,5 6 - result 7 and so on I want to find my parent and his parents and childs and my child and his childs LIKE THE EXAMPLES

  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

• sql conditional union on rowcount

  - by Stavros

  I have an SQL function which returns a list of Teams. I want to join an additional list to that list with a union, but only if it returns more than one rows. Something like: CREATE FUNCTION Teams() RETURNS TABLE AS RETURN ( SELECT * FROM TABLE1 UNION if @@rowcount>1 SELECT * FROM TABLE2 end if )

  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

• Converting a certain SQL query into relational algebra

  - by Fumler

  Just doing an assignment for my database course and I just want to double check that I've correctly wrapped my head around relational algebra. The SQL query: SELECT dato, SUM(pris*antall) AS total FROM produkt, ordre WHERE ordre.varenr = produkt.varenr GROUP BY dato HAVING total >= 10000 The relational algebra: stotal >= 10000( ?R(dato, total)( sordre.varenr = produkt.varenr( datoISUM(pris*antall(produkt x ordre)))) Is this the correct way of doing it?

  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

• 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

• 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 query Error: Operand should contain 1 column(s) in rails

  - by dombesz

  Hi everyone, SELECT * FROM jobs WHERE (SELECT DISTINCT jobs.* FROM jobs, job_requests WHERE (jobs.user_id = 1) OR (job_requests.user_id = 1 AND job_requests.job_id = jobs.id)) This sql gives me Mysql::Error: Operand should contain 1 column(s). If i execute the select from the where clause it works SELECT DISTINCT jobs.* FROM jobs, job_requests WHERE (jobs.user_id = 1) OR (job_requests.user_id = 1 AND job_requests.job_id = jobs.id) Could somebody explain me why? This query is generated by rails activerecord so the main select is needed.

  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

• 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

• 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

• 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

• Refactoring SQL

  - by Mongus Pong

  Are there any formal techniques for refactoring SQL similar to this list here that is for code? I am currently working on a massive query for a particular report and I'm sure there's plenty of scope for refactoring here which I'm just stumbling through myself bit by bit.

  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

• 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

• 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

• Generate table relationship diagram from existing schema (SQL Server)

  - by Nick

  Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database or by any other means? This is for SQL Server 2008 Express Edition.

  Read the article

• Insert data into SQL server with best performance

  - by Incognito

  I have an application which intensively uses DB (SQL Server). As it must have high performance I would like to know the fastest way to insert record into DB.Fastest from the standpoint of execution time. What should I use ? As I know the fastest way is to create stored procedure and to call it from code (ADO.NET). Please let me know is there any better way or may be there are is some other practices to increase performance.

  Read the article

< Previous Page | 266 267 268 269 270 271 272 273 274 275 276 277  | Next Page >