SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Accidentally Overwrote Stored Procedure

  I was working in the "Modify" script of a stored procedure just now. I accidentally selected only a…

  deekadelic

  22 replies

  8 years, 6 months ago

  By: deekadelic

• sorting of a columns

  Hi All, I have a table and I have a column that has data like below Tabl1 col1 Base 1 2 3 4 I need…

  anjaliagarwal5

  2 replies

  8 years, 6 months ago

  By: anjaliagarwal5

• Performance of system tables when loading views and procedures.

  I have a database with about 2,000,000 objects in it. Yes I know its lots but this is what I have …

  keith.gilbert-1064677

  9 replies

  8 years, 6 months ago

  By: shoreteknow

• Concurrency - Please Provide Comments

  Hi all I have a question about concurrency. Let me provide some set-up code first. DROP TABLE IF EX…

  Phil Parkin

  24 replies

  8 years, 6 months ago

  By: whenriksen

• Adding Product into cart using SP

  I have to Create a Store Procedure named AddToCart.This procedure should take CustomerId, productId…

  GA_SQL

  4 replies

  8 years, 6 months ago

  By: drew.allen

• Option(Recompile) with indexed Persisted columns and non-sargable predicate does a seek.

  Here is something I found this morning. Since indexed views are used in queries that do not explici…

  MadAdmin

  1 replies

  8 years, 6 months ago

  By: Gail Shaw

• Can't get list of lowest prices

  Hi! I have a litle problem with following: I have some users (U1, U2, U3, etc.) who handles product…

  N_w

  5 replies

  8 years, 7 months ago

  By: Luis Cazares

• Trouble Connecting to SQL Server

  Hi I\'ve been through the set up guide for SQL Server connections but my SQL Server is reporting th…

  Feneta Alicia

  1 replies

  8 years, 7 months ago

  By: HanShi

• SENDING DAILY EMAIL ATTACHMENT WITH SQL QUERY TO GIVEN USERS.

  Dear All, i would like to send out following query to all email users daily basis,can anyone guide …

  ShawnBryan

  4 replies

  8 years, 7 months ago

  By: Jeff Moden

• SQL query to find the previous date, current date data

  If am running today query ( 10/23/2016), then I need get data from following dates 10/22/2016,10/2…

  ShawnBryan

  6 replies

  8 years, 7 months ago

  By: Ed Wagner

• Need help in Date Parameter Format in a procedure

  Hi team, Could you help me to resolve the issue in my Procedure. it looks fine . But if i change th…

  torrid.inundate

  6 replies

  8 years, 7 months ago

  By: torrid.inundate

• Update Query Help in T-SQL

  Hi Guys, Need help. I am trying to Update table2 from table 1. Below is sample code. What I want up…

  rocky_498

  3 replies

  8 years, 7 months ago

  By: Luis Cazares

• ROUND numbers with steps

  Hello, I need to round some values in a column, with a step of 30. For example, every value from 0.…

  albanamino09

  6 replies

  8 years, 7 months ago

  By: Luis Cazares

• Indexed View used without being referenced

  Am I the only numpty who didn't know that indexed views are used without directly referencing them …

  MadAdmin

  4 replies

  8 years, 7 months ago

  By: Eric M Russell

• Cannot get System-Versioned tables to work in 2016

  I have looked all over the place on how to get this to work and assume there must be some setting t…

  tshad

  6 replies

  8 years, 7 months ago

  By: tshad