SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Non-Clustered Primary Key and Non-Unique Clustered Index Questions

  I'm working on a table design and I think the table will have a non-clustered primary key, but I'm …

  Stephanie Giovannini

  4 replies

  10 years, 9 months ago

  By: ScottPletcher

• RTRIM is not working as expected

  Hi friends, for some weird reason the RTRIM function is not working as I expected. Example: SELECT…

  Paul Hernández

  30 replies

  10 years, 9 months ago

  By: Cadavre

• Merge statement

  Hi, I have created a stored procedure to load incremental data from Import table to Archive Table. …

  vipin_jha123

  5 replies

  10 years, 9 months ago

  By: serg-52

• Possible to tell whether function was passed a value or used default value

  Good morning all, I have a function that accepts a date parameter and uses getdate() as its defau…

  BiatchCakes

  4 replies

  10 years, 9 months ago

  By: Dwain Camps

• Concatenate multiple rows from one table, associated to column in second table having multiple values

  Table1 contains a CODES column which may store multiple codes separated by commas. The descriptio…

  mahler9

  7 replies

  10 years, 9 months ago

  By: mahler9

• How to cancel a query if a condition is not met?

  Hi all, Is it possible to stop a query from running if a condition is not met? I have a stored proc…

  lindsayscott23

  2 replies

  10 years, 9 months ago

  By: lindsayscott23

• LTRIM/RTRIM

  Hi Team, using below script to read two column from a text file and trying to trim the spaces for f…

  Minnu

  4 replies

  10 years, 9 months ago

  By: spaghettidba

• Compare column in two tables

  Hi Team, i have two tables. Table A IdName 101Dante 102Henry 103Harold 104Arnold Table B Numbe…

  Minnu

  12 replies

  10 years, 9 months ago

  By: serg-52

• Get the splitted column using fucntion

  Hi , I am having staging table with separted by '¯'. I want to split the data with given number . i…

  vipin_jha123

  11 replies

  10 years, 9 months ago

  By: serg-52

• Strategy to archive data and delete

  Hello, I am using SQL 2012 SE. I have 2 databases say A and B with same structure and relationships…

  Pyman

  1 replies

  10 years, 9 months ago

  By: serg-52

• Hi i need to create a auto backup for sql 2012 express edition..

  Well u guys helped me means a very big thanks in advance...

  padmanabaiahsetty

  1 replies

  10 years, 9 months ago

  By: Matan_Yungman

• SQL Synatx error while creating table dynamically

  I am getting error when I am trying to create table on runtime Declare @FileName varchar(100) Decl…

  vipin_jha123

  4 replies

  10 years, 9 months ago

  By: patricklambin

• Different Result Select vs. Cursor

  Hello everybody, In the last days I found a T-SQL miracle (maybe only for me - I hope so) I don't u…

  Gerhard P.

  16 replies

  10 years, 9 months ago

  By: Gerhard P.

• Select query to xls output

  Hi Team, using below script to export the select statement result to .xls declare @sql varchar(800…

  Minnu

  2 replies

  10 years, 9 months ago

  By: free_mascot

• sql

  hi all, first i will explain the logic behind the proccess 🙂 in my company ther…

  sharon-472085

  1 replies

  10 years, 9 months ago

  By: Ed Wagner