SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Writing utf8 content to the disk file

  Hello, I want to do changes in existing stored procedure so that it should write regional content i…

  dipali.choudhary

  8 replies

  14 years, 7 months ago

  By: Nakul Vachhrajani

• Table Maintenace stored procedure

  I was just given a db that has duplicate records in several tables. My method is to select distinct…

  Uripedes Pants

  2 replies

  14 years, 7 months ago

  By: Uripedes Pants

• Substring with Charindex or Patindex and case statement

  I would like to clean up some of our data using substring and charindex/ patindex with a case state…

  sfletcher-933270

  4 replies

  14 years, 7 months ago

  By: sfletcher-933270

• Help needed to make an identical copy of a db in SQL 2000

  Hello all! I need to re-create a db that has irreparable corruption in the sysindexes table (stat e…

  djossoud

  8 replies

  14 years, 7 months ago

  By: Gail Shaw

• Converting minutes into HH:MM

  Hi There, I think I have put this in the right place, please forgive me if not. I have a query wher…

  Kazmerelda

  4 replies

  14 years, 7 months ago

  By: GSquared

• have any idea on what exactly is nolock and why do we need to use this...

  friends, please give me some idea what this nolock is exactly and why do we need to use this in our…

  naidu4u

  3 replies

  14 years, 7 months ago

  By: naidu4u

• help needed with datetimes

  ChangeIDrefOTSIDOttimeOldTypeOldlocalNewTypeNewlocalDateChangedDateClosed 77,39748,242Oct…

  naidu4u

  23 replies

  14 years, 7 months ago

  By: naidu4u

• Waitresource type

  Hi all, When I look at the sysprocesses that are currently running, there is a MISC (00C47E48) unde…

  tt-615680

  1 replies

  14 years, 7 months ago

  By: Meet George Jetson

• time difference with two rows in the same table...

  Hello, I have three columns in my table eventid comment timestamp 1 fiu 2010-10-12 12:25:00 2 abc 2…

  naidu4u

  5 replies

  14 years, 8 months ago

  By: naidu4u

• time difference the rows in the same table...

  Hello, I have three columns in my table eventid comment timestamp 1 fiu …

  naidu4u

  6 replies

  14 years, 8 months ago

  By: naidu4u

• T SQL Query help with date ranges

  Hi there, Firstly I would like to say hello, as this is my first post on here. Please can I ask for…

  Kazmerelda

  8 replies

  14 years, 8 months ago

  By: WayneS

• Database Trigger(DDL Trigger) Issue

  Hai , I have a prob with saving the user information with DDL trigger.How to save windows login ID …

  Robert Dennyson

  1 replies

  14 years, 8 months ago

  By: Lowell

• Help needed to change the layout of data in a table

  Hi All, I new to these forums and SQL but you all seem very helpful so i thought i'd put you to the…

  happyfax

  3 replies

  14 years, 8 months ago

  By: Greg Snidow

• multiple fields in 1 row

  In my database I have a contact_phone table. The type of phone it is, is indicated in the contact_p…

  norbertackerman

  5 replies

  14 years, 8 months ago

  By: Greg Snidow

• SQL SERVER 2000 Retrieve Data using IntMth n intYear Parameter

  Hullo Friends, :w00t: I need your help. Please help me. The company I am working for is still usi…

  Lennie

  9 replies

  14 years, 8 months ago

  By: Lennie