Search Results

Search found 29121 results on 1165 pages for 'sql 2000'.

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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• use Data Annotation to my Linq to SQL

  - by Khalid Omar

  i have a mvc web project and i'm using linq to sql i'm using dataannotaion like this public class ClientValidation { [Required] public string name1st { get; set; } } then in the linq class i add that above client class [global::System.Data.Linq.Mapping.TableAttribute(Name = "dbo.Client")] [MetadataType(typeof(ClientValidation))] public partial class Client : INotifyPropertyChanging, INotifyPropertyChanged { } every thing is going ok the question is when i re generate the linq when i add table or change any thing in database i need to rewrite [MetadataType(typeof(ClientValidation))] is there any other method to enable me regenerate the model and keep the data annotation as it

  Read the article

• Print DataBase Schema in Sql Server Compact Edition

  - by hosseinsinohe

  Hi All I Want Print DataBase Schema in "Microsoft Sql Server Compact Edition". Maybe Exist Some Tools For it. How Can I do it?

  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

• 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

• Dos command to execute all sql script in a directory and subdirectories

  - by Uince

  Hi, I need a DOS command or a batch (.bat) file I can execute to run all the *.sql script in a directory and it's subdirectories. Any ideas?

  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

• 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

• 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

• SQL reporting service and language problem

  - by Wasim

  I am encountering a problem when attempting to display Hebrew fonts in SQL Server Reporting Services. I see the fonts perfectly in the database, but when displaying the report all the Hebrew fonts displayed as ????? Any suggestions?

  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

• SQL - fetch the row which has the Max value for a column

  - by Umang

  Table: UserId, Value, Date. I want to get the UserId, Value for the max(Date) for each UserId. That is, the Value for each UserId that has the latest date. Is there a way to do this simply in SQL? (Preferably Oracle) Thank in advance! [Update:] Apologies for any ambiguity: I need to get ALL the UserIds. But for each UserId, only that row where that user has the latest date.

  Read the article

• Case insensitive duplicates SQL

  - by hdx

  So I have a users table where the user.username has many duplicates like: username and Username and useRnAme john and John and jOhn That was a bug and these three records should have been only one. I'm trying to come up with a SQL query that lists all of these cases ordered by their creation date, so ideally the result should be something like this: username jan01 useRnAme jan02 Username jan03 john feb01 John feb02 jOhn feb03 Any suggestions will be much appreciated

  Read the article

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