Search Results

Search found 63598 results on 2544 pages for 'sql add on'.

Page 253/2544 | < Previous Page | 249 250 251 252 253 254 255 256 257 258 259 260  | Next Page >

• Getting next row using SQL

  - by Peter

  I have 2 tables with data thus: Col1 Col2 ------- -------- Admin001 A Admin001 B Admin002 C Admin002 C Admin003 A Admin003 C I need to find all instances of Col2 values with 'A' immediately followed by 'B'. 'A' followed by any other symbol does not count. Is there a way to use SQL to accomplish this? Environment is DB2 LUW v9.5

  Read the article

• trying to install SQL 2008 on WIndows 2008 server R2

  - by Nezdet

  Hi I was trying to install MSSQL 2008 server on WIndows 208 server R2 Standard Machine, but I got This message: Program Compatibility Assistant, And that I should apply SQL server 2008 SP 1 I don't get it? Why Dosen't it not work with this version I have? How should I solve this problem?

  Read the article

• Crystal Reports vs. Microsoft SQL Server Reporting Services

  - by DATT OZA

  I am developing a WPF application, and I need your advice. I have to generate reports in my application. What should I use, Crystal Reports or SQL Server Reporting Services? Which one is better, and why?

  Read the article

• Storing SQL Queries within a Configuration file?

  - by Ben Crowhurst

  Hello y'all, A general question on what everyone's opinion is on storing SQL queries within a configuration file? Is this just another bike shed? Cheers, Ben

  Read the article

• Password protected PDF/Excel reports using SQL Reporting services

  - by balaweblog

  I am generating a reports using SQL Reporting services 2005. I need to protect the protect the reports(pdf and excel) with the password while the user is exporting the report to to excel or pdf. Is there any way to protect the report.

  Read the article

• Azure Tables or SQL Azure?

  - by Phil Wright

  I am at the planning stage of a web application that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a rich user experience. Should I use Azure Tables or SQL Azure for storing my application data?

  Read the article

• Resources for high performance SQL Server database design

  - by Nathan Ridley

  I'd like some suggestions for online resources (blogs, guides, etc - not forums) to help me become good at designing high performance SQL Server databases that operate with large amounts of data and have heavy loads in terms of data turnover and queries per minute. Suggestions?

  Read the article

• Linq to SQL table inheritance in ASP.net Dynamic Data

  - by themapguyde

  I have a Linq to SQL data model that uses single table inheritance. I created a new ASP.net Dynamic Data web site with all table scaffolding enabled, but I can't see any of the derived classes in my data model being scaffolded. Is this by design?

  Read the article

• SQL - Order against two columns at the same time (intersecting)

  - by Alex

  I have a table with the fields CommonName and FirstName. Only either field has data, never both. Is there a way to order rows in an intersecting manner on SQL Server? Example: CommonName FirstName Bern Wade Ashley Boris Ayana I want records ordered like this: CommonName FirstName Ashley Ayana Bern Boris Wade Is this possible, and if so, how?

  Read the article

• Updating multiple tables at the same time in Linq-to-SQL

  - by kiran

  How do I update two tables at the same time using Linq-to-SQL? var z = from a in db.Products join b in db.ProductSubcategories on a.ProductSubcategoryID equals b.ProductSubcategoryID join d in db.ProductCategories on b.ProductCategoryID equals d.ProductCategoryID select new { ProductName = a.Name, ProductCategory = d.Name, ProductSubCategory = b.Name, Cost = a.StandardCost, discontinuedDate = a.DiscontinuedDate, ProductId=a.ProductID };

  Read the article

• SQL Server 2008 Spatial Clustering

  - by illvm

  I am trying to group points of geospatial data based on density and relative distance. Is there a way that this can be done in SQL Server 2008 using the spatial features or would it be better to translate the data into graph data and use a graph clustering algorithm?

  Read the article

• Timestamp as part of composite primary key?

  - by Curtis White

  I get this error when using linq-to-sql with timestamp as part of a composite primary key: "The primary key column of type 'Timestamp' cannot be generated by the server." I'm guessing this may be due to the fact timestamp is just a row version thus perhaps it must be created after the insert? Or...

  Read the article

• Shrink Sql Server database

  - by hani

  My SQL Server 2008 database file (.mdf) file is nearly 24 MB but the log file grown upto 15 GB. If I want to shrink database what are the important points to take into consideration? Will shrink causes any index fragmentation and does it affect my database performance?

  Read the article

• joining null in MS SQL server, Oracle and informatica

  - by jest

  hi! I've two tables to join with a column(say emp_id)..if emp_id in both the tables have null values, how'll MS SQL server and Oracle treat??? Coz, i read that informatica will neglect the NULL rows when joining..if i handle the null, by substituting -1, a cross-join will happen which i don't want.. what can i do here? I cannot completely neglect the rows which has NULL. Thanks

  Read the article

• Parsing SQL in .NET

  - by Eli

  I'm trying to build a .NET Managed data provider and I need to be able to parse SQL commands. What are good, free (as in beer) objects to do this? - I haven't seen any standard .NET assemblies for this yet. Thanks, Eli.

  Read the article

• SQL Server 2005 Installation on Windows 2000 Server

  - by Raghu

  Hi All, We want to install sql server 2005 on Windo ws 2000 Server. We are able to install database service engine, analysis services engine and integration services. But we are unable to install workstation components like SSMS. Does anybody faced this problem? What is the fix for this? Thanks, Raghu

  Read the article

• Locking User account created under Windows Authentication in SQL Server

  - by Santhosha

  Hi, As per my project requirement i need to lock a user in SQL Server(Which is created using Windows Authentication). Is there any way to do this? Thanks for the help Santhosh

  Read the article

• SQL Server 2008 Reporting Service 2008 the page margins not set while exporting to Excel

  - by BIPIN

  Hi, While using new SQL Server 2008 Reporting Service 2008 the page margins that I specify in Report Properties Page Setup do not seem to flow through to Excel when exported? They always seem to be set to Top & Bottom: 2.5cm, Left & Right: 1.9cm, no matter what I set them to in the report. This was working perfect in 2005 version. Any help would be much appreciated. Thanks, Bipin

  Read the article

• Execution time of ALTER COLUMN

  - by Tommy Jakobsen

  Having a table with 60 columns, and 200 rows. Altering a BIT column from NULL to NOT NULL, now has a running execution time of over 3 hours. Why is this taking so long? This is the query that I'm execution: ALTER TABLE tbl ALTER COLUMN col BIT NOT NULL Is there a faster way to do it, besides creating a new column, updating it with values from the old column, then dropping the old column and renaming the new one? This is on MS SQL Server 2005.

  Read the article

• Wingding chars in sql server 2005

  - by Savvas Sopiadis

  Hi everybody! In a winforms application i 'm storing one Wingdings char in a SQL Server 2005 field of type NVARCHAR(1). Storing, retrieving and showing up this char in a control works fine. The problem i'm facing is this: how to search for records which have a specific wingding char value: for example Select * from table where FieldWithWingding = valueOfLeftArrowChar How to achieve this? Thanks in advance

  Read the article

• Oracle PL/SQL: Performance of CLOB data type in PL/SQL

  - by drupalspring

  If I use many CLOB variables in the PL/SQL stored procedure to store many long length string , are there any performance issues? Is the length of the CLOB is also variable? Are there any known limitations/disadvantages for CLOB instead using varchar2 and long?

  Read the article

• Using Excel to work with SQL data (read/write)

  - by Tyler Brock

  I have a ton of data in a sql database which I would like to be able to import and display in excel (I can already do this) and additionally modify or append to the dataset within excel and write the changes/additions back to the database. What is the best way to go about doing something like this? Please let me know, thanks!

  Read the article

• MYSQL Installation Problem...

  - by Gopal

  I was downloaded the MYSQL from this link http://dev.mysql.com/downloads/mysql/ But i cannot able to find the Installation file... How to create database & Table in mysql? It will work like SQL server or ? Need Help

  Read the article

• SQL Server online backup with MozyPro

  - by Erick Sasse

  Anyone using MozyPro to backup SQL Server databases? I'm concerned about the way it does the backup. It just copies data files the way they are. Not using the backup database command. Is it safe?

  Read the article

• Linq-to-SQL question

  - by c11ada

  hey all, im really new to linq-to-SQL so this may sound like a really dumb question, i have the following code var query = from p in DC.General where p.GeneralID == Int32.Parse(row.Cells[1].Text) select new { p.Comment, }; how do i got about getting the result from this query to show in a text box ??

  Read the article

< Previous Page | 249 250 251 252 253 254 255 256 257 258 259 260  | Next Page >