Topics
Started by
Posts
Last post
Hi All When xact_abort is set to on, do we still need if @@Error >0 rollback transaction ? Or do…
2 replies
I will try to provide as much information as I can (last time I looked like a total NUB) 🙂 DATABASE…
1 replies
I have a scenario where a temporary table is generated in a stored procedure based on an input para…
2 replies
I've gotten a request to tune some sql for a report. The actual SQL is pretty long so I won't both…
2 replies
I have the following code: DECLARE @ConsultantIDASnVarChar(50) ,@StartDtASDateTime ,@EndDt…
4 replies
I attached a query that runs fine when all of the databases on an instance are online, but when eve…
9 replies
Good day, I'm encountering a problem with the following select statements posted below: select case…
3 replies
Ok, how can I update the 3 oldest records in the table, and then return the id for those 3 records?…
4 replies
im sure this is the wrong forum, but didnt see a more relivant forum, and this one gets the most hi…
2 replies
Hello, I have for example the following information Ive generated. The table will be added to ever…
26 replies
Hai Everyone, Indexes in sql server are constructed using the b-tree data structure. I wanna make s…
1 replies
Hi, anybody knows if I have a table with a datetime column in SQL 2005, what would be the SQL state…
1 replies
Hi everyone, I have a SP1 which returns a table result set. I want to create SP2 which returns an i…
7 replies
Hi guys, just a simple question: How to Extract SP Column Names & Parameter(s) and their Datat…
11 replies
Hello, Whats the difference between CAST(15.0000000385802490 AS datetime) and CAST(15.00000…
9 replies
Viewing 15 topics - 11,221 through 11,235 (of 12,234 total)
You must be logged in to create new topics.