Search Results

Search found 40744 results on 1630 pages for 'sql interview questions a'.

Page 275/1630 | < Previous Page | 271 272 273 274 275 276 277 278 279 280 281 282  | Next Page >

• How to format TSQL SELECT output in SQL Sever

  - by mohamadreza

  How to loop through a select statement results to have a formatted text? for example the select is like: select name from table and we want a variable @names like this: "name1,name2,name3" Database is SQL Server 2005

  Read the article

• Basic SQL Select in Postgresql fails

  - by Rhubarb

  I am doing a select * on a postgresql table, and everything looks good. But if I do: SELECT Name from People It says: ERROR: column People.Name does not exist SQL state: 42703 Character: 8 But the name column shows up during select *. I've tried: SELECT People.Name from People as well, with the same result. Am I missing something? It should be pretty easy to do this in any other database.

  Read the article

• microsoft sql server management studio Incorrect syntax near '|'

  - by user3679099

  SELECT IPD.Task_grp "Task Group", TASK.STARTW "Starting Area", TASK.ENDW "Destination Area", IPD.Nxt_Work_Grp,IPD.Nxt_Work_Area "Drop Area", IPD.Prty "Priority", IPD.Stat_Code "Status" FROM int_path_defn IPD, (SELECT start_curr_work_grp || start_curr_work_area StartW, start_dest_work_grp ||start_dest_work_area EndW FROM task_hdr WHERE task_id='332800') TASK WHERE IPD.CURR_WORK_GRP || IPD.Curr_Work_Area=TASK.StartW AND IPD.Dest_Work_Grp || IPD.Dest_Work_Area=TASK.ENDW I am getting Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '|'. Please help what could be the wrong. same query executed successfully in oracle sql developer

  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

• 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

• XQuery performance in SQL Server

  - by Carl Hörberg

  Why does this quite simple xquery takes 10min to execute in sql server (the 2mb xml document stored in one column) compared to 14 seconds when using oxygen/file based querying? SELECT model.query('declare default element namespace "http://www.sbml.org/sbml/level2"; for $all_species in //species, $all_reactions in //reaction where data($all_species/@compartment)="plasma_membrane" and $all_reactions/listOfReactants/speciesReference/@species=$all_species/@id return <result>{data($all_species/@id)}</result>') from sbml;

  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 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

• 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

• 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

• 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

• 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

• 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

• SQL Server 2005 Performance Dashboard Missing Index

  - by n8wrl

  I am using the performance dashboard with our SQL Server 2005 databases and it lists what it considers to be missing indexes. But some of those indexes DO exist! They are not disabled, and they are defined exactly as the dashboard says they should be. Why are they reported as missing?

  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

• 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

• 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

• 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

• 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

• 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 case that will use a current table

  - by Dana Ezer

  I have an sql statement that returns this result below,and I want that the num will drag the latest(by date) num that is not null. I can't get it right. I want to add somthing like this: case when num is null then max(num where date<my_date) my result now: Date num 1.1 0 2.1 1 3.1 NULL 4.1 NULL 5.1 4 what I want: Date num 1.1 0 2.1 1 3.1 1 4.1 1 5.1 4

  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

< Previous Page | 271 272 273 274 275 276 277 278 279 280 281 282  | Next Page >