T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Table Locking durint Truncate/Insert

  Hi, Every week I want to repopulate a table by doing something along the lines of: TRUNCATE TABL…

  Richard Warr

  3 replies

  13 years, 8 months ago

  By: bkubicek

• xml-like string to individual rows

  I have columnA with a single value and columnB with strings in it such as: <ITEM>Jane, Mary&l…

  Mindy Hreczuck

  2 replies

  13 years, 8 months ago

  By: Mindy Hreczuck

• Adding time...

  I know about the DateDiff and DateAdd functions, but how do I add the sysjobhistory..run_duration t…

  FreeHansje

  7 replies

  13 years, 8 months ago

  By: FreeHansje

• Formatting a report in SSMS2005 using Qry...

  I have 2 tables, say ,tab1 and tab2 having the same fields-id and modifier that can be related by I…

  Bobichen

  4 replies

  13 years, 8 months ago

  By: Bobichen

• Search for any part of text from list

  Hello all, I an kind of confused as to how to put my query. Let me try. I have a list of names (Jam…

  Deepak.Sharma507

  2 replies

  13 years, 8 months ago

  By: Rob Schripsema

• Summarize Results from two tables, using one query.

  Looking for summary results from two different queries. Getting results: strLocationNameTrunksLin…

  cyndi_kemp

  11 replies

  13 years, 8 months ago

  By: Jack Corbett

• How to return Null or value when nothing is returned from Query

  I have a simple query: SELECT name FROM atable WHERE a = 1 I want it to return Null if it finds n…

  Noc234234

  7 replies

  13 years, 8 months ago

  By: vikingDBA

• Select Records Issue

  Hi all, I have two tables one having company data named COMPANY and other have Landmarks data named…

  MuhammadShafiq

  5 replies

  13 years, 8 months ago

  By: MuhammadShafiq

• Problem with STUFF

  I like to get from the JobHistory table the run_date and the run_time and put them in a DateTime fi…

  FreeHansje

  2 replies

  13 years, 8 months ago

  By: FreeHansje

• query Linked Server security context

  I want to pull the "security context" information from linked servers using a query, rather than Pr…

  Clarie DeWayne

  3 replies

  13 years, 8 months ago

  By: spaghettidba

• Plan cache: "SET STATISTICS XML ON" vs. sys.dm_exec_query_plan

  Hi, Folks! I fired the following Code from SSMS (SQL2K5 SP2): USE AdventureWorksDW SET STATISTICS …

  SFlucke

  3 replies

  13 years, 8 months ago

  By: Gail Shaw

• SQL-Server 2005: Change Ordinal Column Position

  Hello, does anyone know, if it is possible to change the ordinal position of a column? I tried the …

  baumgaertner

  43 replies

  13 years, 8 months ago

  By: Sean Lange

• How to clean up data ?

  I have a table tblUserAccounts. This has the following fields UserId int, UserName varchar(50)…

  SQL Kidu

  2 replies

  13 years, 8 months ago

  By: SQL Kidu

• Searching for misspelled keywords.

  Hi, I'm using SQL queries with LIKE operator to search for keyword(s) in a VARCHAR field of a table…

  MuhammadShafiq

  1 replies

  13 years, 8 months ago

  By: Lowell

• which trigger event

  hi i'm creating an audit table using a trigger. is there a way i can retrieve which trigger event f…

  spin

  5 replies

  13 years, 8 months ago

  By: spin