T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How do I replace ? in a REPLACE function

  I'd like to run an update statement and replace '?' in some dirty data. When I reference ? in a REP…

  Chrissy321

  9 replies

  13 years, 10 months ago

  By: Jeff Moden

• Can we Roll back of Truncated Data ?

  Hi , Can we Roll back of Truncated Data ? Thanks Alok Kumar Sharma

  Alok Kumar Sharma

  2 replies

  13 years, 10 months ago

  By: Alok Kumar Sharma

• Need help with difficult Dynamic SQL query

  Hello all, I am new here. I am a SQL newbie, but I have a huge task assigned to me. I basically hav…

  zxxz

  11 replies

  13 years, 10 months ago

  By: zxxz

• regex

  Does tsql have something similar to regex?

  ReginaR1975

  3 replies

  13 years, 10 months ago

  By: Jeff Moden

• how to use looping

  create table dbo.EmployeeWork ( empid int, CountryWorkAt Varchar(20) ); insert into dbo.EmployeeWor…

  Munabhai

  1 replies

  13 years, 10 months ago

  By: Sean Lange

• SQL Command line

  Hi SQL Masters, I used the command line when connecting to SQL Servers and executing T-SQL script, …

  Tsinelas

  5 replies

  13 years, 10 months ago

  By: Tsinelas

• Tsql

  someone can help me please Could not open FCB for invalid file ID 3 in database

  eboucicaut

  3 replies

  13 years, 10 months ago

  By: Gail Shaw

• Copy query result to excel

  When I run a query in SQL management studio query window, I tried to copy the result to an excel fi…

  sqlfriend

  13 replies

  13 years, 10 months ago

  By: sqlfriend

• MERGE Statement performance

  hi all, Merge statement is giving performance difference when We are updating the records using mer…

  SQL*

  1 replies

  13 years, 10 months ago

  By: ChrisM@Work

• Converting a Column into multiple columns based on another coloumn (Newbie)

  Hi All, I have three Columns StudentName|Question|Answer StudentA |1 |some Stude…

  santa326

  9 replies

  13 years, 10 months ago

  By: Kingston Dhasian

• Testing that a varchar could be converted to a uniqueidentifier

  I have a legacy stored procedure which tests an ID of type varchar against a table where the ID is …

  Jesse Reich

  35 replies

  13 years, 10 months ago

  By: Michael Valentine Jones

• SQl Server CLR

  Hi all, I have this procedure in Vb.net. Public Sub getFinYearMonth() EncoreConnect() …

  abdul.badru

  12 replies

  13 years, 10 months ago

  By: Jeff Moden

• Selecting rows based on row level uniqueness

  Hi, I hope somebody can help me solve the following problem. I need to select unique records based …

  RynoB

  12 replies

  13 years, 10 months ago

  By: ScottPletcher

• Soundex and the Irish

  O'Halfbubble here wondering how you handle Irish style names with the Soundex function. soundex('O'…

  Half Bubble

  3 replies

  13 years, 10 months ago

  By: Half Bubble

• Headache of csv values and subselects

  I've been beating my head against the wall for a bit with this problem and was wondering if anyone …

  joe.eager

  19 replies

  13 years, 10 months ago

  By: joe.eager