|
|
|
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 SQL Datatypes Posted by pinney.colton NO[at]SPAM gmail.com at 3/31/2007 7:41:18 PM I have a SQL 2005 database that's created by a survey data collection
system. Users of this system are fairly non-technical and have little
to no conscious control over the datatypes. As a result, the data is
mostly stored quite inefficiently as varchars. For example, there is
data that could...more >>
The old inability to toggle/change/switch between ALTER PROCEDURE <---> CREATE PROCEDURE bug (or is it a feature?) Posted by raylopez99 at 3/31/2007 3:26:37 PM Keep in mind this is my first compiled SQL program Stored Procedure
(SP), copied from a book by Frasier Visual C++.NET in Visual Studio
2005 (Chap12). So far, so theory, except for one bug (feature?)
below. At some point I'm sure I'll be able to laugh about this, akin
to forgeting a semi-colon...more >>
Converting a date field to the month Posted by lisa.moffitt NO[at]SPAM gmail.com at 3/30/2007 1:51:13 PM How can I create a field in a view that takes a date field and
converts it to a month?
For instance, if I have a field called "CreatedOn" with a date of
'2/22/2007', how can I create another field called "Month" that will
say "February"? Is there a built-in SQL function that does this (like
us...more >>
how could I ??? Posted by any_Girl at 3/30/2007 1:46:30 PM how could I start learning SQL SERVER
Im just student
...more >>
Allowing users to truncate log file Posted by hedgracer at 3/30/2007 8:56:54 AM I would like to allow a particular user to truncate a log file in a
stored procedure that the user runs every day. At this moment the only
personnel that can truncate the log file are personnel with sysadmin
rights. Is there any way to do this in sql server 2005 without
granting this user sysadm...more >>
After Sql 2005 Install, Sql 2000 Still There Posted by pbd22 at 3/30/2007 7:21:21 AM Hi.
I just downloaded and installed Sql 2005 from the MS site.
I see that my instance of Sql 2000 is still on the same computer.
I assumed that Sql 2005 would upgrade but it didnt. Should I
simply delete my instance of 2000 or will this cause complications?
Sorry - newbie question.
...more >>
I have a database on a network drive that I use for archiving purposes, but when the server is rebooted the database becomes suspect. Posted by war_wheelan NO[at]SPAM yahoo.com at 3/30/2007 7:08:51 AM I created the db with the attached script and I am able to access it
until I reboot the server. I've tried enabling flag 1807 via the SQL
server service and the startup parameters of the instance. In all
cases the database always come up suspect after a reboot. There was
one instance where I ...more >>
Data type in audit record Posted by WombatDeath NO[at]SPAM gmail.com at 3/30/2007 3:59:21 AM Hi,
I want my application to audit any data changes (update, insert,
delete) made by the users. Rather than have an audit table mirroring
each user table, I'd prefer to have a generic structure which can log
anything. This is what I've come up with:
TABLE: audit_record
*audit_record_id (...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Combine multiple records into single row Posted by franzey at 3/29/2007 9:43:08 AM This is how the data is organized:
vID Answer
12 Satisfied
12 Marketing
12 Yes
15 Dissatisfied
15 Technology
15 No
32 Strongly Dissatisfied
32 Marketing
32 Yes
What I need to do is pull a recordset which each vID is a single row
and ...more >>
pivot table without aggregation? Posted by Mike at 3/29/2007 9:04:24 AM Hello, I have a resultset as follows:
fields: Name, RankID
values:
Prorduct A, 4
Product B, 33
Product C, 221
(etc)
Name is always unique. RankID may not be.
I want to take that result set and basically pivot it to have the Name
values as columns, and the RankID of each one as the ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |