|
|
|
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 29 30 Behaviour of Blk insert with NOT NULL columns Posted by Rijesh at 4/22/2007 11:18:00 PM Target environment : MS-SQL SERVER 2005 Standard Edition with SP1 [Ver. -
9.00.1399.06]
I have a table created as shown below.
create table Blk_Test_Tbl
(
Col1 bigint not null ,
Col2 varchar(100) not null ,
Col3 varchar(100) null
)
go
Note that the Col1 & 2 are ...more >>
programmatically creating a maintenance plan Posted by Don at 4/22/2007 10:20:01 PM is it possible to programmatically create a sql 2000 or sql 2005 maintenance
plan.
i need to deliver the above in an install script....more >>
database maintenance Posted by Don at 4/22/2007 8:40:03 PM I need to perform some routine database maintenance tasks.
I know these tasks can be performed by the use of the maintenance plans.
My question is whether the databse has to be set offline (i.e. whether the
clients have to stop using the database when i'm doing the maintenance)
...more >>
Help with Logic Posted by Junoti at 4/22/2007 7:08:35 PM Hello all. I am wondering if someone can help me out with the
following logic/pseudocode. I need to determine if all rows exist for
a set of criteria passed in. For instance, if I pass in 6 ids, I need
to determine if ALL 6 ids exist, no more, no less. Here are more
details to try to help what I...more >>
How make a where clause conditional on something else? Posted by Ronald S. Cook at 4/22/2007 7:02:56 PM I'm trying to make a where clause conditional on something else.
DECLARE @Something bit
SET @Something = 1
SELECT *
FROM MyTable
WHERE CASE WHEN @Something = 1 THEN MyYear = '1997'
AND CASE WHEN @Something = 2 THEN MyYear = '1998'
AND CASE WHEN @Something = 3 THEN MyYear = '1999'
...more >>
Construct ?? Posted by Paul Ilacqua at 4/22/2007 6:27:15 PM I ran into this code yesterday and have never seen anything like it, it
names 2 tables in the from statement... What is this construct called and
should it be avoided?
Thanks....
Paul
SELECT ASMLOOP.SERIAL AS SERIAL,
ASMLOOP.DCX_PN AS DCX_PN,
ASMLOOP.MAGNA_PN AS MAGNA_PN,
...more >>
I need help with formatting date and time Posted by Al at 4/22/2007 6:26:00 PM I have a field that is datetime. and I wanted to make the format of the data
in this field to show date and time upon typing the date, for example:
(01/01/2007 3:30 PM). However, every time I type the date it only shows
01/01/2007 how can I make the field show the long date format or just form...more >>
SQL Server 2000 DTS can I use global variables to rfer to tables Posted by Stevie D at 4/22/2007 2:22:03 PM Hi from a DTS newbie,
I'm trying to migrate a number of Access databases to SQL Server 2000.
One of the Access databases includes year-to-date data at the end of
each month of the financial year in a separate table. For example
myTable 2007-04 contains data for just April while myTable 2007-05...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How model for products given different attributes for different types? Posted by Ronald S. Cook at 4/22/2007 12:29:56 PM If you were data modeling for, say, Sears would you do this?...
Table: Product
Columns ProductID, ProductSKU, ProductName, ProductDescription,
ProductPrice, etc.
Table: Refridgerator
Columns: RefrigeratorID, ProductID (one to one relationship), HasIceMaker,
MaxTempSetting, etc.
Table:...more >>
Copy database Posted by Michael Tissington at 4/22/2007 11:43:16 AM Both servers are using SQL 2005. One is a hosted SQL server on the internet.
What is the best way of copying the database and data to my local SQL 2005 ?
Thanks.
...more >>
How return records with search word param like 'value1, value2'? Posted by Ronald S. Cook at 4/22/2007 9:01:02 AM Consider a table "Book" with a column named "Title" and the following
records:
Title
-----
Path to Widsom
Tom Foolery
Moby Dick
My stored proc receives a parameter of search words:
DECLARE @SearchWords nvarchar(100)
SET @SearchWords = 'tom, dick'
How can I return all titles where ...more >>
select based on criteria Posted by Eugene Anthony at 4/22/2007 8:12:14 AM Suppose I have a field called Path. Now in the column path I store a
list of filename with an extension (.flv,.jpg and so on). How do I
specify a select statement that grabs only the filename with an
extension .flv? Please note I am using ms sql 7.0.
Eugene Anthony
*** Sent via Developersde...more >>
Login performance Posted by me at 4/22/2007 3:01:18 AM What are the performance differences of authenticating via standard SQL
Sever login and integrated login? What paths are required for integrated
login and a domain account, such as is a domain controller contacted, etc?
If the number of integrated connections to SQL Server fluctuates from 1 t...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |