| Groups | Blog | Home |
|
March 2003 April 2003 May 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 Which condition matced Posted by Jinsong at 3/21/2005 11:31:57 AM I have a selected statement like following
SELECT * FROM atable WHERE COLUMN1='aaa' OR COLUMN2='bbb'
Is there any way I can added a indictor to tell me a record returned
because which condition (COLUMN1='aaa' OR COLUMN2='bbb') matched? The
reason is I will have to use the return records diff...more >>
Moving data between tables Posted by Jason Williard at 3/20/2005 7:19:36 PM I am currently using a stored procedure to delete users from our database
who are considered inactive. This works great. However, we have decided
that we want to archive these users to a identical (structure) table in the
same database. To do this, I need to find an easy way to take the dat...more >>
Estimating the Size of a Database / Table Posted by SniperX at 3/19/2005 2:40:52 AM I have been looking for a copy of a tool called the 'data sizer' that could
be found in the Microsoft BackOffice 4.5 Resource Kit. I have had no luck
tracking it down.
What I would like is a tool / script / stored proc that would allow me to
estimate how large a database would be and what t...more >>
Referencing tables with the table datatype Posted by Patrick Russell at 3/18/2005 2:50:20 PM I have a table that holds an SQL database name, and a table name. I want to
parse the names and use them to reference a table in a select statement:
someting like this:
SET @DB = 'MyDB'
SET @TBL = 'MyTBL'
SET @TABLE = @DB + '.dbo.' + @TBL
SELECT * FROM @TABLE
Is there any way to ac...more >>
Web-Based front end for SQL Server? Posted by chrissmith_76 NO[at]SPAM yahoo.co.uk at 3/18/2005 9:22:39 AM Hi all,
I have a requirement to build a web-based front end for a SQL Server
back end for users to view data, input data, produce documentation,
etc.
I currently use a MS Access database (non-web-based), but need to
expand to allow access over the internet.
Can anyone suggest a product t...more >>
Where clause arguments Posted by Bob at 3/18/2005 5:48:24 AM Hello folks!
Is it true that query performance will be enhanced if you place the
arguments in your where clause in a position such that the "most
prevalent" filters are towards the left?
So if I wanted to query a table that had fields for Gender and Color
and Pants and I wanted to see peopl...more >>
Enterprise Manager Port? Posted by Shabam at 3/17/2005 3:06:04 AM What port does SQL Server Enterprise Manager need open to connect to a
remote database? I'm not finding documentation on this.
...more >>
Easiest way to copy a MS-SQL Database from one machine to another Posted by Kevin at 3/16/2005 5:56:41 PM Can anyone recommend the easiest way to get a full copy of a database from
one server to another. The servers are not part of the same organization or
network.
I have received a backup of the database created with enterprise manager but
am unable to restore it into a database of the same name ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Setting Fiscal Year Posted by Patrick Russell at 3/15/2005 9:46:08 PM Is there a way to configure a fiscal year starting on Oct 1, in SQL Server,
or do I need to create a UDF to handle conversion of quarter and week?
Thanks
Patrick
...more >>
Granting permission to bcp, bulk insert, and XP_cmdshell Posted by Paul Aspinall at 3/15/2005 12:09:35 AM Hi
What T-SQL commands need to be executed / permissions granted, in order to
grant permission to:
Granting permission to bcp, bulk insert, and XP_cmdshell
Without giving full admins.
Thanks
Paul
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |