Search Results

Search found 5375 results on 215 pages for 'sqlserver 2005'.

Page 141/215 | < Previous Page | 137 138 139 140 141 142 143 144 145 146 147 148  | Next Page >

• How to include the total number of returned rows in the resultset from SELECT T-SQL command?

  - by quarkX

  I would like to ask if there is a way to include the total number of rows, as an additional column, in the returned result sets from a TSQL query using also the Row_Number (SQL 2005) command. For example, getting the results set from a query against Book table in a form similar to this: RowNum BookId BookTitle TotalRows -------------------------------------------- 1 1056 Title1 5 2 1467 Title2 5 3 121 Title3 5 4 1789 Title4 5 5 789 Title5 5

  Read the article

• free, recommendable Tools for data modeling?

  - by Tim

  Hello, are there free, recommendable Tools for data modeling? ERM/ORM Diagrams Creating database models (SQL SERVER 2005) Simple to use like Visio(no license here) Code generation is only a nice to have (VB.Net)

  Read the article

• Select most recent record in sub child

  - by Omar

  I have the following tables/columns: Parent: ParentID Child: ChildID ParentID SubChild: SubChildID ChildID Date Parent has 1 to Many relationship with Child Child has 1 to Many relationship with SubChild For every Parent, I need to get the SubChild with the most recent Date value. How can I do this using SQL. I've tried using MAX(Date), but I can't seem to figure out how to join Parent and Child successfully. The ideal result set would contain all the Parents joined with all the SubChild columns of the latest record. Note: using MS SQL 2005+

  Read the article

• Send mail in asp.net without smtp details

  - by Zerotoinfinite

  Hi Experts, I am using asp.net and C#. I have deployed my application on the server and now I come to know that my server don't have a ip address, is their any way I could send sms without smtp details. I can use bot asp.net3.5 with C# or SQL Server 2005 to send mail. Thanks in advance

  Read the article

• QT sqlite deploy exe

  - by Samir

  I have a Qt exe built from visual studio 2005(after taking the .cpp, .h, .moc, ui_ files) I have done some simple QSqlite queries. It works fine in my development pc. But in another pc it crashes for the line below: QSqlDatabase mSqlDb How to run the exe so that it can interact with sqlite from another pc. [Any other gui application runs just fine.] So which things are necessary to deploy a sqlite-qt application ?

  Read the article

• Cluster-aware client app (to SQL Server)

  - by Mikael Sundberg

  Hello, We have an .NET client app working against SQL Server 2005 (clustered), do I need to do something special in the client app to make it cluster aware? Thanks.

  Read the article

• T-SQL OPENQUERY to MySQL - Insert ID

  - by n0chi

  I am using OPENQUERY to do an insert from MSSQL 2005 to MySQL. How do I get at the last inserted id on the MySQL db back into my MSSQL procedure?

  Read the article

• Corrupt Database

  - by user250545

  I am Looking For Best Way or Software To Recover Corrupt Database in SQL 2000/2005/2008 . looking for Ur help .......................................

  Read the article

• Comparing XML in SSRS

  - by silves89

  I'm new to SSRS. We'll have two slightly different chunks of XML in a single row of an SQL Server database table. In an SSRS report we'll want to show only the differences between the XML chunks. I don't know how to do this, but I suspect the XML Type in SQLServer 2005 might be useful, or XSLT transformations in SSRS. Could anyone point me in the right direction?

  Read the article

• Is there any available free & open source implementation of RSA-2048 for SQL Server 2000?

  - by Victor Rodrigues

  I'm trying to do some cryptography for SQL Server 2000, and I know that only SQL 2005+ comes with built-in functionality for doing this natively. Do you know any open source implementation that I can use for free of RSA-2048 cryptography?

  Read the article

• Producing dynamically generated range names in Excel using c#

  - by Matey

  What is the best way to produce several tables of unknown size on the same worksheet? Values will be pulled from an oracle database and are used as values on several tables. Is it possible to create dynamic named ranges or is some other method desirable? I have some experience with c# but do not have access to VSTO 2005. Any help or suggestions would be greatly appreciated. I am willing to explain the problem further if requested.

  Read the article

• Move row from one table to another?

  - by lance

  I have two tables with the same column definitions. I need to move (not copy) a row from one table to another. Before I go off and use INSERT INTO/DELETE (in a transaction), is there a smarter way? SQL Server 2005

  Read the article

• What's the "Find Result" Control Visual Studio Integrated?

  - by Nano HE

  Hi, I am developing a simple Windows Application in C# and Visual Studio 2005. I need a search result control - just like visual studio integrated by itself. After I double click each line to trigger the individual event. I tried multi-line textBox Control, but whole the box can only support one click event. thank you.

  Read the article

• How to create dependent files in Visual Studio 2008?

  - by HeavyWave

  I've found this blog post http://blog.laurent.etiemble.com/index.php?post/2006/12/08/101 but it uses a custom add-in for VS 2005. I would assume there is a way to do this natively in VS 2008?

  Read the article

• How to convert a DataTable to a string in C#?

  - by Mark Allison

  Hi there, I'm using Visual Studio 2005 and have a DataTable with two columns and some rows that I want to output to the console. I hoped there would be something like: DataTable results = MyMethod.GetResults(); Console.WriteLine (results.ToString()); What's the best way (i.e. least amount of coding from me) to convert a simple DataTable to a string? Thanks, Mark.

  Read the article

• The report you requested requires further information (Oracle database)

  - by Migdalia Santiago

  Hi, I have a simple application in C# (Visual Studio 2005) that display a Crystal Reports report (Crystal Reports X1 R2). When I compiled the application it appears the following message: The report you requested requires further information. I want to set the connection info in the code so the application doesn't ask the user for the database password. It's a Oracle database.

  Read the article

• Is there a standard dialog for constructing an ADO.Net connection string (that is redistributable)?

  - by rathkopf

  I want to use a standard dialog to solicit user input of an ADO.net connection string. It is trivial to do for the oledb connection string as described here: MSDN Article on MSDASC.DataLinks().Prompt I've also found examples that use Microsoft.Data.ConnectionUI.dll and MicrosoftData.ConnectionUI.Dialog.dll from VS (HOWTO: Using the Choose Data Source dialog of Visual Studio 2005 from your own code). Unfortunately these DLLs are not licensed for redistribution. Is there a standard dialog for choosing a data source that can be distributed with my application?

  Read the article

• Read and Step into .Net Framework Source Code

  - by ChloeRadshaw

  I did ask whether this was possible in 2008 which was answered in http://stackoverflow.com/questions/1296840/read-and-step-into-net-framework-source-code. However my problem is that I am using 2005 and not 2008. Does anyone know whether this is possible please?? The reason I want to do this is to better understand C# paradigms. With Java this is possible and I learnt a tremendous amount by being able to read code written by engineers

  Read the article

• How can a Script be passed through a TextArea into a Form?

  - by William Calleja

  I need to make a form with a Text Area that accepts lines of script, any kind of script be it javascript, css, html, vbscript, whatever. How can the script be passed to a form post? EDIT: How can this script be modified so it can be inserted into a Database? Specifically SQL Server 2005

  Read the article

• Get application path of another executable within same solution.

  - by Perplexed

  Hi, I am using c#, VS 2005. I have one solution with two projects. Project1 needs to startup project2 after some checks. How do I get the executable path of Project2 from within Project1? I need a solution for both debug and live mode. thanks, KS

  Read the article

• Regions in Delphi - is it possible to define them unfold by default?

  - by ntodorov

  Since Delphi 2005 Borland/CodeGear introduced the regions in the IDE. It is good idea but in some casses I want my reginos to be unfolded by default in other folded. If there argument or options that will do the job? I'm using Delphi 2007.

  Read the article

• Neat way of calling InvokeRequired and Invoke

  - by ho

  I seem to remember seeing some neat way of calling InvokeRequired and Invoke to avoid repeating too much code in every event handler but I can't remember what that was. So does anyone know a neat way of writing that code? Preferably for VB.Net 2005.

  Read the article

• how to determine date when service pack was applied to SQL Server instance?

  - by Oliver

  For an instance of SQL Server 2005/2008, how can one determine the date and time when a service pack was applied to the instance? Is there a system table or view that stores that information?

  Read the article

• Sql Server xml column with Entity Framework - how to keep insignificant whitespaces

  - by Saravanan

  Sql server 2005 (even 2008) strips the insignificant whitespaces by default. To keep one can use the CONVERT funtction with the last argument as '1' (Ref. Article). How can we do the same thing in Entity Framework? thanks

  Read the article

• asp.net url concealment?

  - by eduardo

  In my asp.net 2005 app, I would like conceal the app structure from the user. Currently, the end user can learn intimate details of my web app as they navigate and watch the url change. I don't want the end user to know about my application structure. I would like the browser url to not change if possible. Please advise. thanks E.A.

  Read the article

< Previous Page | 137 138 139 140 141 142 143 144 145 146 147 148  | Next Page >