SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Unable to change default Date format in SQL Server Express

  I have a problem with changing default Date format. I changed the language to British English on se…

  User_from_Europe

  1 replies

  8 years, 2 months ago

  By: Thom A

• SQL Server 2014 datetime format

  This is a part of a procedure that I have trouble with : declare @UpdateDate VARCHAR(21) , -- …

  Senchi

  1 replies

  8 years, 5 months ago

  By: Igor Micev

• SQL server lock wait issue, restart of server

  Hello all, Newbie so please bare with me. So there's a sql server 2000 which caused some issues ye…

  JnrDbaK

  1 replies

  8 years, 7 months ago

  By: HanShi

• Can I create a table in Database B from a view in Database A in a script that's using Database A?

  Example: USE DatabaseA SELECT * INTO Table1 FROM V_View1 SELECT * INTO Table2 FROM V_View2 SELECT …

  lmk1

  3 replies

  8 years, 7 months ago

  By: viralbhatt

• Am Beginner please help

  Hi friends , I just started studying SQL , in order to improve my skill I want to install sql on my…

  annudeshmukh

  5 replies

  8 years, 8 months ago

  By: Lynn Pettis

• join error

  (select PARTY_NAME from partymst where PARTY_ST='D' AND partymst.PARTY_NO in (…

  prem2486

  2 replies

  8 years, 8 months ago

  By: Ed Wagner

• How does one create a dynamic html Email on SQL to send?

  Currently I've got a DTS package that sends out a text message when it completes. DECLARE @CRLF CHA…

  crabjoe

  6 replies

  9 years ago

  By: lfcost

• Proper and careful use of a global temp table (##temp) First time I am using

  I am dealing with huge number of transaction simultaneously accessing to get ONE ID from its primar…

  Jawid

  2 replies

  9 years, 2 months ago

  By: Jawid

• Changing Data Types

  I have a varchar field containing some data I want to report on. The SELECT statement below selects…

  bernie.perks

  3 replies

  9 years, 3 months ago

  By: bernie.perks

• Tips for practicing SQL at home

  Hello forum...my apologies if I've placed this in the wrong section. I am a product management/bus…

  DaveR-270967

  8 replies

  9 years, 3 months ago

  By: Jeff Moden

• How to interpret this code?

  I'm a newbie and trying to understand what does this code do. The only information I have about thi…

  kjayani

  1 replies

  9 years, 3 months ago

  By: Umer Akram

• Where statment and external txt file

  Dear Forum Members I am new to SQL done the first administrator course but as a platform support en…

  richieperkins

  2 replies

  9 years, 3 months ago

  By: Luis Cazares

• Where statment and external files

  Dear Forum Sorry hit post by mistake can this please be deleted?

  richieperkins

  2 replies

  9 years, 3 months ago

  By: Sean Lange

• Group by select problem

  Hi all have developed my library project counter problem when I want to get sum book status (in…

  bsasiju

  6 replies

  9 years, 6 months ago

  By: pietlinden

• Baseball Standings Calculating GB

  I am tying to set up standings for a fantasy baseball site and I dont know what I am doing to query…

  btoth

  5 replies

  9 years, 7 months ago

  By: MMartin1