|
|
|
January 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 |
Filter by week: 1 2 3 4 5 How can I create a cool data model table map? Posted by serge at 10/14/2006 12:53:20 PM I first got this map from SQL Server Magazine subscription. Now i
see it's available to download as a PDF from Microsoft.
http://www.microsoft.com/downloads/details.aspx?familyid=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en
I've just installed Visual Studio Team Edition for Database ...more >>
user defined funcyions in sql server 2000 Posted by shark at 10/14/2006 5:27:33 AM hi,
it might be a very stupid question but i want to know whether an
execution plan is created in user defined functions in sql server 2000
like stored procedures.
Thanks.
...more >>
viable question Posted by adamwalan NO[at]SPAM yahoo.com at 10/13/2006 8:13:34 PM Why this always returning 'AAA'
declare @ss char(20)
set @ss='AAA'
set @ss=@ss+'BBB'
print @ss
...more >>
Select Range Posted by wtfbrb NO[at]SPAM yahoo.com at 10/13/2006 12:46:34 PM I have a select that is grouped by building/bedrooms and I have a range
for the rent
Select Building,BR,drpBuilding.buildID,
'$' + Cast(Min(Rent/BR) as varchar(10)) + '-' + Cast(MAX(Rent/BR) as
varchar(10)) as 'PerPerson'
FROM Apt JOIN drpBuilding ON
Apt.buildID = drpBuilding.buildID
Grou...more >>
weird database back up sizes Posted by d.grabov NO[at]SPAM gmail.com at 10/13/2006 12:38:34 PM I've got a 9gig DB which when backed up using the gui comes to 5gigs.
When backed using the SQL "backup database" command it comes to 20gigs.
Can someone suggest a good reason for the difference?
...more >>
OPENING FOR MAIN FRAME DEVELOPER Posted by RAM at 10/13/2006 10:52:41 AM
Mainframe developer
Duration : 6 months
Location : Raleigh, NC
Start Date :- ASAP
Skills:
=A7 Writing code using Websphere MQ in COBOL programs and 10 years of
recent experience in the design and coding of batch and CICS COBOL
programs, using VSAM files
=A7 TSO/ISPF developmen...more >>
Return percentages in the query. Posted by sqlservernewbie NO[at]SPAM yahoo.com at 10/13/2006 9:27:49 AM Hello,
I'm trying to something that just works in Oracle, but does not in Sql
Server.
How can I get the percentage of two counts to be returned on each row
of the query?
select count(sid), /* all not the not null */
count(*),
(count(sid) / count(*) ) as percent_not_null,
4 as four...more >>
Using trigger to notify an assembly of changes. Posted by simo at 10/12/2006 7:31:52 PM
I have a requirement to create a sorted list of objects, stored within
an assembly, and I would like to use a After Insert/Update trigger to
notify that assembly that something has changed, rather than polling
the database for changes all the time.
My initial problem is that I need to create...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Case Statement in Where Clause Posted by paulmac106 NO[at]SPAM gmail.com at 10/12/2006 2:50:16 PM If you could help me with my syntax i would really appreciate
it. I'm trying to change the where clause on the fly, but it's
giving me a syntax error.
Hopefully from what I have below you can tell what i'm after
the first part should evaluate a boolean expression, then if true,
search using...more >>
Processor licensing Posted by Enorme Vigenti at 10/12/2006 2:14:40 PM In the processor licensing mode a license is required for each physical
or virtual processor like explained in
http://www.microsoft.com/sql/howtobuy/default.mspx
->But what about dual core processor?
->And what about clustering? (if a user install 2 server in cluster mode)
tnx...more >>
T-SQL (Stored Procedure) upgrade from 7 to 2005 Posted by Z at 10/12/2006 11:04:59 AM Hi,
I'd like to know if anyone has had experience upgrading their stored
procedures directly from 7 over to 2005, and what issues they've run
into.
Also, if there are any articles available on this subject, could
someone please point me in the right direction?
Thanks!!
...more >>
Subquery in DTS No Longer Works After Years Posted by Docster2005 NO[at]SPAM gmail.com at 10/12/2006 5:50:20 AM Hi folks,
A DTS package we have run for years now no longer works. The specific
part that is not working is a subquery in the SOURCE object of a
transformation. The source is based on a Microsoft Data Link to a
Sybase database (DSN changed a couple months ago but the connection
string was u...more >>
table copy Posted by GTi at 10/12/2006 1:26:01 AM I have two identical tables with one IDENTITY column and several other
columns.
I have tested the COPY * INTO table2 FROM table1 WHERE xx
but it requers that table2 does not exist.
TABLE2 is a history database of TABLE1
How can I copy row(s) from table1 to table2 without conflict with
IDENTITY...more >>
user/schema problem in SQL Server 2005! Posted by Amber at 10/11/2006 5:47:23 PM do the following steps:
1:Use Manage Studio login the server with Integrated security.
2:Create a dabase named testdb;
3:Create a SQL Server login named amber ,and set it to be dbowner of
testdb;
4:Create a SQL Server login named guxiaobo ,set it's default databse to
be testbd,and in...more >>
Is there a way to view Stored Procedure, Trigger andFunction Usage in SQL Server? Posted by marcsirois NO[at]SPAM gmail.com at 10/11/2006 12:28:28 PM I am maintaining an application where most of the business rules are in
Triggers, Stored Procedures and User Defined Functions. When a bug
arises, it can get very tedious to debug. Today for example, I wanted
to modify a function that was being called by a trigger. The problem
is that I don't...more >>
complex(?) query Posted by alex at 10/11/2006 11:07:32 AM Hello experts.
I'm a novice sql writer and need some help in writing a query to
extract applicable data from the following table (titled EMPLOYEE):
--
ID_NUMBER CODE DATE
------------------ --------- --------
12 VO 20060914
12 XD 2006091...more >>
SQL 2005 Processor VS Cal Posted by stuartmcneil NO[at]SPAM utdgroup.com at 10/11/2006 9:13:19 AM Does anyone know what microsoft means when it claims that SQL 2005 in
processor licensing mode is optimized for web use?
Stuart
...more >>
Query Assistance Needed - Please Posted by Andrew Tatum at 10/11/2006 7:24:21 AM Alright, I have this table called Tags. The three columns of interest
are Tags.Id, Tags.Name, Tags.ParentTagId
This is the query I am currently using:
Select Tags.Id, Tags.Name, Tags.ParentTagId
>From Tags
WHERE Tags.Id IN (
22536,
22535
)
This outputs to:
Id Name ...more >>
Query Assistance Needed - Please Posted by Andrew Tatum at 10/11/2006 7:19:39 AM Alright, I have this table called Tags. The three columns of interest
are Tags.Id, Tags.Name, Tags.ParentTagId
This is the query I am currently using:
Select Tags.Id, Tags.Name, Tags.ParentTagId
>From Tags
WHERE Tags.Id IN (
22536,
22535
)
This outputs to:
Id Name ...more >>
SQL WHERE CLAUSE HELP Posted by RickyZane at 10/10/2006 8:28:54 PM I need a little help with an assignment....
Basically I have a table with several PRODUCTS
PRODUCT(P_ID, P_Name, P_Class, P_Price, Product_Supplier)
Anyways....
I need to display:
List each Product Class, number of items in the class and the average
Price of the items in the class. L...more >>
clever date to find most recent .bak file Posted by jamesd at 10/10/2006 6:00:20 PM Say I have 3 .bak files named:
jamesB.bak, jamesG.bak, jamesW.bak
Is there a clever way to find out which is the most recent of these
backup files?? Using sql query analyzer preferably...
...more >>
SQL 2000 - Initiate or Force Replication Posted by Dale at 10/10/2006 10:55:16 AM Access 2000 connected to SQL 2000
Is there a way to initiate Sql Replication via code from within Access?
All Replication jobs are setup to run on demand. I would like to be
able to click a command button in Access to start the jobs.
Can someone point me in the right direction?
Thanks
...more >>
Replacement for ISAPI in SQL Server 2005 Posted by herman404 at 10/10/2006 9:46:44 AM Hi everyone, I have some code that we need to migrate to SQL Server
2005 from 2000, and I have a webpage that upon viewing, fires a query
to the SQL server using ISS and ISAPI. The result set is formatted for
display using XSLT. But since ISAPI is deprecated in SQL 2005, I was
wondering how to m...more >>
Text too long to be edited Posted by JA at 10/10/2006 2:11:03 AM Hi,
I asked this in an MS Access newsgroup, but no one has answered. Since it
also applies to SQL Server, maybe someone in here has an answer? I actually
do have the same problem in both SQL Server 2000 and Access 2000.
When I click in certain records in a memo field, I get the error messa...more >>
Compare record count in table1 to qty in table2? Posted by rdraider at 10/10/2006 1:08:33 AM We have an inventory table (Items) that contains item_no and qty_on_hand
fields.
Another table (Item_Serial) contains serial numbers for any item that has
serial numbers.
If an item has 10 qty_on_hand, it should have 10 records in Item_Serial, one
unique serial number for each item.
I am ...more >>
Double summation Posted by jim_geissman NO[at]SPAM countrywide.com at 10/9/2006 9:20:21 AM I have some data -- counts ID'd by location and grid East like this --
Loc East N
CA 100 3
CA 103 5
CA 109 2
CA 110 3
I'm interested in the total of N on either side of the largest gap in
Eastings.
In this case the largest gap is 6 (between 103 and 109), and the sum of
N for the 2...more >>
URGENT!!! Help needed with SQL queries Posted by jacquescallaghan NO[at]SPAM gmail.com at 10/9/2006 8:37:38 AM Hello guys, I urgently need to get the these queries. I tried REALLY
hard to solve them but unfortunately couldn't figure it out and I am
running out of deadline. PLEASE help.
This is the problem :
A database system of a Software Quality Control Centre keeps the
information about its soft...more >>
How to connect to MSSQL server from HP-UX environment Posted by Uncle Sam at 10/9/2006 7:30:56 AM Hi,
Please confirm.. is it possible to connect to MSSQL server by executing
a shell script on HP-UX (UNIX) platform.
Regards,
Uncle Sam
...more >>
how to delete lines from text file Posted by batman at 10/8/2006 8:13:33 PM i have a text file that is like:
date = OCT0606
asdf
sdaf
asdfasdgsdgh
asdfsdfasdg
START-OF-DATA
asdfasdfg
asdfgdfgsfg
sadfsdfgsa
asdfgsdfg
END-OF-DATA
asdfgalsdkdfklmlkm
asdfgasdfg
i need to clear everything from this file except the data between the
START-OF-DATA and END-OF-...more >>
sqlserver problem Posted by hkhellhkhell NO[at]SPAM hotmail.com at 10/8/2006 10:28:44 AM Hi,
I'm using dreamweaver to do some asp development with an oracle
database. I'm having trouble seeing tables that are in my own schema.
I can see several other tables in other schemas, but not my own - this
is in the dreamweaver table browser. If I do an 'advanced' query -
naming my own t...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |