|
|
|
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 Deferred drop Posted by Dean at 9/9/2006 9:49:53 PM Hi,
I need some clarification.=20
A few days ago, at our UG meeting, we had a discussion about some =
less-known new features in SQL Server 2005. Among these, deferred drop =
of large temporary objects - as described in =
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtemp...more >>
Trigger logic - this ok Posted by Rob at 9/9/2006 8:24:29 PM If I want the row inserted into the table regardless of whether or not the
Stored proc completes successfully, then is there any problem with employing
the following technique (placing a "commit transaction" on the first line)
?
CREATE TRIGGER testtrigger ON dbo.Orders
FOR INSERT, UPDAT...more >>
Displaying time as 1:20 PM Posted by jonefer at 9/9/2006 7:48:01 PM I managed to get my char text into a format that can now be sorted:
cast(convert(char(12),TimeOfAppt,8) as datetime) as Time
What i'm really trying to do is display it as:
1:20 PM
this must be easy?
...more >>
I have no blog Posted by --CELKO-- at 9/9/2006 7:27:48 PM
PUBLIC NOTICE:
I have no blog. I have never had a blog. I have no idea who is using
my name, postings and likeness on that "SQL Apprentice" blog.
...more >>
Views Vs Stored Procedures! Posted by Child X at 9/9/2006 4:13:31 PM Hi all,
Just a quick question about when to use views in contrast to stored
procedures.
For example, i have the following table:
Subject:
- SubjectID
- Name
- Published
- AccountID
- CreatedDt
Now my app requires to respresentations of the Data;
1) Administrators require: Subject...more >>
xml file into table Posted by UA at 9/9/2006 3:40:01 PM I have a xml file which contains nested data.
for ex. each Order has multiple order details records.
The data should go into Order table and Order Details table.
How should I parse the xml file data so that it loads into two tables using
stored procedure?...more >>
ALTER TABLE Posted by velmurugan(Internal) at 9/9/2006 3:14:33 PM HI FRENS,
I WANT TO DROP PRIMARY KEY CONSTRAINT FROM A TABLE USING
ALTER TABLE,PLEASE GIVE ME THE SYNYAX TO
DO SO.
VELMURUGAN.D
...more >>
'System.OutOfMemoryException' ? Posted by nkw at 9/9/2006 12:52:01 PM (SQL 2005 on my PC, A table with 13 million rows)
I just did
select count(*) from T13M
It ran for a while and I canceled it.
Then I tried to see what the estimated execution plan is. And I got the
follow error message. Other operations are error prone too. I had to stop and
start the ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Formatting and returning Time from Text Posted by jonefer at 9/9/2006 12:47:02 PM I'm importing a time field as datatype - char, from a text file to prevent
the DTS package from erring - for some reason, if I import it into a DateTime
field it gets an error. So bringing it in as char has worked helpe aleveate
this problem.
However, when I look through the records, I see...more >>
HOW TO CALL A USD IN A SP Posted by DEVA at 9/9/2006 12:45:07 PM HI frndz,
i have two usd then how to call these usd in a single SP
...more >>
Copying data from 2000 to 2005. Indentity insert not working Posted by Charlie NO[at]SPAM CBFC at 9/9/2006 11:54:18 AM Hi:
I'm at my wits end. When copying data from sql2000 to sql2005, identity
columns are reseeded starting with 1. I have checked indentity insert on,
but makes no difference. How the heck do copy data from 2000-2005 and
without regenerating keys?
Thanks,
Charlie
...more >>
rows to column sql server 2000 Posted by xavier.sharon NO[at]SPAM gmail.com at 9/9/2006 11:20:42 AM Hi all,
the query gives me the foll o/p as
column1 column2
A 1
B 20
C 10
D 13
E 14
but acct i want the o/p as
col1 col2 col3 col4 col5 col6 col6 col7 col8 col9
A 1 B 20 C 10...more >>
Alter Seed value of Identity column Posted by Prasad at 9/9/2006 11:12:10 AM Hi,
I want to create temporary table, say "a" which has a column say "col1"
which i wnt to be an identity for which I need to provide a seed value.
I tried the following
1. Create a Table with Identity seed,value as (1,1)
2. Tried to alter the table using "alter table a alter ...more >>
"Order By" Parameter to a Stored Procedure Posted by Alex Maghen at 9/9/2006 7:53:01 AM Can I pass a Parameter to Stored Procedure which will be the ORDER BY column
to be used in a SELECT? If so, what's the syntax?
Alex...more >>
Migrate data from Access to SQL 2005 Posted by mikepallorad NO[at]SPAM ausi.com at 9/9/2006 7:05:22 AM hello everybody
using the SSMA migration from Access 2003 to SQL 2005 is cool.
then Robert Burke saved me a lot of strain
http://blogs.msdn.com/robburke/archive/2006/05/30/610803.aspx
but i couldnt quiet understand the link to
"reproduce the data from your local tables on the remo...more >>
Migrate data from Access SQL 2005 Posted by mikepallorad NO[at]SPAM ausi.com at 9/9/2006 7:02:52 AM hello everybody
using the SSMA migration from Access 2003 to SQL 2005 is cool.
then Robert Burke saved me a lot of strain
http://blogs.msdn.com/robburke/archive/2006/05/30/610803.aspx
but i couldnt quiet understand the link to
"reproduce the data from your local tables on the remo...more >>
Can an email trigger a DTS Package? Posted by jaylou at 9/9/2006 4:27:01 AM I get an email to let me know files are ready for processing. Can I set
something up to kick off the job?
TIA,
Joe...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |