Search Results

Search found 47861 results on 1915 pages for 'sql update'.

Page 287/1915 | < Previous Page | 283 284 285 286 287 288 289 290 291 292 293 294  | Next Page >

• 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

• 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

• 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

• Multi table Triggers ms sql noob

  - by Chin

  I have a load of tables all with the same 2 datetime columns (lastModDate, dateAdded). I am wondering if I can set up global Insert Update trigger for these tables to set the datetime values. Or if not, what approaches are there? Any pointers much appreciated

  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

• 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

• Split string with delimiter in sql server

  - by Renju

  I'm having a coloumn name with varchar field that holds some folder path like "C:\Program Files\Internet Explorer\en-US" .I need to update the root folder name(Program files to profilesNew).Can anyone please help. I tried with a query declare @val as varchar(100) set @val='C:\Program Files\Internet Explorer\en-US' select substring(@val,charindex(':\',@val),charindex('\',@val)) but not getting the exact answer C:\Program FilesNew\Internet Explorer\en-US

  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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Multi table Triggers SQL Server noob

  - by Chin

  I have a load of tables all with the same 2 datetime columns (lastModDate, dateAdded). I am wondering if I can set up global Insert Update trigger for these tables to set the datetime values. Or if not, what approaches are there? Any pointers much appreciated

  Read the article

• How do to massively alter primary keys to tables in sql server database

  - by shuxer

  Hi Is there any way to massively alter primary keys(uid) to all tables with no primary primary keys in sql server database ? I have a lot of tables and most of them don not have primary keys. Thanks in advance.

  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

• 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

• Recommended SQL Practice and Books

  - by John Hpa

  Hi, Please recommend me some books and practices for me. I am quite weak in SQL though not that bad in C# and VB.NET. 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

• How to parse SQL files using C# ?

  - by Sunil Agarwal

  Hi, Can anyone please help me? I am having bunch of .sql files. I want to parse (validate) those files before executing them on server. I have many online sites which parse the code. But I want to parse the code using C#. So please can you guide. If there is any tool, dll I need to use. I just want to parse the file and not execute it

  Read the article

• How can I count and group by between two date?

  - by user359991

  For example, the start date = '20100530' and the end date = '20100602' How can I write a SQL to display the below result? month: may, 2 days month: June, 2 days

  Read the article

< Previous Page | 283 284 285 286 287 288 289 290 291 292 293 294  | Next Page >