Search Results

Search found 37457 results on 1499 pages for 'sql 2008 r2'.

Page 645/1499 | < Previous Page | 641 642 643 644 645 646 647 648 649 650 651 652  | Next Page >

• 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

• 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

• 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

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

• 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

• 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

• 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

• 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

• 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

• 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 set default seed for all identities within a SQL Server database?

  - by Brandon DuRette

  Is there a way to tell SQL server to use specific default seed value for IDENTITY columns - assuming the (to be run) CREATE TABLE statements do not specify one? I don't really care about altering existing data or altering the seed values for specific IDENTITY columns. I want the same seed for all newly created identity columns. Assume I cannot modify the individual CREATE TABLE statements in any way.

  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

• 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

• 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

• How to check results of LINQ to SQL query?

  - by rem

  In a WPF app I'd like to check if a return of a LINQ to SQL query contains some records, but my approach doesn't work: TdbDataContext context = new TdbDataContext(); var sh = from p in context.Items where p.Selected == true select p; if (sh == null) { MessageBox.Show("There are no Selected Items"); } Where am I wrong?

  Read the article

• How to check if a Constraint exists in Sql server?

  - by Lieven Cardoen

  I have this sql: ALTER TABLE dbo.ChannelPlayerSkins DROP CONSTRAINT FK_ChannelPlayerSkins_Channels but apparently, on some other databases we use, the constraint has a different name. How do I check if there's a constraint with the name FK_ChannelPlayerSkins_Channels.

  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

• What is the difference between tinyint, mediumint, bingint and int in sql?

  - by Sein Kraft

  What is the difference between tinyint, mediumint, bingint and int in sql? In which case are used?

  Read the article

• In SQL Server 2005, how can I use database_b, do something, then use the old db database_a in TSQL?

  - by Yousui

  Hi guys, In SQL Server 2005, how can I use database_b, do something, then use the old db database_a in TSQL? The following is my code but there is some problem with it. Who can help me to identity the problem? Great thanks. DECLARE @old_database_name VARCHAR(200) SET @old_database_name = db_name() use mydatabase create table t1(id int identity(1,1)) use @old_database_name

  Read the article

• How to get total number of hours between two dates in sql server?

  - by Pandiya Chendur

  Consider two dates 2010-03-18 22:30 and 2010-03-19 03:30 .... How to get the number of hours in between the two dates in sql server.....

  Read the article

• is there a tool that can convert web server logs (apache,iis, etc..) to Sql Database?

  - by Karim

  i have some apache logs and i want to be able to query the data in it. so i wanted to know if its possible to convert this log data to a relational database so i later can query and analyze the data using sql statments. thanks

  Read the article

• Webservice for Watching a Table in SQL server and populating it.

  - by GayaMani

  Can we write a web service to watch a table in sql server. whenever the corresponding table is populated with new records, the new records should appended to the another table which has the same structure of the old one. Is this is possible using webservices if not how to perform this.

  Read the article

• Will linq to sql work in an asp.net 2.0 web application?

  - by Blankman

  Will linq to sql work in an asp.net 2.0 web application? Just realized the server doesnt' support asp.net 3.5 (no control over it!)

  Read the article

< Previous Page | 641 642 643 644 645 646 647 648 649 650 651 652  | Next Page >