T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Adding a where clause in a trigger

  Hi Guys I have this trigger which simply inserts a row of data from one table to another. However, …

  ram_kamboz2k7

  1 replies

  13 years, 4 months ago

  By: drew.allen

• Getting Last modified record from table

  Hi all, IS it possible to get the id of last modified record from database table? If some one inser…

  MuhammadShafiq

  15 replies

  13 years, 4 months ago

  By: TheSQLGuru

• How to count the Number of Records

  HI, I have table student st_id , st_name, act_date 1 james 2/2/2012 2 albert…

  suresh0534

  2 replies

  13 years, 4 months ago

  By: Eugene Elutin

• Concurrency Issue

  From a long time i have an interesting question in my mind.Would you people like to clear me here i…

  MuhammadShafiq

  1 replies

  13 years, 4 months ago

  By: Ant-Green

• What's triggering the error?

  We're starting a new ETL process that will have data something like DECLARE @scores TABLE (RepId i…

  ken.trock

  7 replies

  13 years, 4 months ago

  By: ken.trock

• Alternative to cursors?

  hi guys, just getting back into SQL and a bit ring rusty... I have inherited a sp that does the fol…

  aaron.reese

  7 replies

  13 years, 4 months ago

  By: Lynn Pettis

• Dynamic update query

  Hi, There is a table with 30 to 40 columns and hardly few columns may get updated by the user. …

  rajeev_vandakar-782919

  22 replies

  13 years, 4 months ago

  By: charles.byrne

• Changing the data in a Column

  HI All, I want to update the data in a particular column[column data type is String ] . Ex: The d…

  Lavanyasri

  2 replies

  13 years, 4 months ago

  By: Lavanyasri

• proc call inside proc call not showing in trace

  So i have some front end functionality that calls a stored proc that has copius amounts of logic wi…

  Snargables

  3 replies

  13 years, 4 months ago

  By: Snargables

• scripting all stored procedure through T-SQL

  Hi I need to generate script to all stored procedures in a particular DB not using enterprise mana…

  pmadhavapeddi22

  7 replies

  13 years, 4 months ago

  By: pmadhavapeddi22

• Update Trigger with Case statement

  Hi All, I was wondering if anyone could help, I'm trying to update a column in a table so if the pr…

  Reyvon

  2 replies

  13 years, 4 months ago

  By: Reyvon

• saving XML in sqlserver issue

  Hi all, Its urgent please replay me. i am passing XML as string to store procedure and i want to sa…

  MuhammadShafiq

  18 replies

  13 years, 4 months ago

  By: MuhammadShafiq

• Minimal Logging and BULK

  Alrighty then. I'm trying to do a massive insert with minimal logging of the same table from one d…

  Evil Kraig F

  8 replies

  13 years, 4 months ago

  By: Evil Kraig F

• Help with a float value

  Our company has a vender package that has a table that contains a float data type. The system popul…

  Harold Buckner

  6 replies

  13 years, 4 months ago

  By: Harold Buckner

• find the name of a table and column that contains a perticular value

  Hello, The question may sound a little strange but I do have the need. The question is I know the…

  bull1998

  1 replies

  13 years, 4 months ago

  By: Lowell