T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Hierarchical List of All tables

  In a SQL Server DB, i have to find all the "Master"(Parent) tables and also build a Hierarchical li…

  francissvk

  17 replies

  6 months, 1 week ago

  By: Lowell

• Maintaining log entries after ROLLBACK TRANSACTION

  I am trying to write some log entries to a custom table, every time I catch an error in my T-SQL or…

  Mr. Andersen

  8 replies

  1 year, 10 months ago

  By: RobertoN

• Replace url with <a href="url">url</a> from a string using SQL

  Hey People! I have a column in the table where i store a paragraph entered from UI. This paragraph …

  StillAlive

  5 replies

  1 year, 10 months ago

  By: Jeff Moden

• Make a column immutable, once set it sticks

  Hi I have two columns which once inserted I don't want to allow to change. I can only think of a tr…

  terry999

  13 replies

  1 year, 11 months ago

  By: soonerGreg8

• Get Distinct Value from each column in a Table

  Hi, how can i get distinct Value from each column from a Table? I think dynamic-sql is the rigth wa…

  info 58414

  6 replies

  2 years ago

  By: drew.allen

• BULK INSERT PROBLEM for CAV file

  Hello SQL Server Community, I'm not new to T-SQL but I have a simple problem that I have not been a…

  pgainer

  5 replies

  2 years, 1 month ago

  By: Jeff Moden

• BULK INSERT PROBLEM for CAV file

  Hello SQL Server Community, I'm not new to T-SQL but I have a simple problem that I have not been a…

  pgainer

  1 replies

  2 years, 1 month ago

  By: frederico_fonseca

• Analyzing a huge ( more than 10600 lines )stoc proc using cte

  Hello commuty, Need your help,  your support and proposition! I'm analysis a huge stoc proc in sql…

  dany

  3 replies

  2 years, 4 months ago

  By: Johan Bijnens

• Joining large tables to small tables.

  Hi I hope this is an easy question to answer. I'm joining a large table to a small table and&n…

  alex.palmer

  12 replies

  2 years, 9 months ago

  By: Jonathan AC Roberts

• Bulk Insert / (type mismatch or invalid character for the specified codepage)

  Dear friends, I need your help and expertise. I'm trying to import several log files into a table b…

  sipi41

  4 replies

  2 years, 11 months ago

  By: sipi41

• Xact_abort ON VS Begin Transaction in Stored Procedure.

  Is there a scenario whereby you would create a stored procedure with the option Set Xact_abort ON A…

  MadAdmin

  4 replies

  2 years, 12 months ago

  By: MMartin1

• running OPENROWSET from sql function with parameter

  Following function works if the parameter to harcoded as shown below. But i would like to replace t…

  skb 44459

  2 replies

  3 years, 1 month ago

  By: frederico_fonseca

• When you convert int to varchar it returns *. Why?

  Why does SELECT CONVERT(varchar(4),263000) or SELECT CAST( 263000 AS varchar(4)) return * ? You wou…

  John Mihalko

  6 replies

  3 years, 1 month ago

  By: homebrew01

• Help with SELECT STUFF and FOR XML to include Carriage Return for Null records

  Hi everyone, I have been struggling with this T-SQL for much too long today.  I am using the S…

  tskelley

  6 replies

  3 years, 6 months ago

  By: NedaYar

• Lookup values similar to VLookUp in Excel

  Hi,I am struggling to write a procedure which looks up a value in a lookup table.See desired result…

  JJR333

  14 replies

  3 years, 7 months ago

  By: Haibanh