Search Results

Search found 27850 results on 1114 pages for 'sql paging'.

Page 261/1114 | < Previous Page | 257 258 259 260 261 262 263 264 265 266 267 268 | Next Page >

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
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 error validating the default for column

- by RealityDysfunction

I am trying to set the default value for a new column I just added. In properties I am trying to set 'Default Value or Binding' to a simple XML along the lines of: <root><title>Welcome</title><body>Thank you for your time.</body></root> However, when I click away, I get "sql error validating the default for column," I set this value in other numerical columns and it worked fine. What gives?

Read the article
How to export into word format using Reporting Services (SSRS)

- by Ashish

Using Reporting services in SQL Server 2005 in asp.net with c#, how can we export reports in word document? Thanks In Advance.!!

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
Best Practice: Direct SQL Access vs. Web Service

- by phsr

With respect to an application that has both a web and desktop client version: What is the best practice for the desktop client which needs access to a SQL Server? What are the benefits of connecting to the database from the application vs using a web service? Which one provides better security? What type of scope would call for one vs the other (enterprise intranet vs. web app, etc) Are there any other considerations that are necessary when choosing on platform?

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
converting factored number to decimal in MS SQL

- by LS

I need to convert a number which gives decimals in factored format in to decimals, i.e. 11.16 is 11.5 in decimal. This is because 16 is in base of 32 and 11.16 should be read as 11+16/32 = 11.5 I get 11.16 as a string and I need to change it to 11.5 as numeric in MS SQL(2005) database. Any shorter way of doing this rather than splitting strings,converting to numerics,maths,convert to string, concatenate and then convert to numeric?

Read the article
LINQ to SQL table naming

- by Ivo

I am using VS2010 and C# When I map/select my database tables with LINQ to SQL I have to option to change the "member" propery, but when i delete the table (because I changed something in the schema for example) and add it again the member value gets "reset". Is it possible to set/override this member programmaticly, so that I dont have to change it by hand everytime I mean the member option of '<'Table Name="dbo.table1" Member="table1"

Read the article
Using a combo box in access to list all the available sql servers and connected databases

- by newtoaccess

Is there a way I can set up combo box in an access form to list all the available sql servers and then an associated combo box to list the related databases? Can this be done in access?

Read the article
SQL Server 2005: Subquery in EXEC ?

- by BahaiResearch.com

EXEC [dbo].[pr_cfgAddFact] @SettingName = 'TransferBatch', @RoleFK = SELECT TOP 1 rolepk FROM cfgRole WHERE cfgRole.Name = 'SuperAdmin' Why would SQL complain about the SELECT clause here? I am trying to run the proc with the sub query getting the data.

Read the article
SQL concatenate rows query

- by bobobobo

Say we have a table table posts +---------+-----------+--------------------------------+ | postId | title | status | bodyText | +---------+-----------+--------------------------------+ | 1 | Hello! | deleted | A deleted post! | | 2 | Hello 2! | deleted | Another one! | Can we, in SQL, retrieve a concatenation of a field across rows, by issuing a single query, not having to do the join up in a loop in our back-end code? Something like select title from posts group by status ; Should give "Hello!, Hello 2!"

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
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
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
What causes MSSQL to return the message 'The statement has been terminated'?

- by Wally Lawless

I have a very simple INSERT statement being executed from a PHP script running on a Linux Apache web server. I can run the query fine from within SQL Management Studio and it normally runs fine from PHP as well. However, every once in awhile I get an error message from my PHP script that the query failed and the mssql_get_last_message() function returns 'The statement has been terminated'. What sources can cause this message to be returned from MSSQL?

Read the article
SQL server datetime column filter on certain date or range of dates

- by MicMit

There is an example for today here http://stackoverflow.com/questions/2583228/get-row-where-datetime-column-today-sql-server-noob I am primarily interested in 2008 only. For today it looked like SELECT (list of fields) FROM dbo.YourTable WHERE dateValue BETWEEN CAST(GETDATE() AS DATE) AND DATEADD(DAY, 1, CAST(GETDATE() AS DATE)) What literal value of date(s) or functions ( I need a format ) should I place there to make it work independent of local settings.

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
SQL WHERE.. IN clause multiple columns

- by ala

i need to implement the following query in SQL Server select * from table1 WHERE (CM_PLAN_ID,Individual_ID) IN ( Select CM_PLAN_ID, Individual_ID From CRM_VCM_CURRENT_LEAD_STATUS Where Lead_Key = :_Lead_Key ) but the WHERE..IN clause allows only 1 column. How to compare 2 or more columns with another inner select?

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
SQL Server checking if you have access to a database

- by J Harley

Good Morning, I have connected to my SQL Server 2005 - and have managed to list all of the databases on that server. Now I would like to run a check on each database to see if I have permission to view that database.. How would I go about this? Many Thanks, Joel

Read the article
inner join in sql

- by vini

SELECT TotalItems.Total_Items ,TotalItems.No_Items_Present ,ItemsTable.No_Of_Items_Ret FROM TotalItems INNER JOIN ItemsTable ON ItemsTable.Item_Name= '" + DropItemName.SelectedValue + "'" this is my SQL query what I want is to retrieve two column values corresponding to the item I enter in my dropdown list from one table and the no_of_items_ret from another table satisfying the condition of the dropdownlist I'm getting all the values corresponding to any item I enter what should i do?

Read the article
MSSQL differential backup to SQL statements

- by noonex

Is there any way to convert differential backup to SQL statements which will produce identical results when applied? Or any other solution similar to binary log in MySQL?

Read the article
What is best tool to compare two MSSQL databases (schema and data)?

- by tomaszs

I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?

Read the article
Updating .XML through SQL server 2000

- by neeraj

Hello Everyone, I want to apply a update trigger on a table in SQL server 2000. Trigger should update .XML file present on another server. I have full access to both servers. I am unable to figure how to do it, please help me out.

Read the article

< Previous Page | 257 258 259 260 261 262 263 264 265 266 267 268 | Next Page >