| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 joining when they match AND DON'T? Posted by HX at 2/28/2007 1:20:43 PM I need to create a query that will pull in records from two tables when the
IDs match, and even if they don't. If there is no matching record, I need
to use the ID from table A and insert a NULL in the fields for table B.
Is this doable? If yes, how, and what is the name of this kind of que...more >>
migrating a website to a new DB Posted by gerryR at 2/27/2007 8:21:27 PM Hi all
I'm trying to setup a website using asp and sql. For the time being I'm
doing it on my home computer but when finished I'll be moving it to another
server. Will it be possible to do this considering all the database stuff
will be pointing to a differnt database?
thanks for any f...more >>
my sql2005 do not support the XML datatype!! Posted by leobowee at 2/27/2007 12:00:00 AM I made the querry like this below:
DECLARE @doc xml
SELECT @doc = '£¼Team name="Braves" /£¾'
but the SQL2005 told me that he can not find the XML datetype!
I am appriciate if someone so kind to help me!Thanks!
...more >>
Default Value or Binding in SQL SERVER 2005 for int Posted by Mumtaz at 2/26/2007 10:11:31 AM When i try to define a Default Value or Binding for an int field in sql servr
2005 while creating a new table in designer, i type either 0 or (0) but on
saving the table it gets converted to ((0)) and is not accessible by the code.
I have installed sp2 for sql server 2005 and still it gives m...more >>
Case Sensitive CharIndex without changing collations Posted by Nirmal Singh at 2/26/2007 12:00:00 AM I have the following (sample) code
Set @BaseString='ABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890+-'
Set @myLetter='c'
Set @b1=CharIndex(@myLetter, @BaseString)
@b1 is returning the value 3 instead of 29 because it is case-insensitive.
Can I change this behaviour?
Changing collations on the ins...more >>
Converting to smalldate Posted by SAC at 2/25/2007 6:47:37 AM I'm still having problems convery a char field to a small date. The char
field has something like '20070216' in it and I want to convert it to a
small date. Currently I have:
UPdate TWDHPO
Set
TWDHPO.ScheduledDateTarget =
CONVERT(varchar(10),CONVERT(smalldatetime,TWDHPO.PDDTE),101)
I...more >>
Restore SQL Server Posted by Oliver at 2/24/2007 12:00:00 AM I backed up (full backup) a table service.mdf without the service.ldf
(size 10Gb) from the live server. However, whn I restore the table to a
test server it also give me a service.ldf (same size, 10Gb) together
with the service.mdf. Is this normal? Does the contents of the
service.ldf the sa...more >>
Clear .log file Posted by Aleks at 2/23/2007 9:22:46 PM I have a MS SQL 2000 database, size is about 1 GB but the log id 4 GB, is
there a way to clear the file to reduce the file size ?
What is this file useful for ? So far I have never used it. How can I
delete content or make it smaller ?
Aleks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Express, does it limit performance? Posted by Chris at 2/23/2007 12:31:39 PM Does SQL Express limit the speed at which it will pull data?
I just converted my Access tables into SQL Express 2005. I also made some
views that are equivalent to some queries I have in Access. When I run one
of my views (in SQL Server Management Studio Express) it will take 20 seconds
f...more >>
Newbie: Sequence Number Posted by Bandit at 2/23/2007 1:22:40 AM I have made a query to add a record with increasing sequence numbers, and it
seems to work properly.
insert into mytable (SequenceNumber)
select max(SequenceNumber)+1 as SequenceNumber from transactiontable
PROBLEM 1
--------------
However I also need to add some data to the other field...more >>
SQL Query (simple) Posted by Nirmal Singh at 2/22/2007 12:00:00 AM I have a table which includes two columns LM_PostNo and LM_Empno.
I want to return all those rows where LM_PostNo has more than 1 LM_Empno.
I am using the following query (where I know this criteria applies)
select LM_PostNo,
LM_Empno,
Count(LM_...more >>
Conversion error Posted by SAC at 2/22/2007 12:00:00 AM I'm using Access as a front end and trying to convert a string like 20070213
to a smalldate field.
Here's the access code I'm using:
UPDATE TWDLIN SET TWDLIN.BOLD = "#" & Mid([twdlin].[lestdp],5,2) & "/" &
Right([twdlin].[lestdp],2) & "/" & Left([twdlin].[lestdp],4) & "#"
WHERE (((TWDLIN....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |