Topics
Started by
Posts
Last post
Hi, I want to write an update query that will call a stored procedure for every record on a table, …
3 replies
Ok, I ran across this so I thought I would post it. DECLARE @TestString VARCHAR(100) ,@StringLe…
4 replies
Any suggestions on how to search and replace using an ntext column in a table?
3 replies
Does anyone know how to get query duration as part of the result of a query? Similar to the way we…
4 replies
Hello all: Is it possible to find all the user stored procedures that have been updated after a ce…
5 replies
I'm attempting to write a T-SQL procedure that will take the results from a system stored procedure…
4 replies
Hi, I have the following 2 tables; The first stores documents as BLOB's the second allows a rela…
2 replies
I need to audit a table using instead of update trigger. Since this update trigger will fire inste…
9 replies
The "UPDATETEXT function" on the second last line below returns the following error intermittently …
2 replies
the following statement doesnt seem to work: select gym + park + hall as mysum, 3 * mysum + 56 as m…
2 replies
I have a brain teaser for you. I want to update a field(MonthEndInd) in a table(indate_count). I ne…
2 replies
I have a table X with two columns date and hits. This table may have few milllion records. Sample d…
2 replies
How do i get a list of all indexes (names and columns it indexes) in a database? sp_indexes doesn't…
4 replies
I'm pretty strict about not allowing dynamic SQL within our applications, and using parameters inst…
6 replies
what is the quickest way to obtain the max(id) from a table with over 50 million rows? Currently th…
11 replies
Viewing 15 topics - 14,641 through 14,655 (of 17,082 total)
You must be logged in to create new topics.