T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• SSIS OLEDB Error

  Hi All, While executing the SSIS package form job agent some times it's working fine, some times i…

  gramanjul

  1 replies

  14 years ago

  By: drew.allen

• MS SQL alternative to SUBSTRING_INDEX

  Hi I am new to MS SQL but in MY SQL I used SUBSTRING_INDEX to extract a number of words. Is there a…

  test

  8 replies

  14 years ago

  By: santiaguero81

• Query Problem when Updating temporary table

  Hi, I am trying to update a temporary table and am returning the wrong result. My 2 tables are @tm…

  DerbyNeal

  2 replies

  14 years ago

  By: Cadavre

• Adding a new column issue?

  Hello - I'm need of help figuring out how to add a new column called TASK to the following script.…

  david.ostrander

  8 replies

  14 years ago

  By: Cadavre

• Check if table is partitioned?

  Hi, Is there any way to check if a table is partitioned or not? I'm asking this because i need to c…

  Davy Van Laere

  3 replies

  14 years ago

  By: Preet_S

• update commands on a view inside a transaction

  When running two update commands (1 for each table I want to update in the view) on a view inside a…

  amos-870870

  25 replies

  14 years ago

  By: amos-870870

• GetBytes function

  Hi All i've created a table locally from a linked server view. When try to do a select * from .... …

  spin

  1 replies

  14 years ago

  By: Cadavre

• Incorrect syntax near 'left'

  Date/Time : 28/11/2011 11:47:02 PM SQL script : set dateformat 'dmy';update tbPhoneStatus set stat…

  slizam

  14 replies

  14 years ago

  By: SQLRNNR

• network pc info

  hi is it possible to get information about pc's, servers etc on my network i.e. hardware, software…

  spin

  2 replies

  14 years ago

  By: spin

• FOR XML cutting off data

  I have a table that I am trying to query using FOR XML. The problem is that when I do it to text o…

  tshad

  1 replies

  14 years ago

  By: tshad

• CASE Statement in Where clause?

  Hi, I am having a little trouble figuring this out and don't even know if I am on the correct path.…

  upstart

  5 replies

  14 years ago

  By: MMartin1

• How to delete all rows but noon's on Friday?

  Hello - I need help in creating a store procedure that will clean out a table that has been having…

  david.ostrander

  2 replies

  14 years ago

  By: david.ostrander

• Exectuting jobs from a remote machine on the LAN

  I would like to run a single job from another machine on the network. How would I be able to do tha…

  msheehan 72823

  2 replies

  14 years ago

  By: Steve Jones - SSC Editor

• scope_identity() strangeness

  Many of the tables in our database use triggers, so I thought I'd use SCOPE_IDENTITY() to return th…

  Maquis415

  11 replies

  14 years ago

  By: Johan van Tonder

• Multi Line output column

  Hi , I have a requirement to show an output with new line breaks in one of the output column. This …

  jyz

  1 replies

  14 years ago

  By: SpringTownDBA