T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Types of UDF

  I'm currently using 2005 and hope to move to 2008 R2 soon. Having used UDFs (maybe inappropriately)…

  kuopaz

  3 replies

  14 years, 8 months ago

  By: okbangas

• USE statement with TRY / CATCH

  I'm executing some TSQL code in a job step. I need to specify the master database in the Database d…

  hindle.steve

  2 replies

  14 years, 8 months ago

  By: ghanshyam.kundu

• index curruption

  hey guys pl ztell me wat is the cause of index to b currupted ????

  faruk.arshad

  2 replies

  14 years, 8 months ago

  By: Arjun Sivadasan

• How do I consolidate multiple rows into 1 row of output

  The database I have stores notes on a 1 record per row basis. So if I see 3 lines of notes in the …

  gbankos

  6 replies

  14 years, 8 months ago

  By: Jeff Moden

• Is there a "tables collection" in T-SQL?

  I'm not even sure how to ask this question. I'm an ASP.Net/C# developer who uses Management Studio…

  brad.woody

  9 replies

  14 years, 8 months ago

  By: Jeff Moden

• Passing a Var to SP that needs B-up and

  I am passing a string var to a SP. that string Var has a value of 4,11,12 I am trying to get al…

  Trav williams

  11 replies

  14 years, 8 months ago

  By: drew.allen

• info required ..

  hey i want to know when ever we drop a table then its indexes automatically droped or not ?

  faruk.arshad

  4 replies

  14 years, 8 months ago

  By: ghanshyam.kundu

• Help! Conversion Failed when converting the varchar value...

  I am trying to update a table (TRANSACTIONS) based on the matching rows in a view (DONORS). DONORS …

  hkflight

  7 replies

  14 years, 8 months ago

  By: hkflight

• update row according to previous row

  Hi I had a problem for updating a row according to previous row. My table looks like this: ID COU…

  memostone86

  4 replies

  14 years, 8 months ago

  By: memostone86

• T-SQL Query

  Dear Friends I have a to make a T-SQL query to display the employee name and login duration. Explan…

  Sy-1148362

  5 replies

  14 years, 8 months ago

  By: Ken McKelvey

• Question regarding updating a table with staging table data

  Good Morning, We're working on automating a system where users will upload data from a spreadsheet …

  Nunnery

  3 replies

  14 years, 8 months ago

  By: Nunnery

• Non-aggregated in aggregate function

  It's too long to explain the business reason for my problem, so I'm using Northwind to illustrate. …

  Amy.G

  9 replies

  14 years, 8 months ago

  By: Amy.G

• Getdate function not returning data

  Hello, I'm trying to return data for the current month(October 2011) but i cant seem to get it to …

  Jnrstevej

  14 replies

  14 years, 8 months ago

  By: Jared

• Update previous value

  Hi, how to update null with previous value. ITmField1 Result 254689AAAA aaaa 25469…

  gugan_ta

  6 replies

  14 years, 8 months ago

  By: irobertson

• using varchar and char

  hey guys, I'm just confused on this data types (varchar,char) If a value shorter than the length of…

  Teemo

  11 replies

  14 years, 8 months ago

  By: GSquared