Search Results

Search found 14739 results on 590 pages for 'mssql 2008'.

Page 222/590 | < Previous Page | 218 219 220 221 222 223 224 225 226 227 228 229  | Next Page >

• How to identify the culprit in "Error converting data type varchar to numeric"?

  - by Stan

  An insert statement with a large number of values returns 'Error converting data type varchar to numeric.' How can I find which value actually triggers the error? MS SQL Server 2008 is used.

  Read the article

• 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

• how can we back up in sql server 2008

  - by Johanna

  Hi I need the menus that help me to back up in sql server 2008? thanks

  Read the article

• Concatenate a table name from a variable in a FROM clause

  - by idieeasy

  I'm trying to use a dynamically generated fully-qualified table name in sql server 2008. For example, this does not work: select max([id]) from @dbName+N'.[T1]' This will give an error like: Msg 102, Level 15, State 1, Line 73 Incorrect syntax near '+'. I know that something like this works: declare @qualifiedTable varchar(200) = @dbName+N'.[T1]' select max([id]) from @qualifiedTable But I have to do this LOTS of times so I would really like to do it in line. Is it possible?

  Read the article

• Go to Matching Brace in Visual Studio?

  - by thepocketwade

  Is there a way in Visual Studio 2008 to go from a closing brace to it's opening brace? I've found a fair amount of stuff about highlighting the brace, but nothing about moving the cursor to it.

  Read the article

• Putting 3 million pages in 1 folder vs. putting in a number of sub-folders, which structure is faste

  - by silent

  If I have 3 million pages, which directory structure is better? Method 1. ~/123456789.htm (Putting all the 3 million pages into the same folder without any sub folders) Method 2. ~/789/123456789.htm (Create 999 sub-folders, each sub-folder contains about 3000 pages) For Windows Server 2008, which folder structure is faster? (For file creation, reading and deletion)

  Read the article

• How to keep ComboBox from scrolling? C#

  - by Chris

  I have a ComboBox. It is critical that the user cannot scroll by accident and change the selected value. How can I prevent the ComboBox from changing the value and text when the use scrolls? Thanks. Visual Studio 2008

  Read the article

• Visual studio erroneous erros when building a website?

  - by Curtis White

  Visual Studio 2008 shows a lot of erroneous errors when building a website (not a web project) in the errors list. These errors are usually corrected (removed) when I rebuild the site a couple times but they cost me wasted time. Is there anyway to hide the erroneous errors?

  Read the article

• How to connect to a database from VC++/CLI .NET 4.0

  - by abatishchev

  How to connect to a database (any natively supported by .NET) - SQL Server 2008 or Access - from a Windows Forms application written on VC++/CLI (compiler ver. 16.0 from .NET 4.0)

  Read the article

• Best index(es) to use for an OR Statement in SQL Server

  - by Chuck Haines

  I have a table which has a bunch of columns but the two relevant ones are: Due_Amount MONEY Bounced_Due_Amount MONEY I have a SQL query like the following SELECT * FROM table WHERE (Due_Amount 0 OR Bounced_Due_Amount 0) Would the best index to put on this table for SQL Server 2008 be an index which includes both columns in the index, or should I put an separate index on each column?

  Read the article

• Why SQL Server Express 2008 install requires Visual Studio 2008 in checklist ?

  - by asksuperuser

  When installing SQL Server Express Edition 2008, checklist says "Previous version of Visual Studio 2008" and asked me to upgrade to sp1. Unfortunately sp1 for some reason refuses to install on my brand new pc (Windows 7). So why can't I just bypass this ? Why would SQL Server Express needs VS2008 to install that's insane. SQL Server install used to be as easy as 123, now it has become a nightmare like installing Oracle. Will I have to go back to Windows XP ?

  Read the article

• C# Can I publish my window form application???

  - by HoNgOuRu

  I've just finished a functional peace of code and would like to upload it to the internet as freeware. It is just a window form application. I used C# and Visual Studio 2008. I wan't to know if it is legal to do this... Thanks for reading this.

  Read the article

• Putting 3 million pages in 1 folder vs. putting them in a number of sub-folders, which structure is

  - by silent

  If I have 3 million pages, which directory structure is better? Method 1. ~/123456789.htm (Putting all the 3 million pages into the same folder without any sub folders) Method 2. ~/789/123456789.htm (Create 999 sub-folders, each sub-folder contains about 3000 pages) For Windows Server 2008, which folder structure is faster? (For file creation, reading and deletion)

  Read the article

• What are the "directoryentry" and "directorysearch" controls in VS2008?

  - by forum

  What are "directoryentry" and "directorysearch" controls in Visual Studio 2008? How do they work? What are there real-world applications? What about their properties?

  Read the article

• How to speed up saving data to database over internet?

  - by robert_d

  I am using C#, Entity Framework and SQL Server 2008 Express. I am connected to the database over internet. What is the best method to speed up saving/updating data to database? It takes 60 seconds to save 140 records to database.

  Read the article

• WPF inherited UserControl lost VS designer support

  - by PaN1C_Showt1Me

  Hi ! I' written this UserControl: <my:MyUserControl x:Class="MyClass" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:my="clr-namespace:MyNameSpace.MyControls;assembly=MyAssembly"> </my:MyUserControl> public partial class Editor : MyNameSpace.MyControls.MyUserControl {} Everything works, the control is shown in the VS 2008 Designer, but I cannot click directly in the elements and select them as it was with UserControl. Any idea how to solve it?

  Read the article

• is it possible to add line from Database to text file in the server ?

  - by Gold

  hi i have sql-server 2008 database that in the main server. i have 10 terminals that connect to this server and work against the database. i need that every new inserting to database through any terminal - in the server this line will inserting to text file (every line) can i do it ? thank's in advance

  Read the article

• A Query to remove relationships that do not belong [closed]

  - by Segfault

  In a SQL Server 2008 R2 database, given this schema: AgentsAccounts _______________ AgentID int UNIQUE AccountID FinalAgents ___________ AgentID I need to create a query that does this: For each AgentID 'final' in FinalAgents remove all of the OTHER AgentID's from AgentsAccounts that have the same AccountID as 'final'. So if the tables have these rows before the query: AgentsAccounts AgentID AccountID 1 A 2 A 3 B 4 B FinalAgents 1 3 then after the query the AgentsAccounts table will look like this: AgentsAccounts AgentID AccountID 1 A 3 B What T-SQL query will delete the correct rows without using a curosr?

  Read the article

• Convert bit to boolean string in HyperLinkField.DataNavigateUrlFormatString

  - by abatishchev

  I have a asp:GridView with a HyperLinkField. It's DataNavigateUrlFormatString property is set to View.aspx?id={0}&isTechnical={1} Select command of appropriate SqlDataSource returns columns of type INT and BIT (from SQL Server 2008). So displayed string becomes something like View.aspx?id=1&isTechnical=1. But I want to display isTechnical=true|False, i.e. Convert.ToBoolean(row["isTechnical"]).ToString().ToLowerInvariant(). How to implement such conversion in page markup?

  Read the article

• Visual Studio: reset user settings when debugging

  - by Reinhard

  In a C# Winforms-App I have several user settings stored. Is there an easy way to clear those settings each time I start debugging the project from Visual Studio 2008? Otherwise it always starts up with the settings from the last debug-session. Thank you!

  Read the article

• Where are the assemblies to interact with Sql Server?

  - by dotnetdev

  Hi, I am running Visual Studio 2010 Ultimate and SQL Server 2008 R2 Nov 2009 CTP. However, I cannot find the .dlls for Sql Server (So that I can add tables, get the databases collection, etc). Can anyone tell me where dlls are based? Thanks

  Read the article

• SQL Server - Missing Indexes - What would use the index?

  - by BankZ

  I am using SQL Server 2008 and we are using the DMV's to find missing indexes. However, before I create the new index I am trying to figure out what proc/query is wanting that index. I want the most information I can get so I can make informed decision on my indexes. Sometimes the indexes SQL Server wants does not make sense to me. Does anyone know how I can figure out what wants it?

  Read the article

• How do you compile different classlibraries to one dll?

  - by Sem Dendoncker

  The question explains it all. I have different classlibraries but I would like to compile them into one general DLL. Is this possible? I'm using .NET 3.5 with visual studio 2008. cheers, M

  Read the article

• Recursively expand collapsed regions in Visual Studio? (outlining)

  - by Kurt Margenau

  I'm using Visual Studio 2008, and it doesn't seem like once I have collapsed all the regions, I can expand ALL levels of a certain region with one click/command. Notepad++ has this functionality when you ctrl + click on a collapsed region, it recursively expands all regions within it. It's awesome. Anyone know of a plugin or macro that has this functionality? I'm using a custom language, aka not C++/C# btw thanks!

  Read the article

• from where i can get button with picture - for Windows mobile ?

  - by Gold

  hi from where i can get button with picture - for Windows mobile ? i work on Visual-studio 2008 i need a free one thanks in advance

  Read the article

< Previous Page | 218 219 220 221 222 223 224 225 226 227 228 229  | Next Page >