SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Doubt on trigger

  Hello Everybody, I have a table and sp . I want no one to drop those. Am I able to set instead of …

  vignesh.ms

  2 replies

  12 years ago

  By: TheSQLGuru

• Converting Access Function in SQL Function, Help

  hello I'm trying to convert an Access function into a SQL function and having a litlte problem with…

  Knives85

  6 replies

  12 years ago

  By: Luis Cazares

• Reg : Help on Transactions in SQL

  Hi There, I have some doubts on transactions. Following is my problem & I'm intended to go wit…

  vignesh.ms

  1 replies

  12 years ago

  By: Sean Lange

• Trigger Issue...

  Hi, I've a table that has a trigger for insert that executes the flowing statement: UPDATE ArtigoA…

  PiMané

  18 replies

  12 years ago

  By: PiMané

• Help with SQL Maths Operators

  Hello I have a calculation in a Access Database that I am trying to change into a SQL Server query;…

  Knives85

  4 replies

  12 years ago

  By: Gail Shaw

• 108,000,000 row table - check for matches

  Good afternoon, Long time reader - first time poster here! I am currently working on a 108m row ta…

  duncanburtenshaw

  12 replies

  12 years ago

  By: Erland Sommarskog

• script - growing database.

  Friends, someone could share with me a script that calculates the growth of a database and store on…

  LOVER OF SQL

  1 replies

  12 years ago

  By: Ron McCullough

• How to search using stored procedure

  Hello Word and Hello all pipz Good Day!!! I need some advice on how to search using stored procedur…

  enriquezreyjoseph

  8 replies

  12 years ago

  By: enriquezreyjoseph

• Build menu with CTE ....

  Hi, I've a menu that has several levels and each level has a position to order the entries. We had …

  PiMané

  16 replies

  12 years ago

  By: Jeff Moden

• Want to add Text data

  Hi All, I have table called T1 where the data is populated like below LineNumber errortext …

  niladri.primalink

  8 replies

  12 years ago

  By: Jeff Moden

• Temp tables vs "permanent" temp table vs User Table Type

  Hi, We have an SP that receives an XML field with loads of data (sometime it has over 1.000 records…

  PiMané

  17 replies

  12 years ago

  By: PiMané

• Invalid object name 'sys.spt_values'

  Sql 2012 Enterprise installation. user databases are all fine. Managing objects in management stu…

  Indianrock

  7 replies

  12 years ago

  By: Indianrock

• Optimize TSQL

  Hi Please optimze below Query select A.SRC_STM_CD , C.PROD_CD ,c.PROD_DESC ,d.PROD_CLASS…

  greeshatu

  3 replies

  12 years ago

  By: TheSQLGuru

• Shift Column values to the left

  I am trying to clean up some data in one of the tables in our database. The table consists of an ID…

  eseosaoregie

  14 replies

  12 years ago

  By: eseosaoregie

• Beginners Question on Table-Valued Functions

  Based on what I read about Table-Valued Functions it can be used to return modified data from one o…

  anine

  3 replies

  12 years ago

  By: Gail Shaw