Andras Belokosztolszki

Forum Replies Created

Viewing 15 posts - 346 through 360 (of 1,109 total)

RE: Passing Temp table value to stored procedure from another stored procedure

Jim Russell (3/11/2008)
Andras: Re:
"On SQL Server 2008 you will be able to pass a table variable as a parameter, but SS2k8 is not yet released "
I wonder if this will...

March 11, 2008 at 6:13 am

#787895
RE: Primary Key and Unique Key on a column

kanthikumar.kota (3/11/2008)
Can i have primary key and unique key defined on a single column of a table? If so what are its advantages or disadvantages?
The short answer is that you...

March 11, 2008 at 3:01 am

#787833
RE: How to Restore Differntial Backup

salmantp2002 (3/11/2008)
Hi,
I am new in this forum.Please help me in this problem
I have 2 DataBases Test1 and Test2 .I have Taken the Test1 Full Backup...

March 11, 2008 at 2:54 am

#787831
RE: best way to delete two million rows

DBA (3/10/2008)
this table is coming from a tables which is used to insert rows every second. i have already a job in which rows get inserted from table1 where...

March 10, 2008 at 11:07 am

#787506
RE: best way to delete two million rows

So now that the problem of deleting the rows is solved, I must ask the question about why you would like to schedule to run this every five minutes. Isn't...

March 10, 2008 at 10:39 am

#787486
RE: best way to delete two million rows

DBA (3/10/2008)
yes i am so sorry i am working on a sql server 2000, so then how would i just get the top 100?
You could issue the statement:
SET ROWCOUNT 100
delete...

March 10, 2008 at 9:45 am

#787451
RE: best way to delete two million rows

DBA (3/10/2008)
hi again, Server: Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'top'.
when i try to run the loop query, any idea why?
Are you running on...

March 10, 2008 at 9:42 am

#787449
RE: can we see all database tables

jagpalsingh4 (3/10/2008)
hi ,
can we all all database tables with single query.
thaxxx
regards
jagpal singh
Phillip's code is the one that I'd prefer on SQL Server 2005 and later, but if you also...

March 10, 2008 at 9:33 am

#787440
RE: best way to delete two million rows

Looks good, assuming that the index you are disabling is a non-clustered index. Also, delete statements do not need the "*" part.
Regards,
Andras

March 10, 2008 at 8:06 am

#787372
RE: Create table with number of columns in a parameter

nicolas.pages (3/10/2008)
All right, thanks for that answer. The only thing is I am using sql server 2000, so i need to look if pivoting tables is possible there, but i...

March 10, 2008 at 7:33 am

#787353
RE: best way to delete two million rows

DBA (3/10/2008)
hi guys, what is the best way to delete two million rows from a table that the date created is after january 5th?, someone told me to do an...

March 10, 2008 at 6:50 am

#787331
RE: Restore database backup files into database

MD (3/10/2008)
Andras
Good point, but the poster said he had a backup. I suspect as you, that he has at least one CSV file that needs to be imported, not...

March 10, 2008 at 6:44 am

#787326
RE: Create table with number of columns in a parameter

nicolas.pages (3/10/2008)
Hi and thanks for your answer. I am actually trying to create a report using SQL Reporting Services Server, that would take as parameters the begin date and end...

March 10, 2008 at 4:41 am

#787260
RE: Passing Temp table value to stored procedure from another stored procedure

BTW, Jeff explicitly mentioned the same worries I have about using temp tables in the above way. Would you mind telling us what you are trying to do? There may...

March 10, 2008 at 4:33 am

#787256
RE: Passing Temp table value to stored procedure from another stored procedure

guptaopus (3/10/2008)
Hi,
My senerio is...
CREATE PROC p1
AS
CREATE TABLE #foo ( a INT )
EXEC p2
go
CREATE PROC p2
AS
SELECT *
FROM ...

March 10, 2008 at 4:31 am

#787255

Viewing 15 posts - 346 through 360 (of 1,109 total)