T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need Suggestions to manage the different country time Zone

  Dear All We are developing one product, Its going to implements in US Cloud server, But the custome…

  Saravanan_tvr

  1 replies

  13 years, 7 months ago

  By: PiMané

• Stored Procedure Send Email Logic

  Hi all, I am using stored procedures and potentially temp tables for the first time. What I am tryi…

  hkflight

  1 replies

  13 years, 7 months ago

  By: Dwain Camps

• Function To convert large string to small values

  Hi I got a table with one column of lenght 500 and i got around 500,000 records. So from that i'm l…

  tripri

  4 replies

  13 years, 7 months ago

  By: tripri

• TSQL - Recursive Call

  This is a SQL Question, hopefully not difficult. The example is simplified but should work. Have a …

  kwalda

  1 replies

  13 years, 7 months ago

  By: Sean Lange

• Comparing strings in non-English language

  hi people. I have a address data base and I have problems with replicated name of streets. for exam…

  ulisseslourenco

  1 replies

  13 years, 7 months ago

  By: GSquared

• sql server query prob

  Hi firends i have small doubt in sql server how to solve this issuse device type(android,blackbery)…

  asranantha

  1 replies

  13 years, 7 months ago

  By: Cadavre

• Delete existing records, after inserting new record

  Hi i want to delete existing records from sql table, after inserting new record. am using below co…

  Minnu

  6 replies

  13 years, 7 months ago

  By: Lowell

• Using BCP to generate INSERT scripts

  Hello, For some reason I need to generate "Records Insert" for each table of one database. I alrea…

  franck.maton

  2 replies

  13 years, 7 months ago

  By: franck.maton

• Checking for a string until if finds, then insert that into new table

  Hi, am having a table with column names Record_id, Col1, Col2, Col3, Col4, Col5 My requirement is :…

  Minnu

  2 replies

  13 years, 7 months ago

  By: ChrisM@home

• Update a Record Using a Trigger with SELECT Statement

  I'm trying to use a trigger to update the record that has been created with addtional details, howe…

  Damion

  3 replies

  13 years, 7 months ago

  By: ChrisM@home

• Nested Triggers

  Hi, Is there any easy way of determining nested triggers?! For example, if I update a table that ha…

  PiMané

  1 replies

  13 years, 7 months ago

  By: vikingDBA

• creating procudre for dynamic table

  Hi friends, create tab T1(name varchar(22),age numeric(22)) create tab T2(name varchar(22),ag…

  raghuldrag

  6 replies

  13 years, 7 months ago

  By: PiMané

• Access First() function

  hi im migratting an MS Access database to SQL Server 2008, and I have a trouble trying to convert t…

  hugo_17_23 19942

  1 replies

  13 years, 7 months ago

  By: Luis Cazares

• Alter constraint on Primary Key

  Hi, I have a table on which the primary key is defined as composite of two keys. Now i want to add …

  Shadab Shah

  5 replies

  13 years, 7 months ago

  By: Miles Neale

• OUTPUT statement question

  Hi, Is there a way of getting the inserted and deleted "virtual tables" using the output on the sam…

  PiMané

  3 replies

  13 years, 7 months ago

  By: PiMané