Search Results

Search found 62701 results on 2509 pages for 'sql function'.

Page 90/2509 | < Previous Page | 86 87 88 89 90 91 92 93 94 95 96 97  | Next Page >

• LINQ to SQL get grouped MIN with JOIN

  - by Ira Rainey

  I'm having trouble with a LINQ to SQL query getting the min value using Visual Basic. Here's the SQL: SELECT RC.AssetID, MIN(RC.RecCode) AS RecCode, JA.EngineerNote from JobAssetRecCode RC JOIN JobAssets JA ON JA.AssetID = RC.AssetID AND JA.JobID = RC.JobID WHERE RC.InspState = 2 AND RC.RecCode > 0 AND RC.JobID = @JobID GROUP BY RC.AssetID, JA.EngineerNote; I seem to be going around in circles here with grouping etc not managing to get it working. Any help would be greatly appreciated.

  Read the article

• SQL Server 2008 R2 CTP Installer crashes instantly after starting it

  - by Adrian Grigore

  Hi, I'm trying to update my existing SQL server 2008 SP1 installation with SQL Server 2008 R2 (November CTP). I started the setup and chose the upgrade option and after some time the installer told me to reboot. As soon as I confirmed with OK, it crashed. After rebooting I can't even run the setup file anymore. it crashes instantly without an error message. What's the recommended way of troubleshooting this? Thanks, Adrian

  Read the article

• Crash trying to migrate MySQL DB to SQL Server w/SQL Server Import Export Wizard

  - by consultutah

  I'm trying to migrate a MySQL DB to SQL Server using MS's SQL Server Import Export Wizard. It isn't going so well... The wizard either tells me that the MySQL syntax is invalid or crashes depending on its mood. Here is the query that it executes against MySQL before failing: select * from "_account" Anyway to change so either MySQL likes the quotes or the wizard doesn't use them?

  Read the article

• Save XML File using LINQ to SQL on XML Field

  - by Mark Comix

  Hi, i have a SQL Data Base. On this DB i have a Table with a XML Field. I wan to save a XML file on the XML Field using LINQ to SQL. It is possible? Thanks. Sorry for my poor english

  Read the article

• VS2010 Using SQL Server 2000

  - by Chris M

  Is there a way to use the SQL Model (dbml) builder in VS2010 using SQLServer2000? It works fine in VSExpress2008 + VS2008 but throws an "Upgrade SQL to 2005" error in VS2010 which seems a tad unreasonable.

  Read the article

• SQL Server add a column constraint to limit data to -1 to 1

  - by Seth Spearman

  Hello, I want to constrain a SQL Server decimal column to only allow -1,0,1 as valid values. Can you show me the SQL syntax for adding such a constraint. (I would like to know how to do it in both the CREATE TABLE statement and/or the ALTER TABLE ADD CONSTRAINT). Or can this only be accomplished in a trigger? Seth

  Read the article

• How can I manage SQL CE databases in SQL Server Management Studio?

  - by Edward Tanguay

  I created a SDF (SQL CE) database with Visual Studio 2008 (Add / New Item / Local Database). Is it possible to edit this database with SQL Server Management Studio? I tried to attach it but it only offered .mdf and attaching a .sdf file results in "failed to retrieve data for this request". If so, is it possible to create SDF files with Management Studio as well? Or are we stuck with the simple interface of the Visual Studio 2008 database manager?

  Read the article

• SQL Server high CPU and I/O activity database tuning

  - by zapping

  Our application tends to be running very slow recently. On debugging and tracing found out that the process is showing high cpu cycles and SQL Server shows high I/O activity. Can you please guide as to how it can be optimised? The application is now about an year old and the database file sizes are not very big or anything. The database is set to auto shrink. Its running on win2003, SQL Server 2005 and the application is a web application coded in c# i.e vs2005

  Read the article

• Best practice stock management when payment of customer failed using SQL Server and ASP.NET

  - by Martijn B

  Hi there, I am currently building a webshop for my own where I want to increment the product-stock when the user fails to complete payment within 10 minutes after the customer placed the order. I want to gather information from this thread to make a design decision. I am using SQL Server 2008 and ASP.NET 3.5. Should I use a SQL Server Job who intervals check the orders which are not payed yet or are there better solutions to do this. Thanks in advance! Martijn

  Read the article

• Quickest way to fill SQL Table with Dummy Data

  - by Alex

  What is the quickest way to fill a SQL table with dummy data? I have a wide table with about 40 fields of different kinds (int, bit, varchar, etc.) and need to do some performance testing. I'm using SQL Server 2008. Thank you!

  Read the article

• Is this query vulnerable to sql injection?

  - by user294924

  $myq = sprintf("select user from table where user='%s'", $_POST["user"]); I would like to know if the above query can be exploited using SQL injection. Is there any advanced SQL injection technique that could break sprintf for this particular query?

  Read the article

• Can Visual Studio.NET 2008 integrate SQL 2008?

  - by burntsugar

  Visual Studio 2008 ships with SQL 2005. I would like to integrate SQL 2008. Are there significant reasons why one could not/ can not do this?

  Read the article

• How to rewrite this SQL statement to LINQ 2 SQL ?

  - by Shyju

  How can i convert this SQL query to its equivalent LINQ 2 SQL statement for VB.NET? SELECT COUNT(*) AS 'Qty', IV200.itemnmbr, IV200.locncode, IV200.bin, CAST(IV112.Quantity as int) as 'Qty2' , 'parentBIN' = isnull(MDS.parentBIN,iv112.bin) From IV00200 IV200 (nolock) inner join IV00112 IV112 (nolock) on iv200.itemnmbr = iv112.itemnmbr and IV200.bin = IV112.bin and iv200.locncode = iv112.locncode left outer join mds_container mds (nolock) on isnull(mds.locncode,'nul') = isnull(iv112.locncode,'nul') and isnull(mds.containerbin,'nul') = isnull(iv112.bin,'nul') where IV200.bin = 'MU7I336A80' group by IV200.itemnmbr, IV200.locncode, IV200.bin, IV112.Quantity, isnull(MDS.parentBIN,iv112.bin) order by IV200.itemnmbr

  Read the article

• Visual Studio 2005 doesn't support Sql Server 2008

  - by Erez

  I'm developing Reporting services on VS2005 and have to connect to SQL Server 2008. The following Error occurs: "This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later." I found on the net a patch for it, but it doesn't work (link to patch) "The upgrade patch cannot be installed by the Windows Installer Service because the program to be upgraded is missing, or the upgrade patch may update a different version of the program." what else can I do ? :(

  Read the article

• Create Table by Copying Structure of Existing Table

  - by tyguy840

  I am trying to create a new table by copying an existing table in SQL Server 2008 using Management Studio. The existing table contains no data. I am using the following code but am receiving an error for Incorrect Syntax near AS. I am not sure what is wrong here. I am a SQL newb and any help would be appreciated. Thanks. CREATE TABLE Drop_Centers_Detail AS (Select * From Centers_Detail)

  Read the article

• "Access 2002 vs SQL Server 200*" as DB for sharepoint

  - by Jake

  I work with a team that has a sharepoint site currently runnning and its lists are linked to an access DB. My question is really on the investment level, what would be the reasons to upgrade DB to sharepoint if only a few 100 users access this site. Is there a real benefit to replacing the DB with a version of SQL Server, escpecially if about to replace Access 2002 with 2007 some day. I know SQL Server can handle more memory and traffic for more users, but I'm looking for more reasons than that if there are any.

  Read the article

• SQL Error Locating Server/Instance Specified

  - by leen3o

  Having a problem moving a site from Win2003 IIS6 w/ SQL2005 Express to a Win2008 IIS7 w/Fill SQL 2005? I keep getting this error Desc : SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Can anyone point me in the right direction

  Read the article

• Is it possible to have a multilanguage Environnement in SQL Server 2008 ide

  - by Alexandre Jobin

  Hi! is it possible to install another IDE language to SQL Server 2008 Express like i can do in Visual Studio? In the options of Visual Studio, i can change the Environnement Language. Can i do the same with SQL Server 2008? alex

  Read the article

• Alter Sql table (Change foreign key to Second primary of the table)

  - by vix

  Hi, I've a sql table with a primary key(Auto Incremented) and a foreign key.Now I need to modify the table by modifying the foreign key to second primary key so that its values are not allowed to duplicate. How do i alter my table without affecting the data? Need the sql code. Regards, Vix

  Read the article

• Varchar with trailing spaces as a Primary Key in SQL Server 2008

  - by cacaupt

  Is it possible to have a varchar column as a primary key with values like 'a ' and 'a', is gives always this error "Violation of PRIMARY KEY constraint" in MS SQL Server 2008. In Oracle dons't give any error. BTW I'm not implementing this way I'm only trying to migrate the data from oracle to sql server. Regards

  Read the article

• Create a user-defined aggregate without SQL CLR

  - by David Pfeffer

  I am planning on deploying a database to SQL Azure, so I cannot use the SQL CLR. However, I have a need to create an aggregate function -- in my case, I need to STUnion a bunch of Geography objects together. (Azure is expected to support Spatial by June.) Is there another way to accomplish this, without making use of the CLR, in a query? Or do I have to create a UDF that will take a table as a parameter and return the aggregate?

  Read the article

• How to get parameter values for dm_exec_sql_text

  - by Ted Elliott

  I'm running the following statement to see what queries are executing in sql server: select * from sys.dm_exec_requests r cross apply sys.dm_exec_sql_text(r.sql_handle) where r.database_id = DB_ID('<dbname>') The sql text that comes back is parameterized: (@Parm0 int) select * from foo where foo_id = @Parm0 Is there any way to get the values for the parameters that the statement is using? Say by joining to another table perhaps?

  Read the article

• SQL Express 2005 to SQL 2008 Workgroup for Sharepoint WSS 3.0

  - by smacca20

  I am trying to migrate sharepoint wss 3.0 databases from SQL Express 2005 to SQL 2008 Workgroup edition. I have backed up the database, but not sure how to best attached/restore them to the new version and get up and running again. Thanks

  Read the article

• Database task to delete table records periodcally in sql server 2008

  - by Marwan Aouida

  I want to add a database task that runs on a 6 hours interval. The task is to delete some records that matches certain condition. What is the best way to achieve this in Sql Server 2008 ? I know I can do this on the app side but I want it on sql server side.

  Read the article

• SQL Server: is ther a way to grant execute using GUI

  - by atricapilla

  Is there a way to grant execute permissions from role or user using GUI (not T-SQL)? I'm using SQL Server 2008 SP1.

  Read the article

< Previous Page | 86 87 88 89 90 91 92 93 94 95 96 97  | Next Page >