T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• I want to check the existence of file on ftp when ever any one runs the stored proc

  Dear all i want to check the existecn of file on ftp when ever any one runs the stored proc , so t…

  rajemessage 14195

  1 replies

  11 years, 9 months ago

  By: Lowell

• Display differences between cumulative values

  I have been gathering IO stall data every 15 minutes for several months now. I am wanting to use th…

  Dennis Post

  6 replies

  11 years, 9 months ago

  By: Dennis Post

• convert from MMMDDYYYY to DATETIME

  how do i convert DEC312013 to '2013-12-31 00:00:00.000' without using CASE in sql. i need to replac…

  tsandeep1407

  2 replies

  11 years, 9 months ago

  By: tsandeep1407

• Execute an SP from a trigger

  Forgive what may be a stupid question; being self-taught there are huge gaps in my knowledge. I ha…

  pbaldy

  9 replies

  11 years, 9 months ago

  By: Sean Lange

• Replace .TIF with .pdf

  Hi to all. I want to update a column that links to an external document. The external document…

  2Tall

  7 replies

  11 years, 9 months ago

  By: 2Tall

• elapsed for overlap time

  Hi guys, i need help to fine a good approach to generate an algorithm that measures time range only…

  CS-1058423

  3 replies

  11 years, 9 months ago

  By: CS-1058423

• Insert with self reference

  Hi All, I have a user properties table user_id(not null) gen_userlevel(not null) gen_supervisor(not…

  ringovski

  4 replies

  11 years, 9 months ago

  By: ChrisM@Work

• Check dependencies before creating function

  Hi All, Here's the scenario: Our software is sold by module and version; therefore, a customer may …

  jhager

  2 replies

  11 years, 9 months ago

  By: jhager

• Dymanic Cursor Problem

  Thanks in Advance 😀 I have been using Dymanic Cursors without any problems until yesterday example …

  BarKing

  3 replies

  11 years, 9 months ago

  By: Sean Lange

• conditional joins in select statement

  SELECT t1.id,name, from table1 t1 INNER join table t2 on t1.id=t2.pid case when type='A' then Inner…

  ssurekha2000

  3 replies

  11 years, 9 months ago

  By: Dwain Camps

• Number of Records Affected

  I would like to know how to run an update or delete query and have a chance to commit or not. Here…

  jayoub

  12 replies

  11 years, 10 months ago

  By: jayoub

• Error: Msg 7357, Level 16, State 1, Line 1 Cannot process the object " USE DBAdmin EXEC SP_SPACEUSED 'DatabaseSizeHistory'". The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.

  Hi, Gurus I am creating scripts that will allow to check each dbs table spaces once a week. I can n…

  GivThx

  1 replies

  11 years, 10 months ago

  By: SQLHeap

• compare 2 rows next each other

  create table dbo.abc(id varchar(10), version int, stat varchar(10),typo varchar(10),enterdate datet…

  scottichrosaviakosmos

  2 replies

  11 years, 10 months ago

  By: Jeff Moden

• Wut uhp wi dis?

  On one of my development servers: Microsoft SQL Server 2005 - 9.00.5057.00 (X64) Mar 25 2011 13:33:…

  Peter E. Kierstead

  6 replies

  11 years, 10 months ago

  By: jcrawf02

• Difficulties to use sp_send_dbmail with @@SERVERNAME

  Hi everyone, I have some trouble with the sp_send_dbmail procedure. I use the following code : dec…

  vincent.D_FR

  2 replies

  11 years, 10 months ago

  By: vincent.D_FR