Search Results

Search found 37012 results on 1481 pages for 'sql query'.

Page 324/1481 | < Previous Page | 320 321 322 323 324 325 326 327 328 329 330 331  | Next Page >

• LINQ2SQL: how many datacontexts ?

  - by sh00

  I have a SQL Server 2008 database with 300 tables. The application I have to design is an Windows Forms app, .NET 3.5, C#. Which is the best way to work with LINQ2SQL ? I intend to make a datacontext for each business entity. Is there any problem ? I need to know if this way of working with LINQ has any disadvantage or can create performance issues ? Thanks.

  Read the article

• Generate table relationship diagram from existing schema (SQL Server)

  - by Nick

  Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database or by any other means? This is for SQL Server 2008 Express Edition.

  Read the article

• Native SQL - How to set the schema and database names

  - by icelobber

  Im using Native SQL from ABAP language. The query to get data is something like this SELECT COUNT(ROWID) FROM <SCHEMANAME>.<TABLENAME>;@<DATABASENAME> INTO :localvariable I want to somehow set the schemaname and database name as default so that i do not need to use them in the SELECTs later. Then i can only use the table name in the SELECT. thanks !!

  Read the article

• Display sql results in groups

  - by ktsixit

  Hi all, I have an sql query here and it returns a number of results. I'd like to show these results in groups. What I mean is, show the first 20 results in some part of the page, show the next 20 results in another part of the page etc... How can I do that?

  Read the article

• How do I accurately handle a batch separator for SQL from C#

  - by Sam Saffron

  For Data Explorer I would like to add support for a Batch separator. So for example if users type in: select 'GO' go select 1 as go Go select 100 I would like to return the three result sets. Its clear that I need some sort of parser here, my hope is that this is a solved problem and I can just plug it in. (writing a full T-SQL parser is not something I would like to do) What component / demo code could achieve splitting this batch into its 3 parts?

  Read the article

• Sql Server: all object dependencies

  - by Gjorgji

  Hi, Is there any place where I can find all possible object dependencies in Sql Server? What I mean by "object dependency" is a list of object that one object can depend on. For example, TABLE can depend on SCHEMA, TYPE, TABLE, FUNCTION, etc.

  Read the article

• Syncing with and without Sql Server 2008 changes tracking

  - by Arsenty

  I've stuck with syncing a Sql server 2008 having changes tracking enabled with a 2005 one that doesn't have this mechanism. Would you please point me a right track, how can I handle this. Thank you,

  Read the article

• How to rename a table in the sql server compact edition

  - by Nila

  Hi. I'm new to SQL Server Compact edition. I'm using Compact edition 3.5. I tried renaming the table. But, I couldn't do that through the following query. alter table tablename to newname Plz, someone help me.........

  Read the article

• SQL CASE Question

  - by docsql

  Hiya, I dont know if this can be done but i'd though i'd ask. What I want to do is have a case statement query and if a 1 begin another action. if 0 dont do anything. For Example select CASE WHEN client.deathofdeath = yes THEN 1 do another select in here (which is another table) Else 0 End AS DeathDate From Client client Can this be done?

  Read the article

• Sql case that will use a current table

  - by Dana Ezer

  I have an sql statement that returns this result below,and I want that the num will drag the latest(by date) num that is not null. I can't get it right. I want to add somthing like this: case when num is null then max(num where date<my_date) my result now: Date num 1.1 0 2.1 1 3.1 NULL 4.1 NULL 5.1 4 what I want: Date num 1.1 0 2.1 1 3.1 1 4.1 1 5.1 4

  Read the article

• SQL Monitoring Overview

  - by andy

  Hi I currently loook after 20 odd databases in SQL server 2005 and need a tool for monitoring the performance and keep me informed if a database is running slow. Is there anything I can run within Managment studio of any other good third party tool (Pref free) that can do the job. Thanks

  Read the article

• Public SQL database for educational purposes

  - by Grzegorz Oledzki

  I am looking for a publicly available SQL database with free access, where one can run some SELECT queries for free on some meaningful data (not item1, item2, item3). Have you seen any? Even better if it came together with some tutorial. Vendor is not that relevant, as long as one can connect using a generic JDBC client.

  Read the article

• ASP.NET LINQ to SQL SubmitChanges() doesn't update the database

  - by Alex

  In my 2nd ASP.NET MVC project I'm facing a very weird problem: when I call the SubmitChanges method of the DataContext class, nothing updates in the database. It's weird because everything works fine with my first project. I'm using a remote database created in Sql Server Management Studio, I tried doing some queries there and in Visual Studio 2010 (where I have the connection to the database), they all work. Where might the problem be hidden?

  Read the article

• How to sanitize sql fragment in Rails

  - by dimus

  I have to sanitize a part of sql query. I can do something like this: class << ActiveRecord::Base public :sanitize_sql end str = ActiveRecord::Base.sanitize_sql(["AND column1 = ?", "two's"], '') But it is not safe because I expose protected method. What is a better way to do it?

  Read the article

• Copy data from database sql express keep primary key

  - by EduardoMello

  I want to copy data from a database to another, but I'd like to keep the primary key from the original database so it won't mess with the relationships. I'm using MS SQL Server 2008.

  Read the article

• Getting dynamic childs for a parent in SQL

  - by Islam

  I have a table called Categories which contains category_Id and parent_category_Id, so each category can has a child and the child can has a child and so on (it is dynamic). So if i have category A and category A has child B and child B has child C and child C has child D. I want to get all the child tree of A using SQL so when I give this query the id of A its result will be the ids of A's child which is B,C & D.....any ideas. Thanks in regards,

  Read the article

• how to convert sql union to linq

  - by lowlyintern

  I have the following Transact SQL query using a union. I need some pointers as to how this would look in LINQ i.e some examples wouldbe nice or if anyone can recommend a good tutorial on UNIONS in linq. select top 10 Barcode, sum(ItemDiscountUnion.AmountTaken) from (SELECT d.Barcode,SUM(AmountTaken) AmountTaken FROM [Aggregation].[dbo].[DiscountPromotion] d GROUP BY d.Barcode UNION ALL SELECT i.Barcode,SUM(AmountTaken) AmountTaken FROM [Aggregation].[dbo].ItemSaleTransaction i group by i.Barcode) ItemDiscountUnion group by Barcode

  Read the article

• SQL Server Merge statement issue

  - by George2

  Hello everyone, I am learning and using SQL Server 2008 new Merge statement, merge statement will compare/operate source table and destination table row by row ("operate" I mean operations performed for when matched or not-matched conditions). My question is whether the whole merge process will be one transaction or each row comparison/operation will be one transaction? Appreciate if any document to prove it. thanks in advance, George

  Read the article

• SQL Count in View as column

  - by alex

  I'm trying to get the result of a COUNT as a column in my view. Please see the below query for a demo of the kind of thing I want (this is just for demo purposes) SELECT ProductID, Name, Description, Price, (SELECT COUNT(*) FROM ord WHERE ord.ProductID = prod.ProductID) AS TotalNumberOfOrders FROM tblProducts prod LEFT JOIN tblOrders ord ON prod.ProductID = ord.ProductID This obviously isn't working... but I was wondering what the correct way of doing this would be?

  Read the article

• In SQL server, to convert a varchar which have this format (nnn:nn:nn)

  - by user1688917

  I have this varchar format as time accumulation and i want to convert it to an integer to do a SUM and get the total time for a group. The fist part which may be 1, 2, 3, 4 or even five digits represent the accumulation of Hours and then seperated by a colon. then come the second part which is accumulation of minutes and last accumulation of seconds (2 digits each). How to convert this to integer in one query if possile.

  Read the article

• Have PL/SQL Outputs in Real Time.

  - by martilyo

  Is it possible to have Outputs from PL/SQL in real time? I have a pretty huge package that runs for more than an hour and I'd like to see where the package is at a particular time. Anyways, I currently do this with a log table, which gets filled up with hundreds of log descriptions per run, I'm just curious if this is possible. Thanks!

  Read the article

• Wb service interface for SQL reporting service

  - by SonOfOmer

  Hi everyone, I want to make web service that will be interface for SQL reporting service. I really do not know much about that, I need some guidelines in order to solve this. Any help or suggestion would be helpful. Thanks a lot.

  Read the article

• Tell SQL Server the error is "handled" in try...catch

  - by Restless Archer

  Hi. I'd like to indicate to SQL Server 2005, in my BEGIN CATCH...END CATCH block that the error is "handled"... That is, clear the error. Is that possible?? Thanks. A.

  Read the article

• Invalid authorization specification error with Classic ASP accessing SQL Server

  - by Scott

  Hi, I am getting the following error: Invalid authorization specification I've narrowed down the error to my connection string. I have verified the server name, database, user & password are correct. Here is the string: "Provider=SQLOLEDB;Server=xxxxx.db.12345.hostedresource.com;Database=foo;UID=fooUser;PWD=fooPW" The SQL server is hosted on Godaddy so I don't have access to its settings. Please help, I've scoured the internet for a solution!

  Read the article

• SQL Server 2005-data count

  - by megala

  hi i created project using asp.net and sql server 2005.I created table and inserted datainto sqlserver 2005. but i dont how to find the(count) number of records stored in the table.how to find this?

  Read the article

< Previous Page | 320 321 322 323 324 325 326 327 328 329 330 331  | Next Page >