SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Left outer join in where clause

  Hi all, I have been tasked to re-write some sql2000 stored procs in preparation for moving to sql 2…

  byron.peterson

  1 replies

  17 years, 6 months ago

  By: Ken McKelvey

• Duplicate Employee Rows

  I am trying to structure a stored procedure to do the following: I have an employee table and an em…

  catherine

  3 replies

  17 years, 6 months ago

  By: toniupstny

• Need Help With a Deadlock Issue

  I have a client getting the following deadlock error: Transaction (Process ID 83) was deadlocked on…

  Frank Lain

  5 replies

  17 years, 6 months ago

  By: Gail Shaw

• Joins nightmare

  Dear All I have three tables tblStudent ---------------------------------------------- |anStudentId…

  templar-fenix

  4 replies

  17 years, 6 months ago

  By: templar-fenix

• Accessing remotely through views

  Hi All I am new to sql world. I want to access remote server database through the views on my local…

  sac-573340

  2 replies

  17 years, 6 months ago

  By: Sugesh Kumar

• incorrect syntax for building a string

  Hi experts, I am using an openquery() function which opens a linked server connection to a Pervasiv…

  rightfield

  7 replies

  17 years, 6 months ago

  By: Ramesh Saive

• System.outofmemoryexception while passing xml data to a stored procedure

  I am trying to pass xml data as ntext to a stored procedure using aps.net I get System.outofmemory …

  tome-473314

  1 replies

  17 years, 6 months ago

  By: JDixon-385826

• MS SQL server export problem

  I have a liitle problem here I am trying to export a few tables from 1 database to another. But whe…

  erik.tsomik

  3 replies

  17 years, 6 months ago

  By: JDixon-385826

• How can I search this site or its forums?

  Hello All, I am a relative newbie to SQL server as well as this site. Thank you all for the wealth…

  tony.miller

  3 replies

  17 years, 6 months ago

  By: tony.miller

• String was not recognised as a valid DateTime

  Hi i have a web app written in asp.net and c# but i am getting this error when i run my web app on …

  tadhg88

  3 replies

  17 years, 6 months ago

  By: MikeP-477808

• File Owner after Role Transition/Switchover

  Hello I have been doing the Switchover for the SQL Server 2005 db every now and then from Primary …

  gk-411903

  1 replies

  17 years, 6 months ago

  By: Mayank Khatri

• linked servers - getting all rows of a table into a temporary table

  Hi experts, What is the fastest way to get all the rows of a table from a linked server (a Pervasiv…

  rightfield

  1 replies

  17 years, 6 months ago

  By: rightfield

• datetime stamping for ModifiedDate and CreatedDate

  Hi experts, I think there is a feature in MySQL that if you put two datetime columns in a table tha…

  rightfield

  3 replies

  17 years, 6 months ago

  By: Lowell

• MAX(CreatedDate)

  Hi experts, Several rows may match my WHERE clause but I only want the one with the maximum created…

  rightfield

  2 replies

  17 years, 6 months ago

  By: rightfield

• Linking an SQL INSERT statement to a .csv file containing data for a VALUE

  Hello I am using the following SQL statement to update the records in our database with a website a…

  jonclay_london

  12 replies

  17 years, 6 months ago

  By: jonclay_london