Search Results

Search found 30085 results on 1204 pages for 'sql trace'.

Page 415/1204 | < Previous Page | 411 412 413 414 415 416 417 418 419 420 421 422  | Next Page >

• how to get time (hh:mm:ss) from sql query ?

  - by Gold

  hi i have Database with date field. i see the time like: 1900-01-01 13:38:00.000 how i can see it like: 13:38 ? (i work on sql server 2008) thank's in advance

  Read the article

• I have a problem saving foriegn text to a SQL Server database table with a nvarchar field.

  - by user307840

  I have a requirement to have a multiline textbox that accepts any text from any language and stores this into the database for later use. I am using Linq with ASP .NET 3.5 with a SQL Server 2005 database. Any/all information you can provide me with is much appreciated :D

  Read the article

• How can this SQL be wrong? What am I not seeing?

  - by ropstah

  Can anybody please spot my error, this should be a legal query in SQL shouldn't it?? Unknown column u.usr_auto_key in the ON clause This is the database schema: User: (usr_auto_key, name, etc...) Setting: (set_auto_key, name etc..) User_Setting: (usr_auto_key, set_auto_key, value) And this is the query... SELECT `u`.`usr_auto_key` AS `u__usr_auto_key`, `s`.`set_auto_key` AS `s__set_auto_key`, `u2`.`usr_auto_key` AS `u2__usr_auto_key`, `u2`.`set_auto_key` AS `u2__set_auto_key`, `u2`.`value` AS `u2__value` FROM `User` `u`, `Setting` `s` LEFT JOIN `User_Setting` `u2` ON `u`.`usr_auto_key` = `u2`.`usr_auto_key` WHERE (`s`.`sct_auto_key` = 1 AND `u`.`usr_auto_key` = 1 AND admin_property is null)

  Read the article

• How do I add a record only if it doesn't already exist in SQL Server?

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't exist in the table yet. How can I do that? Many thanks,

  Read the article

• In SQL, can we always write an inner join statement as a main query and subquery?

  - by Jian Lin

  In SQL, can we always write an inner join statement as a main query and subquery? For example, select * from gifts g where g.giftID in (select giftID from sentGifts); can do a join and show the gifts sent in the sentGifts table, but it won't be able to show the sentTime because that is inside the subquery?

  Read the article

• Do I need to translate (local) in a sql server connection string?

  - by DanDan

  When connecting to sql server, I have the hardcoded string "(local)". Is this a string I need to make available for localisation? ie, does (local) always work no matter the current language settings?

  Read the article

• In SQL Server, how can I execute a piece of tsql against all databases in an instance?

  - by Yousui

  Hi guys, In SQL Server, how can I execute a piece of tsql against all databases in an instance? Great thanks.

  Read the article

• Any DAL generators that will work on .NET 1.1 with SQL CE 3.1?

  - by Schneider

  Are there any DAL generators or ORMs that will work on .NET 1.1 with SQL CE 3.1? This is only for a short lived project, so cost would be an issue

  Read the article

• How do I insert records into 2 SQL tables sharing a dependency when I don't commit until the end?

  - by Cunning Lingus

  I keep finding myself in this situtation: I have an ASP.NEt 2.0 app. I have to insert into 2 tables in SQL. There is a dependency between the tables. I insert a record the first using a transaction. Then I move onto the 2nd table. But, because the first isn't committed yet the second one throws a error.

  Read the article

• SQL Exception: A truncation error was encountered trying to shrink VARCHAR '...' to length x

  - by Tom Brito

  I know really little about sql, can anyone give me a deeper explanation (or references) of what do this exception means? Possible related question: http://stackoverflow.com/questions/1016901/truncate-a-varchar-to-specific-length-in-derby-automatically

  Read the article

• SQL CE, SQLite. What are the differences between them?

  - by acidzombie24

  What is the difference between SQL CE and SQLite? In what situation would i choose one over the other?

  Read the article

• In SQL Server 2008 is there a way to generate a report as to how much space on disk each table takes

  - by Matt

  IN SQL Server 2008 is there a way to generate a report as to how much space on disk each table takes? I can do it one by one by checking the storage properties, but I was wondering if there was a way, maybe even a query to generate such a report.

  Read the article

• How to distinguish between the first and rest for duplicate records using sql ?

  - by Biswanath

  Hi, These are the input table and required output table. Input table ID Name ------------- 1 aaa 1 ababaa 2 bbbbbb 2 bcbcbccbc 2 bcdbcdbbbbb 3 ccccc Output table ID Name Ord ----------------------------- 1 aaa first 1 ababaa rest 2 bbbbbb first 2 bcbcbccbc rest 2 bcdbcdbbbbb rest 3 ccccc first First and Rest is based on the occurrence of an ID field. Is there a way to write a SQL query to achieve this ? P.S. - This question is somewhat similar to what I am looking for.

  Read the article

• Is there any SQL Server database designer software like MySQL workbench?

  - by newbie

  I need to design database for SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• In SQL Server, how can I separate a large number of tsql statement into batches?

  - by Yousui

  Hi guys, In SQL Server, how can I separate a large number of tsql statement into batches? Should I use the GO statement in stored procedures or functions? Should I use the GO statement in explicit transaction management situation(between BEGIN TRANSACTION and ROLLBACK TRANSACTION or COMMIT TRANSACTION)? Are there some best practice about this topic? Great thanks in advance.

  Read the article

• How can I create dates/times and compare them in SQL?

  - by William

  I'm trying to create a BBS using PHP and SQL, and I want to make it so the topic with the most current post is on top of the topic list. what is a easy way to check if one date and time is more current than another?

  Read the article

• PHP: How do I find (Oracle) parameters in a SQL query?

  - by Bartb

  Suppose you have a string: "SELECT * FROM TABLE WHERE column1 = :var1 AND column2 = :var2" Now, how do I get an array with all the variables like so: Array ( [0] => :var1 [1] => :var2 ) I've tried it with PHP's preg_match_all, but I struggle with the regex. $varcount = preg_match_all("/ :.+ /", $sql, $out);

  Read the article

• What SQL query should I perform to get the result set expected?

  - by texai

  What SQL query should I perform to get the result set expected, giving the first element of the chain (2) as input data, or any of them ? table name: changes +----+---------------+---------------+ | id | new_record_id | old_record_id | +----+---------------+---------------+ | 1| 4| 2| | -- non relevant data -- | | 6| 7| 4| | -- non relevant data -- | | 11| 13| 7| | 12| 14| 13| | -- non relevant data -- | | 31| 20| 14| +----+---------------+---------------+ Result set expected: +--+ | 2| | 4| | 7| |13| |14| |20| +--+ I know I should consider change my data model, but: What if I couldn't? Thank you in advance!

  Read the article

• Is there a way to have SQL server validate object references in Stored Procs?

  - by Scott Weinstein

  The following code executes fine in SQL Server create proc IamBrokenAndDontKnowIt as select * from tablewhichdoesnotexist Of course if I try to run it, it fails with Invalid object name 'tablewhichdoesnotexist'. Is there any way to compile or verify that Stored Proc are valid?

  Read the article

• How can I return a substring of a LINESTRING in SQL Server 2008 Spatial?

  - by sabbour

  Say I have a LINESTRING defined as LINESTRING(-122.360 47.656, -122.343 47.656, -122.310 47.690, -122.310 47.670, -122.300 47.630) And I want to get a substring from POINT(-122.360 47.656) to POINT(-122.310 47.690) How can I return a substring of a LINESTRING in SQL Server 2008 Spatial?

  Read the article

• How can upload image URL in SQL server and retrieve in grid view using ASP.NET?

  - by kalaiselvi

  How to upload image URL in SQL server and retrieve in grid view using ASP.NET? Can you point me to any tutorials and/or sample code?

  Read the article

• Ways I can protect my site excluding XSS and Sql injection?

  - by Tom

  Hi,So, members of my website can post topics, replies, comments, edit them and so on. I always use htmlspecialchars and addslashes for html inputs to protect my site against XSS and SQL injection attacks. Is it enough or is there something more I miss? Thanks.

  Read the article

• How to write or append to text file using sql?

  - by aron

  Hello, in short i need to convert following C# code into SQL stored procedure foreach (var e in Entity) { if (File.Exists(e.Filename)) File.AppendAllText(e.Filename,e.Content); else File.WriteAllText(e.Filename, e.Content); }

  Read the article

• How to create view from more than one table in MS Sql Server database?

  - by GK

  I have to create a view from more than one table in MS Sql Server database, but i am not able to get the correct syntax for the same. need help. thanks.

  Read the article

• What is the easiest way to add a bunch of content to a SQL database?

  - by Trip

  Nothing technical here. Suppose I have a lot of different categorized data, and I would like to create a database out of it. Would someone literally hand plug in all that info with SQL code itself? Or do some people make a mock website just to input data? What are some of your strategies?

  Read the article

< Previous Page | 411 412 413 414 415 416 417 418 419 420 421 422  | Next Page >