T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Trigger On Update

  How trigger works on update statement affecting more than one row?

  rav999

  4 replies

  15 years ago

  By: WayneS

• Parsing strings in T-sql

  Hi all, I have a table full of server names some of which include "." How can I strip out everythin…

  SQLEngine

  6 replies

  15 years ago

  By: SQLEngine

• Errors working with ComputedColumns

  Hi, I am new with ComputedColumns. There are 2 errors that I get when creating computed colums (Pe…

  saqlainkhan

  1 replies

  15 years ago

  By: sturner

• Enable SPARSE

  How do i enable SPARSE on all the valid columns in an existing table ?

  Tara-1044200

  1 replies

  15 years ago

  By: Johan Bijnens

• Can you determine the DB an SP was called from?

  Can you determine the DB an SP was called from? i.e. given this code: USE DB1; GO EXEC DB2.dbo.usp_…

  UMG Developer

  11 replies

  15 years ago

  By: UMG Developer

• SQL QUERY LOOP

  Dear experts, I have the following query which generates for me row with identical entries :- SELE…

  martin.edward

  13 replies

  15 years ago

  By: martin.edward

• How to query data from linked server

  I know: Linked server name, data source. How to know table name and retrieve data? Thanks

  kris1999

  7 replies

  15 years ago

  By: Lowell

• Format number results in TSQL

  I have a TSQL Query which selects data from a decimal(25,6) field. The result has the following for…

  konstantinos.christodoulakis

  4 replies

  15 years ago

  By: konstantinos.christodoulakis

• SP Issue in SQL 2008

  Hi, When i ran the store procedure in sql 2008. its getting the following error Cannot resolve t…

  balaji.ganga

  2 replies

  15 years ago

  By: balaji.ganga

• concatenating columns

  I have first name and last name in my table. I have to concatenate these two columns and update i…

  Prema sambandam

  10 replies

  15 years ago

  By: Jeff Moden

• stored proc w double quotes wrapped around select

  I'm looking ove rthis proc and i noticed theire using dynamic sql however instread of using ticks t…

  BaldingLoopMan

  1 replies

  15 years ago

  By: steve-893342

• How to Pivot using T-SQL

  Hi, my results looks in this format Sorce YearMonth CountEntery A 2003-04 43 B …

  sqlbi

  23 replies

  15 years ago

  By: WayneS

• Sliding aggregations

  I need to retrieve a bunch of payments from a table and show how much has been paid since the incep…

  repent

  3 replies

  15 years ago

  By: repent

• Read AD with SQL

  Hello How can read from Active Directory every computer (host name)? It would be best if this were …

  squicky

  2 replies

  15 years ago

  By: jvanderberg

• Updating XML stored in a column via update text function????

  Hey Gurus and Grand Masters 😎 I have xml stored in a column with data type = text. I need to update…

  AirBasi

  4 replies

  15 years ago

  By: AirBasi