Topics
Started by
Posts
Last post
Well I think it is a different question because I haven't seen it asked. If I do not have a join, I…
4 replies
I was wondering why there wasn't a sys.functions view similar to sys.procedures,sys.tables and sys…
11 replies
Hi I have a parameter called program it goes through and does its select, then in the where it has…
1 replies
I'm needing to store a SQL statement in a VARCHAR(MAX) column in a database table, however I'm havi…
4 replies
Can there be an FK for a single column referencing only one column of a multiple primary key constr…
4 replies
Hi, I am writing a query to find duplicate records in a table, My question is should I use Inner, L…
10 replies
I think I'm confused ... I set DB to Full Recovery Model. I have a DB backup once a day and log bac…
3 replies
hi, i need to group people who weight more less than 200 ordered by age (from the oldest to the you…
23 replies
Hi, I have 2 tables Table Member with columns A B C D apple bread carrot…
7 replies
Scenario is that I want to have a primary key to identify a new entry in a main table. Call it "rec…
9 replies
Is there a difference between a 'covering' index and an index with 'included' columns - or is that …
4 replies
Here is my scenario, The user puts in a customerID, possible start and end date and selects a statu…
5 replies
Hi, What are the difference between CDC and Change Tracking? Which is more efficient and less resou…
4 replies
We have a SQL Job that calls an SSIS package. This package used to take about 10 minutes to run. …
2 replies
I have a table that contain a row table name = PMInfo pmid,member 1, jay-raj-kit i want output like…
6 replies
Viewing 15 topics - 11,956 through 11,970 (of 30,222 total)
You must be logged in to create new topics.