SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• selecting a database from a database

  Hi I have a database that is like an interface to an application. In that database there are a numb…

  erics44

  7 replies

  15 years, 4 months ago

  By: Jeffrey Williams

• dynamic sql in a table-valued function

  Hi I would like to create a table-valued function where the database used is dependant on a variabl…

  erics44

  1 replies

  15 years, 4 months ago

  By: erics44

• Trace Flags

  Is it possible to use SSMS 2008 to enable/disable trace flags? Thank you for your help.

  aldynguyen

  1 replies

  15 years, 4 months ago

  By: george sibbald

• Automated Backups for SQLServer Express

  Where can I find information on setting up automatic backups for SQLServer Express?

  david.c.holley

  5 replies

  15 years, 4 months ago

  By: 2 Tim 3:16

• Reduce the time spent on cross process communication

  Hi- I am being probably over-expecting here but anyway.. I run a stored procedure from my C# app. I…

  neelsmail

  14 replies

  15 years, 4 months ago

  By: Jeff Moden

• How to Convert Rows into Columns?

  Hi All, I have a table with the following data. ClientVisitGuid HealthIssue 1001 …

  Sahasam

  2 replies

  15 years, 4 months ago

  By: Sahasam

• Conditionally Fire Trigger

  I know that IF Update([column name]) can be used in a trigger to control the logic if a particular …

  david.c.holley

  2 replies

  15 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Table locking?

  Hi All. (Reposted from other forum area) I have table: * Web_processing_queue -- Web_processing_qu…

  mike 57299

  3 replies

  15 years, 4 months ago

  By: Jeff Moden

• Locking

  Lynn i have created this in new thread Hi Gail and other experts How does "ROWLOCK" work? I have th…

  samsql

  3 replies

  15 years, 4 months ago

  By: eko indriyawan

• write a store procedure to generate report using SSRS2005

  I created a store proc for my report in SSRS 2205 which accept multi value parameters. It accepts 3…

  hsuangie

  5 replies

  15 years, 4 months ago

  By: LutzM

• convert three fields into one datetime

  Hi everyone. I've searched up, down, left, and right but I can't make sense of the answers that I'…

  PHXHoward

  10 replies

  15 years, 4 months ago

  By: PHXHoward

• need opinion on NOLOCK

  Hi Experts, I am working on the performance tuning of a Database of a retailer. While analyzing the…

  AppSup_dba

  21 replies

  15 years, 4 months ago

  By: samsql

• Display results even when there are none.

  Hi everyone, I'm trying to build a report that will list sales information from a defined date rang…

  iklektic

  4 replies

  15 years, 4 months ago

  By: iklektic

• Stored Procedure Execution time

  Hi, I have stored procedure that use local temp table and drop it at the end of the procedure. It t…

  ayemya

  1 replies

  15 years, 4 months ago

  By: s_osborne2

• SET values to same as ID from another table, WHERE values match in another column - Is returning same value for all records, please help

  Hi I am trying to set the values of a field (dbo.temp_dentist.clinic_id - not a pk) to the same as …

  chris.rogers 6463

  3 replies

  15 years, 4 months ago

  By: Ben Teraberry