Search Results

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

Page 284/2509 | < Previous Page | 280 281 282 283 284 285 286 287 288 289 290 291  | Next Page >

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• xml serialization and for xml sql server

  - by Hadad

  Hello, I've a SQL statement that returns a xml result, for a serialized object.I want to add a attribute to an element, that reflects the type of the object "xsi:type=table" but i don't know how?

  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

• 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 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

• 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

• 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

• Table Naming Dilemma: Singular vs. Plural Names

  - by ProfK

  Convention has it that table names should be the singular of the entity that they store attributes of. I dislike any T-SQL that requires square brackets around names, but I have renamed a Users table to the singular, forever sentencing those using the table to sometimes have to use brackets. My gut feel is that it is more correct to stay with the singular, but my gut feel is also that brackets indicate undesirables like column names with spaces in them etc. Should I stay, or should I go?

  Read the article

< Previous Page | 280 281 282 283 284 285 286 287 288 289 290 291  | Next Page >