SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Help with Counts

  Hello All I have a large database which I need to run a lot of counts on. Using the following cod…

  bicky1980

  120 replies

  14 years ago

  By: GSquared

• Need to know abt the batch files---Back Up Job To Veritas

  Hi, We have a job in our prod servers which runs every night. The job is to take a backup of all th…

  na1774

  3 replies

  14 years ago

  By: Revenant

• Importing an existing Excel file into a table

  Goodday, I am pretty new to SQL having just started, but i have managed to create a database with l…

  pandionk1977

  8 replies

  14 years ago

  By: Brandie Tarvin

• AD-HOC Reporting. Where Should I Start?

  Hello, I wanted to post here to get some advice on where I need to go from here. We recently adopte…

  mbagley

  9 replies

  14 years ago

  By: mbagley

• How to find which files are there in backup, without restoring?

  Hi Experts, How to find which files are there in backup, without restoring? it's not encrypted. Tha…

  jr.sqldba

  2 replies

  14 years ago

  By: jr.sqldba

• Foreign Key Constraint

  Foreign Key Constraints from different Primary key Hi I am new to sql. I have got two different tab…

  babaichatterjee

  7 replies

  14 years ago

  By: Lowell

• to enable SQL DB Mile Pro/Cons

  I am new in SQL and I want to know the reason enable SQL db Mail on the server(s). Thanks in Advanc…

  anki_14984

  2 replies

  14 years ago

  By: Chris Shaw

• Conditional

  I have a table with a Employee Status column with values 0 or 1 or 2 Instead of printing the values…

  nfpacct

  2 replies

  14 years ago

  By: mhike2hale

• image file ?????????

  -- INSERT INTO @TEMPTABLE (TAG_NAME,tag_data) select TAG_NAME = 'CUST_Photo', TAG_data = (sELECT BL…

  jbalbo

  12 replies

  14 years ago

  By: jbalbo

• Extracting parts of text from a varchar column

  I have a seemingly very tricky problem here. I have a column in a table which has what looks like X…

  pnr8uk

  5 replies

  14 years ago

  By: spaghettidba

• Normalize a SQL backend with Access 2007 front end

  I am creating a database on a sql server 2008 r2 server backend with Access 2007 as the front end. …

  kwoznica

  15 replies

  14 years ago

  By: ProofOfLife

• SSIS - Data Cleanup help please

  I am new to SSIS so this may be a simple question, but here is what i have. I migrating from an old…

  paul.hermans 47816

  7 replies

  14 years ago

  By: Revenant

• Huge backups on a small database

  This is weird. I have a database that is approximately 4 Gb, but it's daily backups are over 30 Gb …

  thotvedt

  9 replies

  14 years ago

  By: Jared

• Union returns duplicates

  This SQL is meant to show the changes that will be made, when removing a selected user's email addr…

  bevans 97934

  7 replies

  14 years ago

  By: patrickmcginnis59

• Adding Data from Excel file to SQL server

  Hello, i have to add data from the selected columns of an excel file to SQL server every month. we …

  aseel.pa

  10 replies

  14 years ago

  By: derek.colley