T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Using Trigger in SQL Server 2005

  Hi all, I am using trigger in TABLE A for update TABLE B with below code CREATE TRIGGER [dbo].[Upd…

  hiYusuf

  2 replies

  13 years, 9 months ago

  By: Ninja's_RGR'us

• Database growth Help

  Hello Friends..Need you help in creating a script to capture a database growth and create a graph i…

  sqlquest2575

  2 replies

  13 years, 9 months ago

  By: sqlquest2575

• pretty ugly, mostly not-really-set-based problem to solve

  Hi all. I'm quite aware that this problem is ridiculous, but I do need to solve it. Fortunately I a…

  kramaswamy

  1 replies

  13 years, 9 months ago

  By: drew.allen

• Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

  Sir, I have written a function but giving above error how to solve the problem please show me. [C…

  deba_20032004

  2 replies

  13 years, 9 months ago

  By: kramaswamy

• Performance implications of using [DBName]..[Tablename]

  This abbreviated syntax Database..Table appears quite frequently in various stored procedures I am…

  Phil Parkin

  14 replies

  13 years, 9 months ago

  By: Eugene Elutin

• Combining two sets from same table into one set and being able to pull from new set.

  What I am trying to do is pull data from two separate data sets (columns) from the same table and c…

  thompson 44810

  15 replies

  13 years, 9 months ago

  By: Eugene Elutin

• Arithmetic overflow error converting expression to data type int.

  Using studentid which is as Uniqueid datatype by doing select @studentID = @@IDENTITY I'm gettin…

  vision59

  16 replies

  13 years, 9 months ago

  By: Sean Lange

• Abort SQL-Script with raiseerror

  I want to abort a sql script, so that it doesn't continue further code. For hard abort I use: if @n…

  baumgaertner

  13 replies

  13 years, 9 months ago

  By: Peter E. Kierstead

• Dynamic column naming.

  Is it possible to name a column based on a field value. I want to name a column based on the curren…

  Kelvin Phayre

  4 replies

  13 years, 9 months ago

  By: Kelvin Phayre

• TimeZone Implementation in DB or Application side?

  Hello, We want to implement the timezone functionality through out the application. Here, the data …

  SQL Dev-938873

  8 replies

  13 years, 9 months ago

  By: Grant Fritchey

• Finding and recording offset values using SQL

  Here is my problem: I have a simple table that basically contains account numbers, quantities, pric…

  Rob Titerle

  2 replies

  13 years, 9 months ago

  By: Rob Titerle

• Bizarre behaviour with BCP

  I have narrow a complicated problem down to one stored procedure that is giving me a real headache.…

  Stuart Davies

  4 replies

  13 years, 9 months ago

  By: Ninja's_RGR'us

• What is faster, MAX() with GROUP BY, OR CTE with ROW_NUMBER()?

  I have to manage various kinds of "data" and maintain "versions" of that data. To simplify the prob…

  Pagan DBA

  14 replies

  13 years, 9 months ago

  By: Grant Fritchey

• serach logic needed help

  Hi Team, Need urgent help. Am trying to implement searching logic in my application. I can go for I…

  Oracle_91

  4 replies

  13 years, 9 months ago

  By: ColdCoffee

• Don't want Date Part but till want to retrieve DateTime type

  Hello friends ! this is my first topic on this forum !! I am in trouble.. I am developing a web ap…

  manjeet.upadhye

  5 replies

  13 years, 9 months ago

  By: Jeffrey Williams