T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Increment varchar primary key? or convert varchar primary key to seeded integer

  Hey all, I have a table with a varchar(10) primary key. This value is determined and input by the …

  Isaac Vallee

  3 replies

  12 years, 10 months ago

  By: Jeff Moden

• Brain Dead today

  Using SQL Server 2005, no access to reports. Need to determine how big a row of data is in a table…

  Lynn Pettis

  10 replies

  12 years, 10 months ago

  By: Lynn Pettis

• How to write Transpose in Oracle Please Help

  sample date ----------- source ------ ID-----NAME-----------ADD1--------ADD2---------ADD3------ADD4…

  vp7986

  10 replies

  12 years, 10 months ago

  By: spaghettidba

• Query Result in HTML format

  Hello All, I am using the below script to generate report in HTML format for the query. If there is…

  pawana.paul

  4 replies

  12 years, 10 months ago

  By: pawana.paul

• how to remove zero from my string

  hi , I have two strings like ex:1.'000temp1' 2.'0000temp2'..like how can i remove the zeros from my…

  dastagiri16

  28 replies

  12 years, 10 months ago

  By: Jeff Moden

• Finding client IP-Address

  Need a query that returns the client ip-address of who is updating/accessing the database. I am us…

  richbgreen

  7 replies

  12 years, 10 months ago

  By: lutsenko.dmitry

• My Function should return selective part of String

  I am going to write a function but it was not full filing my requirements. Please help me if anybod…

  Simha24

  6 replies

  12 years, 10 months ago

  By: Lynn Pettis

• soundex function

  What exactly and on what basis does the soundex function returns the integer values. I read through…

  vipulhimanshu

  3 replies

  12 years, 10 months ago

  By: Bill Talada

• Collaspe Logic for Dates

  First I want to Thanks for Reading this. SOURCE:- NM_ID STRT_DT END_DT ABD …

  vp7986

  8 replies

  12 years, 10 months ago

  By: Lynn Pettis

• Update table based on column grouping

  Hi, I have a following table (table1) which needs several updates. All the updates are grouped by t…

  DerbyNeal

  15 replies

  12 years, 10 months ago

  By: Luis Cazares

• Convert DateDiff into Hours, Minutes, Seconds, Milliseconds

  I have the following T-SQL code to change the difference between datetime columns into hours, minut…

  SQL Espo

  9 replies

  12 years, 10 months ago

  By: macintyre_bernie

• Declare and Set (Batch output)

  I am trying to determine if there is a way to obtain all UserName,UserID rather than retrieving one…

  JStevenson1

  1 replies

  12 years, 10 months ago

  By: David Webb-CDS

• Function to split name field

  Good afternoon, With a bit of effort this morning, I've managed to get my function to split my name…

  Abu Dina

  4 replies

  12 years, 10 months ago

  By: Abu Dina

• Tlog space getting full whcle executing the Update statement

  Hi All, Could you please assist on tlog space issues. I am trying to execute the query have update …

  DBA12345

  5 replies

  12 years, 10 months ago

  By: Gail Shaw

• Does/can OUTPUT clause turn identity_insert on & off

  Does/can the OUTPUT clause turn identity_insert on & off ‘behind the scenes’? I think it doe…

  triloba

  8 replies

  12 years, 10 months ago

  By: Phil Parkin