| Groups | Blog | Home |
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 single entries Posted by ford6 at 6/6/2004 9:21:02 PM Hello
I have a table where customer purchases are kept. What I want to do is find customers that have only one record in there, and not multiple records. Is there a way to do this in the sql?...more >>
howto? script creation of indices for existing foreign keys? Posted by Malcolm Cook at 6/6/2004 8:59:02 PM Has anyone written a sp to generate analyze foreign keys structure, compare
it to existing indices, and output the DDL need to create indices for those
FKs lacking one?
I realize that it is not always ideal to create corresponding indices, and
some decisions regarding index placement and clust...more >>
DTS doesn't copy identity, Primary Key and default value setting of columns during table copy Posted by Oscar at 6/6/2004 7:06:48 PM I want to copy some entire tables from one database to another.
When using the DTS it is able to copy the tables, however it doesn't
configure the default values, the identity setting and the primary key
setting of any column in the destination database. Therefore I have to
reconfigure that in a...more >>
How to insert into patitioned view Posted by Mike Torry at 6/6/2004 6:46:02 PM When tried to insert into partitioned view, I get error
that: "UNION ALL view is not updatable because a
partitioning column was not found."
I have checked BOL and followed the instructions to
modofied my view structure. But still can not insert new
data. Why is it so hard to do? Are there ...more >>
Lock on WHERE clause, possible? Posted by Mario Splivalo at 6/6/2004 5:40:35 PM When I issue something like this:
SELECT
*
FROM
tab1 (tablockx)
left join tab2 (tablockx)
on tab1.field1 = tab2.field2
WHERE
tab1.fieldN = something
Both tab2 and tab2 are locked, and no other transaction/batch can SELECT
untill i COMMIT/ROLLBACK above.
Can I achieve the 'tabl...more >>
getting order position Posted by tracy at 6/6/2004 1:34:18 PM Hi,
I have a table with 3 columns: ID, Number1, Number2.
Suppose I have the following data in the table:
ID NUMBER1 NUMBER2
11 50 300
12 80 100
13 30 200
What I w...more >>
Data Retrieval From Online Database - Paid Consultant Required Posted by David Gibson at 6/6/2004 11:04:06 AM Hi,
I wonder if anyone can help with the following on a fee paying basis
for the the design or development of some type of script or utility or
piece of code to do the following work.
I wish to retrieve some data from an online database that is in the
public domain. The online database has ...more >>
Middle Initial Select help Posted by Lontae Jones at 6/6/2004 10:51:02 AM Hello
I have a table called Contact1 in this table i have a column called Contact. In this Contact column I have contacts that have a middle initial. Example John A Smith ....I want to find all of the entires in my database that have first name middle initial and last name only....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
**different place for creating a new table** Posted by RM at 6/6/2004 9:43:17 AM hi
I want to create a new table "T1" in my database called "db1" in SQL
server 2000 with a db_owner user,("L1","U1")
I did it successfully in 2 ways ,but there was a difference in result:
1) I created in enterprise manager
as I logined with L1 ,and when I saw T1 in
query analyzer table list...more >>
Returning a value based on a condition Posted by RichardB at 6/6/2004 7:21:01 AM I select data for reports and sometimes want to return a new variable who's value depends on a condition. I would use this to organize headings of the report based on the condition. Here is a simple select
SELECT ProviderCode AS Provider, ProcedureCode, service_date AS ServiceDate, InsPaid+PatPaid...more >>
C# Extended Stored Procedures Posted by Bill H at 6/6/2004 12:51:02 AM I was trying to write an extended stored procedure for SQL Server 2000 using C#. I was hoping that there was a reference I could add for the ODS naespace
Bill...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |