sql

Changing the CommandTimeout in SQL Management studio

So far i have found how to change the ConnectionTimeout... But how can i change the CommandTimeout in SQL Management studio? ...

Random Records & SQL2005 Stored Procedure Insert

Hi, I need to submit data from a form to an SQL2005 database via a stored procedure. The difficult part is that i also need to get 5 random records from a secondary table and insert these as part of the inserted record in table 1. My structure is akin to this: Tbl_Organisations (table to get the 5 random records from) Key | organis...

Understanding Update and Delete Rules for Relationships in SSMS 2008

Hello everyone, I am confused about what means the update and delete rule in SQL Server 2008 Management Studio when we define foreign key constraints. I also did not find related help documents (e.g. F1 help). Here is the screen snapshot. Appreciate if anyone could describe what do they mean and recommend some related documents to read...

sql query:using insert and where query together

i have a table like this: name code group john 12 smith 15 how do i insert group for a specified row?? say for 'smith' i have to insert the group.. i tried d following: INSERT INTO table (group) VALUES ('usher') where code =15 error: Incorrect syntax near the keyword 'where'. please help!! thanx in anicipat...

Alias parameters in SSIS

I am using an OLE DB command in SSIS for which the SQL command looks like this: UPDATE DBO.CLIENT SET TimeZoneID = ?, DaylightSavingTime = ?, ModifiedBy = ?, MicrosPropertyID = ?, IsOffline = ?, GlobalReporting_MaskPatronNumberType = ?, GlobalReporting_PatronNumberReadableCharacters = ?, GlobalReporting_M...

Setting the model to a QTableWidget

I want to write an application that can access a table in the database. I took QSqlTableModel as model component for the table. The problem with the QTableView is that it seems to have no method that returns the currently selected record in the table so i took the QTableWidget class which interhits QTableView. But when i try to set the...

Is there integer ranges for Where Clause?

I need to check that result of expression in where clause is in range of Integers. something lke this: select * from table where (col1 / col2 ) in (1..8). (1..8) - means range of integers. I mean that it must be integer, not float. So that I cant use "between 1 and 8", because 1.2 will be correct. Are there any thought? ...

Error in SQL UPDATE query

$result = mysql_query("UPDATE categories SET cd_title='$docuTitle' , cd_link='$linkTitle' WHERE c_name='$catID'"); What is wrong with this update query? ...

How do I create parametrized XPath queries in SQL server?

I am trying to write a parametrized query in SQL server that uses a parameter value as part of the XPath, however it does not seem to work the way I would expect it to. Here is my sample: create table ##example (xmltest xml) declare @LanguagePath varchar(75) set @LanguagePath = '(/languages/language[@id="en-US"])[1]' insert into ##ex...

How do I update two tables that have a reference table in SQL Server?

I have 3 tables. 1. Users 4 Cols UserID - UserName - RealName - Flags 2. UsersGroups 2 Cols UserID - GroupID 3. Groups 3 Cols GroupID - GroupName - Flags What I want to do is select a specific UserName ie USERA and update the Flags column. but I also want to update the Flags column in the Groups table to the same value. The only co...

Ambiguous column name error, how do I fix it?

1. Users 4 Cols UserID - UserName - RealName - Flags 2. UsersGroups 2 Cols UserID - GroupID 3. Groups 3 Cols GroupID - GroupName - Flags What I want to do is select a specific UserName ie USERA and update the Flags column. but I also want to update the Flags column in the Groups table to the same value. UPDATE dbo.Users SET Flags = ...

LFL sales query in SQL

This might seem a bit like a do-my-homework-for-me question (and it is), but I think that the sales results I’m trying to get are fairly generic and will be useful for anyone doing sales reporting. I have a basic Sales table (fields: Branch, DateOfSale, SalesAmount) in SQL Server 2005 and I need to build a report with the data in that t...

MediaWiki: how to get the last N edited articles by a user?

Using PHP and MySQL, I am integrating a site with a wiki based on MediaWiki, so that profiles of users in the site have some stats about their contributions in the wiki. I want to show the last 3 edited articles of a user in a namespace (the main one, id 0), without repeating, and the links to them. In order to do that, I do more or l...

what event handles all controls on a form in Microsoft Access 2003?

Can some please look at the below for me and advice what i am doing wrong. I am trying to run a sql query based on data selected from comboboxes on a form, results of which are generated in a subform attached to the main form Private Sub Form_AfterUpdate() Dim LSQL As String Dim cmb As ComboBox Dim txt As TextBox Dim chk As CheckBox Fo...

How to Ignore "Duplicate Key" error in T-SQL (SQL Server)

I have a transaction that contains multiple SQL Statements (INSERT, UPDATE and/or DELETES). When executing, I want to ignore Duplicate Error statements and continue onto the next statement. What's the best way of doing that? Thanks in Advance. ...

what does one to one table mapping mean?

I heard this phrase when I was listening to dot net rocks this morning. apparently linq to sql only supports one to one table mapping. ...

When should I use Cross Apply over Inner Join?

What is the main purpose of using CROSS APPLY? I have read (vaguely, through posts on the Internet) that cross apply can be more efficient when selecting over large data sets if you are partitioning. (Paging comes to mind) I also know that CROSS APPLY doesn't require a UDF as the right-table. In most INNER JOIN queries (one-to-many re...

create an auto-incrementing result column in oracle

I'm trying to produce the following results: emp_no, book_no, book_id Where emp_no and book_id are the actual columns on the table, but book_no is a value that is incremental, for example: emp_no,book_no,book_id 1234,01,AB33 1234,02,GF44 5678,01,HH78 5678,02,EE98 5678,03,JJ03 Is it possible to do this in a standard query without defin...

PHP Cookie Security Question

I have the following code that is presenting a 'word-of-the-day', As I am relatively new to php coding, I wanted to make sure that there weren't any security issues for how I am selecting from my database from the cookie value. Thanks. if ($word_of_the_day) { $wotd = $wpdb->get_results("SELECT term,definition FROM glossary WHERE ter...

informix check if table exists and then read the value

I have a table in informix (Version 11.50.UC4) called NextRecordID with just one column called id and it will have one row. What I want to do is copy this value into another table. But don't want my query to fail if this table does not exist. Something like if table NextRecordID exists then insert into sometable values ('NextRecordI...