Topics
Started by
Posts
Last post
Hi, I have a column with a string longer than life. 🙁 I need to take a specific part of it, I know …
6 replies
Hi, I have 10 procedures that use dynamic SQL and have the same where clause, they return different…
7 replies
Hello, I have two large related tables - parent and child The user is mostly interested in having t…
9 replies
Hi, I use encryption for my stored procedures but RedGate can decrypt it ! Whats the best way to en…
8 replies
Hi all, I am having an issue with using distinct on one single column in a table and getting multip…
6 replies
Why Try Catch doesnt catch collation exceptions? How can I handle it? BEGIN TRY IF '1' COLLATE…
7 replies
so we have three different server farms in three different locations. there's a database on each th…
3 replies
Hi, I have a table who have a number of columns. One of the columns contains an xml. How can I pars…
8 replies
Hello all, I have encountered following problem lately: when an insertion script is done via INSER…
8 replies
Used to be that you could use Visio Pro 2010 to reverse engineer an SQL Server database and create …
1 replies
I am updating Column2 with the year only from Column1. Since they both have DATE as data types, wh…
8 replies
Hi, I'm trying to implement a text search in a table's data... What I did was create a table (idRec…
3 replies
I need a sanity check on some code I've written. I have a large table (more than 100 million rows) …
5 replies
Hi I have a database table that records pH values from once per second. I want to retrieve the data…
3 replies
Hi, I have a aggregate query that calculates pass/ fail percentages. I want to be able to run it ba…
2 replies
Viewing 15 topics - 2,236 through 2,250 (of 3,067 total)
You must be logged in to create new topics.