Topics
Started by
Posts
Last post
I am trying to figure out a way to write a query with only one LIKE or PATINDEX statement in t…
3 replies
I am an application developer using VB6 with SQL Server 2000. Often in my code, I begin Transaction…
3 replies
A lot of answers are mentioning that LEFT OUTER JOINs are slow and sometimes indeed they are. But w…
17 replies
I have two tables Table A Table B Both tables have the following four columns School Code School n…
14 replies
Gud day im using sp_change_users_login 'report' command to display all the orphaned users in each d…
9 replies
We use the BETWEEN operator to find data in character ranges. We just came across a situation wher…
9 replies
if object_id('tempdb..#tmpExample') is not null drop table #tmpExample create table #tmpExample (…
6 replies
I need to determine the logical names for the data and log files for a given database. The followin…
4 replies
I've moved a databse from prod to dev and a calculation on a sum of a flaot column gives a differen…
18 replies
Hello all, I have a large data table with many duplicated ID records. A portion of my data table as…
1 replies
I have some code I am writing and just wondering if this will cause some issues i.e. memory leaks e…
12 replies
We have an application where we need to determine how many "Sessions" are active at any given secon…
9 replies
Hi everyone, I need to trim a Memo field to do a string comparison. Basically, I m trying to match …
12 replies
My company has just picked up a new app and I'm trying to figure out how all the tables work togeth…
6 replies
How can I enforce a constraint on a field in a table so that it allows only the value " CAT"
5 replies
Viewing 15 topics - 3,811 through 3,825 (of 17,082 total)
You must be logged in to create new topics.