T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Question about GETDATE()

  Hi, I need to set a date column, and milliseconds are significant. If I do this: UPDATE mytable S…

  Raymond van Laake

  8 replies

  14 years, 2 months ago

  By: Jeff Moden

• Parse data

  Hello, I am trying to parse data and put in seperate columns if possible. For example: 332|347 34…

  oradbguru

  5 replies

  14 years, 2 months ago

  By: oradbguru

• Best practice

  I see query somebody use like below. So let me know this method (joinig tables/ outer join) is good…

  sampathsoft

  2 replies

  14 years, 2 months ago

  By: Jeff Moden

• How to find the difference between the numnbers in an increasing number series

  Hi there, I have table holding values for hours, and for days as: CREATE TABLE [dbo].[HoursandDays]…

  greg.bull

  8 replies

  14 years, 2 months ago

  By: Jeff Moden

• stored procedure header

  We have 60 stored procedures without headers. now we need to include below details in all sp. Is th…

  gugan_ta

  4 replies

  14 years, 2 months ago

  By: Jeff Moden

• Text file to Temp Table

  Hi I am trying to copy a data from text file to temp table using bulk insert but it gives me Error…

  unnati.patel513

  3 replies

  14 years, 2 months ago

  By: Jeff Moden

• rebuilding indexes

  I am using many indexes in my database I understood that it is not advisable to rebuild all the ind…

  Sarsoura

  4 replies

  14 years, 2 months ago

  By: Jeff Moden

• stopping MSSQLFDLauncher

  Hi All I want to reserve memory. I am not using sql full text nor the analysis service in my applic…

  Sarsoura

  4 replies

  14 years, 2 months ago

  By: Sarsoura

• DELETE Statements when using a JOIN - Best Practice

  Hi All, I have a question around "What is the best practice" for doing a delete statement when join…

  Tava

  7 replies

  14 years, 2 months ago

  By: Jeff Moden

• t-sql help

  I'm testing the below script. If I give the path name wrong, @hr variable giving some number (like …

  gary1

  1 replies

  14 years, 2 months ago

  By: Ron McCullough

• beginner requesting help with trigger that updates a table when an insert occurs in another

  First, I read Jack Corbett's intro to triggers and am attempting to stick with set based sql. The p…

  xenophilia

  10 replies

  14 years, 2 months ago

  By: Lowell

• Formatted Text when select.

  I have a production database, in one table there is number of operations, this column contains '/' …

  ßhavin

  4 replies

  14 years, 2 months ago

  By: ßhavin

• Query same customer to determine datediff between two orders in same table

  Hi- I have a table that has every order placed. Something like this customer_id, order_code_id, or…

  paulgill

  8 replies

  14 years, 2 months ago

  By: paulgill

• Delete duplicate data from two tables where there is premary key reference

  I have tow tables 1.Contact(FirstName,MiddleName,LastName.ContactId) 2.Sales(ContactId,TotalDue) S…

  Smash125

  4 replies

  14 years, 2 months ago

  By: jcb

• Create foreign key script

  I can generate a forign key script in the management studio. For example: ALTER TABLE [Student] WI…

  sqlfriend

  3 replies

  14 years, 2 months ago

  By: Recurs1on