Search Results

Search found 27530 results on 1102 pages for 'sql truncate'.

Page 395/1102 | < Previous Page | 391 392 393 394 395 396 397 398 399 400 401 402  | Next Page >

• 'Timeout Expired' error against local SQL Express on only 2 LINQ Methods...

  - by Refracted Paladin

  I am going to sum up my problem first and then offer massive details and what I have already tried. Summary: I have an internal winform app that uses Linq 2 Sql to connect to a local SQL Express database. Each user has there own DB and the DB stay in sync through Merge Replication with a Central DB. All DB's are SQL 2005(sp2or3). We have been…

  Read the article

• Japanese character stored in SQL Server DB using ASP page that assumed it as ISO-8859-1 encoding

  - by Vishal Seth

  We have a legacy ASP based product that allowed the UI and Data languages of user groups to be configured according to their locations. CodePage and CharSet in ASP pages collecting data was set accordingly. I've noticed few instances in the SQL Server DB where users posted Japanese characters in the ASP page that assumes the oncoming stream to be…

  Read the article

• Best way to move a bunch of SQL Server 2005 tables to another Server?

  - by Mikecancook

  I've been looking for a way to move a bunch of tables, more than 40, to another server with all the data in them. I've looked around for scripts to generate inserts but so far I'd have to run them once for every table, then copy all the scripts over and then run them on the server. Seems like there is a better way. --Update-- My strategy for…

  Read the article

• How can I replace ” with " in ASP.NET SQL?

  - by vamsivanka

  I am trying to run this SQL from ASP.NET 2005 but am getting an invalid SQL error because it has a weird character ” in it. In my code I am trying to replace ” with " but it is not doing it as the special character in the replace command is changing to ". Query: insert into userquery(description) values ('In fact, Topeka Google Mayor…

  Read the article

• How can I know when SQL Full Text Index Population is finished?

  - by GarethOwen

  We are writing unit tests for our ASP.NET application that run against a test SQL Server database. That is, the ClassInitialize method creates a new database with test data, and the ClassCleanup deletes the database. We do this by running .bat scripts from code. The classes under test are given a connection string that connects to the…

  Read the article

• In SQL, how can I count the number of values in a column and then pivot it so the column becomes the

  - by Josh Yeager

  I have a survey database with one column for each question and one row for each person who responds. Each question is answered with a value from 1 to 3. Id Quality? Speed? -- ------- ----- 1 3 1 2 2 1 3 2 3 4 3 2 Now, I need to display the results as one row per question, with…

  Read the article

• Is there a way to customise messages produced by statements in MS SQL Query Analyzer?

  - by Scott Leis

  If I run a simple query in SQL Query Analyzer, like: SELECT * FROM TableName the Messages pane always produces a message like: (30 row(s) affected) If I run a stored procedure with many statements, the messages are useless because there's no indication of what each one relates to. So firstly: Is there a way to customise the default…

  Read the article

• Is there a tool that will show diagrams of my SQL database in real-time?

  - by Rising Star

  I've created some diagrams of SQL tables using the "Reverse Engineer" feature of Microsoft Office Visio. I like being able to visualize my relational databases in this manner. However, what I get is just a static document that I can print, e-mail to colleagues, and click widgets on. Earlier this year, I saw at a demo that the new…

  Read the article

• I want to exchange the Value of a column in two different rows in Microsoft SQL server

  - by Silmaril89

  Hi, I want to do the following two SQL Queries in Microsoft SQL SERVER UPDATE Partnerships SET sortOrder = 2 WHERE sortOrder = 1; UPDATE Partnerships SET sortOrder = 1 WHERE sortOrder = 2; The only problem is, I don't allow for sortOrder to contain the same value, it is a unique key. How could I get around this, because the…

  Read the article

• How can I detect a SQL table's existence in Java?

  - by Soldier.moth

  How can I detect if a certain table exists in a given SQL database in Java?

  Read the article

• Is there an alternative of using a VBScript for enabling FileStream after SQL Server installation?

  - by user193655

  To use Filestream on a DB 3 steps must be done: 1) enable it a server/instance level 2) enable it (sp_configure) at DB level 3) create a varbinary(max) field that supports filestream (2) and (3) are done easily with T-SQL (1) is doable manually from SQL Server Configuration Manager, basically what I need is to check all the…

  Read the article

• Write a SQL query to find those values from column A in table X that are NOT present in column B of

  - by shishir garg

  Write a SQL query to find those values from column A in table X that are NOT present in column B of table Y.

  Read the article

• How can I fake sql data while preserving statements without commenting my server-side code?

  - by Fedor

  I have to use hardcoded values for certain fields because at this moment we don't have access to the real data. When we do get access, I don't want to go through a lot of work uncommenting. Is it possible to keep this statement the way it is, except use '25' as the alias for ratecode? IF(special.ratecode IS NULL,…

  Read the article

• Is there any open source software for converting SQL statements to LINQ?

  - by masoud ramezani

  Is there any open source software for converting SQL statements to LINQ?

  Read the article

• How to log the raw SQL from Oracle occi C++ api?

  - by savanna

  One of our customers is complaining our application is not working. Their reasoning is that our sql function call to their Oracle database is not getting the "expected" result. Sometime, it should failed but our application get success from their database. It's really frustrating because it's their database and we…

  Read the article

• Can a SQL Server 2008 database support both a REST and SOAP web services within two different endpoints?

  - by PaulDecember

  Say you have a SQL Server 2008 database. You build a SOAP web service. You then deploy or publish this using Visual Studio 2010 in one website. Now, using the same database, you build a REST web service, in a different solution. You deploy this on another website. Can you consume the endpoints and/or .svc…

  Read the article

• is there any way to debug sql-server 2008 query ?

  - by Gold

  hi is there any way to debug sql-server 2008 query ? thank's in advance

  Read the article

• How to Merge two databases in one in MS SQL Server 2008?

  - by SzamDev

  Hi I have 2 PCs, each one of them has MS SQL Server 2008 installed on it and there is a database with data in it. I need a way that I can move data in my DB from this MS SQL Server to another one (another PC which has the same DB) move data from one PC to another one - There is one proplem, the ID…

  Read the article

• How can I convert bigint (UNIX timestamp) to datetime in SQL Server?

  - by salman

  How can I convert bigint (UNIX timestamp) to Datetime in SQL Server?

  Read the article

• How to make UPDATE queries in LINQ to SQL?

  - by Alex

  I like using LINQ to SQL. The only problem is that I don't like the default way of updating tables. Let's say I have the following table with the following columns: ID (primary key), value1, value2, value3, value4, value5 When I need to update something I call UPDATE ... WHERE ID=@id LINQ to SQL…

  Read the article

• How to equal two strings case sensitively in Linq to SQL?

  - by Alon

  How to equal two strings case sensitively in Linq to SQL (in a where query)? Thanks.

  Read the article

• how to get the second batch and 3rd batch in the same query result in oracle sql + yii framework?

  - by sasori

  let' say i have 20 results in the sql query. if am gonna use the limit in the yii active record, I'll obviously get the first four from the result, but what if i wanna get the 2nd four and then 3rd four in the same query result ? how to query that via sql ? e.g $criteria2 = new…

  Read the article

• Microsoft sort SQL Server 2014 CTP 2 et vante ses nouvelles capacités In-Memory permettant d'accélérer 30 fois les performances

  Microsoft sort SQL Server 2014 CTP 2 et vante ses nouvelles capacités In-Memory permettant d'accélérer 30 fois les performancesMicrosoft a profité de son salon Pass Summit 2013 dédié à SQL Server pour dévoiler la CTP 2 de sa plateforme de gestion de données moderne SQL Server 2014.SQL…

  Read the article

• 2 Servers setup for redundency, backup

  - by minal

  I presently have 1 dedicated virtual server running my website/blog/mail, etc. This is on Hyper-V with 512MB RAM. Windows Web2008. With the VM, I have these running within it: SmarterMail – for emails MS DNS – I have my own nameservers on this server SQL Express IIS7 2 IP Address …

  Read the article

• SSMS Tools Pack 2.1.0 is out. Added support for SQL Server 2012 RC0.

  - by Mladen Prajdic

  This version adds support for SQL Server 2012 RC0 and fixes a few bugs with SQL History. Because of the support for regions in SSMS 2012 the regions and debug sections feature has been removed from SSMS Tools Pack for SQL Server 2012. The feature is still available for previous SSMS…

  Read the article

< Previous Page | 391 392 393 394 395 396 397 398 399 400 401 402  | Next Page >