SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• calling a function from storeproc

  HI all, I am coding a cript and need your input, I wanted to call a function which should retun me…

  Minaz Amin

  1 replies

  11 years, 11 months ago

  By: Johan Bijnens

• Searching Address by Ranges

  I have a scenario where I have been given a table full of address ranges that I need to compare aga…

  Anthony Willms

  12 replies

  11 years, 11 months ago

  By: Jeff Moden

• Views and their formatted text being lost

  Issue: When editing a view (right click view, click 'Script view as', click 'alter to', 'click 'Ne…

  kipper_007

  6 replies

  11 years, 11 months ago

  By: Orlando Colamatteo

• user functions

  Write a Stored Procedure utilizing a function that receives a LocationID and determines if the Loca…

  josephmoka

  10 replies

  11 years, 11 months ago

  By: Jeff Moden

• Replacing While Loops (Optimzation)

  Hey Guys, A while ago, I learnt that replacing cursors with while loops helps during performance op…

  sqlislife

  8 replies

  11 years, 11 months ago

  By: Sean Lange

• Begin Transaction - End Transaction in a select statement

  General question - Has anyone seen or had experience with stored procedures that include BEGIN TRAN…

  lcahalin

  5 replies

  11 years, 11 months ago

  By: Gail Shaw

• user function

  Hi I am want to write a Stored Procedure utilizing a function that receives a LocationID and deter…

  josephmoka

  2 replies

  11 years, 11 months ago

  By: josephmoka

• Is there a SQL funtion to concatenate a column from several rows into 1 string?

  Is there a SQL funtion to concatenate a column from several rows into 1 string? Do I need to build …

  Tobar

  2 replies

  11 years, 11 months ago

  By: Tobar

• Having problem openning SQL scripts

  I have some TSQL scripts which ran successfully a week before and now suddenly when I open these fi…

  shashi_1409

  8 replies

  11 years, 11 months ago

  By: Bhuvnesh

• finding hierarchy info

  I am wanting to run a SQL statement whereby i return the ID of any employee's Director. The databas…

  evvo1961

  3 replies

  11 years, 12 months ago

  By: Jeff Moden

• how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

  hi, I have a table like id city 1 A so i want to update city column from A to B and aga…

  dastagiri16

  36 replies

  11 years, 12 months ago

  By: david.john.gilligan

• behaviour of isolation level snapshot on partitioned tables and views

  Hi there, more often then we which for, we have same requests that results in a set of queries that…

  christian_t

  10 replies

  11 years, 12 months ago

  By: christian_t

• MY XML is not working

  I have written a sql syntax to create an XML. Here is the code Code: WITH XMLNAMESPACES ( 'urn:swi…

  niladri.primalink

  4 replies

  11 years, 12 months ago

  By: niladri.primalink

• Include variable in Email Body

  I have a SP that adds a new server to central management studio. It kinds looks like this: ALTER P…

  Minnesota - Viking

  3 replies

  11 years, 12 months ago

  By: Stuart Davies

• XML hierarchical data

  hello I have a request to collect some data from an xml file, and I am stuck at this point. The xml…

  alexandru.tero.toth

  3 replies

  12 years ago

  By: Alan Burstein