Topics
Started by
Posts
Last post
I am running an insert where I'm performing an inner join between two large tables (13 million rows…
6 replies
Hi, I am using Dynamic sql, I should passing parametar to it, I am facing a problem with parametar …
2 replies
Select RevID into #temp From OBEAVER.REV_PA.dbo.Budget Where Year(Adddate) >= 2004 group by RevI…
6 replies
A proper test for the SQL gurus who I am desperately trying to emulate:-) I have two tables; MstHor…
6 replies
SET STATISTICS IO ON will give the IO information in Message panel in Management studio. Instead I…
5 replies
Hi guys, I need your help regarding dba daily activities. Please give me what are daily activities …
5 replies
How can we get last modification date for any table through T-SQL ? Regards DBDigger Microsoft Data…
2 replies
i have two column in a table like following col1 col2 00 05 010 015 10 15 110 115 now wh…
1 replies
The URL http://msdn.microsoft.com/en-us/library/ms189797.aspx shows a TRY...CATCH block containing …
1 replies
In 1 of our logging tables i found double records which i want to delete. The problem is that i can…
7 replies
I have a Query which runs in Seconds of time for day before yesterday data or before days data ....…
9 replies
I need to do an update on a big table, and wanted to update a reasonable number of records at a tim…
13 replies
According to the BOL: The BEGIN TRANSACTION statement increments @@TRANCOUNT by 1. ROLLBACK TRANSA…
1 replies
Hi, Iam trying to figure out how to find a column in Object Explorer or in a list of Stored Proc…
5 replies
Hi friends, My question is not related to JDBC but SQL. I have dependency table as follows. ColumnA…
11 replies
Viewing 15 topics - 7,051 through 7,065 (of 12,234 total)
You must be logged in to create new topics.