Search Results

Search found 27337 results on 1094 pages for 'sql'.

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

• SQL Error with Order By in Subquery

  - by cagin

  Hi all. i m working sql server 2005. My query is: SELECT ( SELECT COUNT(1) FROM Seanslar WHERE MONTH(tarihi) = 4 GROUP BY refKlinik_id ORDER BY refKlinik_id) as dorduncuay And the error: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. How can i use order by in a sub query?

  Read the article

• Scope of Derived Tables in SQL Server

  - by FailBoy

  I've been looking into SQL recently and exploring a bit. in regards to Temp Tables I have discovered 3 different temp table types: 1) CREATE TABLE #TempTable 2) DECLARE TABLE @TempTable 3) SELECT * FROM (SELECT * FROM Customers) AS TempTable Now I understand the scope behind the #TempTable and the @TempTable types, but what about the derived table as in example 3? Where does this derived table get stored? and if it is declared in 1 transaction, can a 2nd transaction access it, or is the scoping of Derived Tables that same as example 1 and 2?

  Read the article

• How to configure reference to be deleted on parent table update?

  - by abatishchev

  I have two tables: info: ID, fee_id and fee: ID, amount and a reference between them (SQL Server 2008): ALTER TABLE info WITH CHECK ADD CONSTRAINT FK_info_fee FOREIGN KEY(fee_id) REFERENCES fee (ID) ALTER TABLE info CHECK CONSTRAINT FK_info_fee GO How to configure this reference that way so a record in fee will be deleted if info.fee_id becomes NULL

  Read the article

• How to test if a MS SQL 2008 database can serve 200 concurent users

  - by sh00

  I have a MS SQL 2008 database in 3NF. I must check if the db can support many concurent users. Which is the best method ? [Is there any free tool to do this ?] Thank you very much.

  Read the article

• is there any different in Connection string between SQL server Authentication and Windows Authentic

  - by Gold

  hi is there any different in Connection string between SQL server Authentication and Windows Authentication if yes, can i get a sample connection string for this ? thank's in advance

  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

• node to traverse cannot be null (Hibernate SQL)

  - by tiswas

  I'm performing a SQL query through hibernate, which looks like: SELECT thi FROM track_history_items thi JOIN artists art ON thi.artist_id = art.id WHERE thi.type = "TrackBroadcast" GROUP BY art.name ORDER thi.createdAt DESC but I'm getting the message that 'Node to traverse cannot be null!'. Anyone know what could be causing this? --EDIT-- I'm pretty sure that this problem is being caused by the possibility of artist_id to be null. However, I can't prevent this, so can I just skip the rows track_history_item rows which have a null artist_id?

  Read the article

• Best naming for a column in a SQL Server table

  - by Lance Fisher

  Which of the following three options would you choose for a column name in a SQL Server table, and why? YearToDateWages YTDWages YtdWages Follow up: SSN Ssn SocialSecurityNumber

  Read the article

• compiling a linq to sql query

  - by frenchie

  Hi, I have queries that are built like this: public static List<MyObjectModel> GetData (int MyParam) { using (DataModel MyModelDC = new DataModel()) { var MyQuery = from.... select MyObjectModel { ...} } return new List<MyObjectModel> (MyQuery) } } It seems that using compiled linq-to-sql queries are about as fast as stored procedures and so the goal is to convert these queries into compiled queries. What's the syntax for this? Thanks.

  Read the article

• Formating SQL XML-field in gridview

  - by Godisemo

  Hi, I have a SQL table with some normal fields and one xml-type field. I need help with formatting the xml-type field. I want to display the the information in a gridview in asp.net but i want to apply formatting to it. Does anyone know how I need to do? Thanks. PS. If it's to any help, I use a linqdatasource as source to my gridview.

  Read the article

• displaying sql exception in JSF

  - by user234194

  I was wondering how would I be able to show SQL errors generated during update, delete, select * etc in JSF. Any help would be appreciated.

  Read the article

• Setting a variable for a Z SQL method

  - by Nathan Friend

  In Plone I have a Z SQL methood: SELECT [aapp_qtitle] ,[aapp_mtitle] ,[aapp_sdate] ,[aapp_duration] FROM [AAPP].[dbo].[M_PageBodyElement] where [aapp_id]=<dtml-sqlvar aapp_id type=int> How can I set the value of aapp_id in my Plone page code?

  Read the article

• LINQ to Entities, SQL Server version and setting ProviderManifestToken at runtime

  - by chris

  We have developers some developers who are developing against a SQL Server 2005 database, while others are using 2008. We just discovered that generating the edmx against a 2008 database set the ProviderManifestToken to 2008, which means some queries won't work against a 2005 database. While this is a known issue, is there any way to set this value at run time, based on a config file?

  Read the article

• SQL Problem, WHERE Statment is wrong

  - by stck777

  $sql = 'SELECT id, DATE_FORMAT(date,"%d.%m.%Y - %H.%i Uhr") AS dat, user1, user2, p_user1, p_user2, be_user1, be_user2, win FROM kok_1on1_matches WHERE user1="$user" OR user2="$user"'; What is wrong with the WHERE statement?

  Read the article

• Write a SQL to meet my requirement.

  - by rgksugan

  I have been trying to solve this problem for a lot of days. But wouldn't. Please help me. I need a SQL to list product_code, product_name, qty_sold, last_order_date for all the products that have been sold within a date range sorted by the number of quantity sold. My Table structure: tbl_product(product_id,product_code,product_name) tbl_order_detail(order_item_id,order_id,product_id,quantity) tbl_order(order_id,order_date)

  Read the article

• MS SQL to PostgreSql

  - by Dezigo

  I need to create a trigger in MS SQL. Trigger works: If I found new line where T = 'A'; than.. add this line to PostgreSQL table. Is it possible to create it,without software? (I know how to create trigger,but how to create connection between two servers..?

  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

• Swap values for two rows in the same table in SQL Server

  - by AmRoSH

  I have table and I want to swap the values from two rows. I have the rows IDs of the two rows. Is there any query to do that? Here is an example. Before the query I have this: row1 : 1,2,3 row2 : 5,6,7 After the swap I want this: row1 : 5,6,7 row2 : 1,2,3 I don't want write it in .NET code because I think an SQL query is easier than that.

  Read the article

• How to perform a select using a WHERE NOT EXISTS

  - by Peter Bridger

  I'm using LINQ2SQL and I want to compare two tables and select all rows that are missing from one tables (based upon one of the column values). In standard SQL I would write this as: SELECT FirstName, LastName, RefId, Email FROM Users_ActiveDirectory AS ADU WHERE NOT EXISTS ( SELECT U.RefId FROM Users AS U WHERE U.RefID = ADU.RefId ) However I'm not sure how to achieve the same result using LINQ2SQL?

  Read the article

• Good websites for learning SQL 2005

  - by Nasif

  Hi Friends, Could anybody help me by giving some good websites that are describing about T-SQL commands. I am a new guy in this field. thanks in advance..

  Read the article

• Windows workflow foundation published as a web service and Sql Service persistance

  - by wissem

  Hi i try to add persistance to my workflow using sql service persistance and all i know is how to add Persistence Service to the Workflow Runtime using code in the host app but what if i have the workflow as web service how can i add persistance..??? Thanks

  Read the article

• SQL clone record with a unique index

  - by Milhous

  Is there a clean way of cloning a record in SQL that has an index(auto increment). I want to clone all the fields except the index. I currently have to enumerate every field, and use that in an insert select, and I would rather not explicitly list all of the fields, as they may change over time.

  Read the article

• copy a table with data to another db in sql server 2005 express

  - by Luca Romagnoli

  hi, i've a db with a table. i want copy it with the data in another db. How can i do it in sql server 2005 express? thanks

  Read the article

• Saving russian text in SQL server

  - by JD

  Hi, I have a database (SQL server express 2008) which has a column that is defined as text. When we try to store some text which is in chinese, it is not saved. I read that the field should be ntext. I will now have to a conversion to my table to create the column as ntext. Would I have to do anything with the collation of the database which is set to Latin? JD

  Read the article

• SQL Server Query Command

  - by Scott Jackson

  Hi, I have an SQL database table, I want to find everything in a table where the 'Room' says 'DISPOSED', Insert 'DISPOSED' into the 'Status' field and then delete the entry in 'Room'. Basically moving the entry from one field to another (if the 'Room' field has 'DISPOSED' in it) Hope this makes sense. Thanks for any help.

  Read the article

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