T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• xp_dirtree to access UNC folder on another file server (+ provide UserId& Pwd)

  Dear, After looking at several options, (I have to read files from a file server to populate a DB),…

  DZN

  3 replies

  15 years ago

  By: GSquared

• Is it possible to use select * into #tmptbl from EXEC SP?

  Hi, Is there anybody can help me take a look? I want to create one temp tble by using the query l…

  lindsaywang

  4 replies

  15 years ago

  By: lindsaywang

• distributed transaction

  BEGIN DISTRIBUTED TRAN tran03092011 UPDTE srvrn.dbn.dbo.tbl1 SET name='test' WHERE number=1 IF @@ER…

  sql_novice_2007

  30 replies

  15 years ago

  By: spaghettidba

• Query Question

  How can I include in a query a single value and a total value. I have order table, OrderDate, Custo…

  nfpacct

  1 replies

  15 years ago

  By: ColdCoffee

• Msg 547, Level 16, State 0, Line 2 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

  Msg 547, Level 16, State 0, Line 2 The ALTER TABLE statement conflicted with the FOREIGN KEY constr…

  AK1516

  3 replies

  15 years ago

  By: Johan Bijnens

• how to replace a particular values in coumn names

  hi i got ten column names like #gorge, H#res, Er#es like that now i want to replace all the '#' val…

  tripri

  4 replies

  15 years ago

  By: Jeff Moden

• Greater than output as TRUE with Value from 2 SQL Tables

  I have Two table's called O3 and o5 and contains s.no and O3 & O5 in the Table (i.e..in O3 �…

  Best_boy26

  4 replies

  15 years ago

  By: toddasd

• Help with concatenate -

  I need to modify a job that is on multiple servers and includes the servername in the job. I have t…

  Susan-322874

  3 replies

  15 years ago

  By: Susan-322874

• Searching for Guidelines about access Windows File server from Store PRoc

  Tks for your input !

  DZN

  1 replies

  15 years ago

  By: GSquared

• datepart for milliseconds not precise in SQL Server 2008?

  Why does this: DATEPART(MILLISECOND,cast('2011-03-14 17:43:52.134' as datetime)) return 133? and D…

  Erin Ramsay

  4 replies

  15 years ago

  By: Lynn Pettis

• Sorting data issue

  Hi All, I am unable to sort the following table, which is viewed through a view, by column C. Table…

  TK-487581

  12 replies

  15 years ago

  By: TK-487581

• Convert BINARY to VARCHAR

  Hello, i am trying to convert a binary value to a varchar and I am getting incorrect results. Here…

  David Kranes

  4 replies

  15 years ago

  By: sturner

• Data Transformation Question

  Ok, so I've been a member for a while and read articles as I have time or need. Only posted a few …

  tom 29037

  5 replies

  15 years ago

  By: Sean Lange

• IsDate and Cast as Date not working?

  I have a strange issue where I have a field I am bringing in then checking if it is a date using Is…

  Mark F-428640

  2 replies

  15 years ago

  By: ckingtaylor

• Stored procedure question

  Hello, i have the following code in a stored procedure that is not working: SET @sqlStmt1 = 'SELEC…

  David Kranes

  9 replies

  15 years ago

  By: Jeff Moden