|
|
|
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 |
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 Using a CASE statement in a View Posted by Debra Smith at 2/18/2006 10:25:34 PM Using SQL Server 2000 to create the view. Microsoft SQL Enterprise Manager,
Microsoft Corporation. Version: 8.0
I have a table that has the following types of columns all in a single row:
Cr_Unit_01, Db_Unit_01, Cr_Unit_02, Db_Unit_02, Cr_Unit_03, Db_Unit_03,
account, account_desc
I need...more >>
Updating a column in SQL Server (text field validation) Posted by David Patrick at 2/18/2006 8:49:18 PM Hello All,
I'm looking for a way to update a column in SQL Server and the only
techniques available to me are VB Script of SQL Server tools. The problem is
I need a way to remove some text within a column, e.g.
Table = appdefs
Column = apptitle
Example of data:
apptitle = Adobe Acrobat ...more >>
Full-text search Posted by Maya at 2/18/2006 4:42:10 PM Hello, I have a full-text enabled field in my table has the following
content as an example:
"SQL Server is a comprehensive, integrated, end-to-end data solution
that empowers your people by providing a more secure, reliable, and
productive platform for enterprise data and BI applications. SQL...more >>
Keeping DB schemas synched Posted by querylous at 2/18/2006 2:41:02 PM Hi - what's the best (preferably open source or inexpensive) tool for
identifying differences (tables, columns, types, etc) between a development
database and a production one, and applying dev changes to production
automatically?
Thanks,
Chris...more >>
Access ADP integration? Posted by The Cornjerker at 2/18/2006 1:27:17 PM I'm sorry but Management Studio is slow, cumbersome and difficult to
quickly make changes while designing a new system. It is directly and
very visibly impacting my teams production. The same can be said for
developing databases though the Visual Studio IDE.
We are at our highest production ...more >>
Query question Posted by Dodo Lurker at 2/18/2006 1:26:02 PM
I have 2 tables. One table (sales) has a salesid and sales amount. The
other table (salesrep) has a salesid and name.
I want to write a query that will return the max sales amount and the name
of the salerep who's responsible for it.
The following returns the max amount for each salesre...more >>
Do I need a cursor here Posted by rocky20 at 2/18/2006 10:59:45 AM I have a web page where users can change information about themselves
and submitted to a database. The database holds these changes in the
table UserChanges. When the user completes the changes the database for
the website is updated and changes are reflected right away. The user
can then go i...more >>
Databasepropertyex problem Posted by Amish Shah at 2/18/2006 7:32:57 AM Hi
when I run this query
SELECT * FROM OPENROWSET('MSDASQL', 'DRIVER={SQL
Server};SERVER=test;UID=sa;PWD=amish;','select name,
databasepropertyex(name,''status'') as status from
master..sysdatabases') AS a
Result is
Name Status
master 0x4F004E004C0049004E004500
tempdb 0...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSSQL Mistake Posted by juokaz at 2/18/2006 5:31:56 AM
No ideas?
juokaz wrote:
> *Bad thing - it's excercie, i have only this piece of code, and in
> excercise it is said that to complete you mustnt have mssql
> knowledge... *
--
juokaz
------------------------------------------------------------------------
Posted via http://www.codec...more >>
Update is super slow 'coz of huge data and too many indexes Posted by Rock at 2/18/2006 4:18:27 AM I hv a table with
1. >30 lac records
2. >30 indexes
need to update a few columns.. it works super slow.
Pls suggest if there exists a way to make it work faster.
If I drop the indexes, run the update statement, followed by creating the
indexes again.. is it going to help?
-R...more >>
Toughy Normalization Problem Posted by Justin Weinberg at 2/18/2006 2:29:56 AM
Figure this out without using a cursor or loop that hits each record, and
I'll gladly give you a free source license of GDI+ Architect (if you want
one). See mrgsoft dot com for more info about that.
I receive a data feed into my SQL Server with the bizarre property that the
keys (called ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |