Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Searching inside a string -- I'm not sure this is doable

  For a fairly full description of what I'm trying to do, see my previous post at http://www.sqlserve…

  Wayne West

  3 replies

  11 years ago

  By: Wayne West

• Call function/procedure from anywhere

  I am working on sql server 2014 and I have a list of functions/proedures I want to create on the se…

  GrassHopper

  3 replies

  11 years ago

  By: GrassHopper

• SQL Script

  create table t1(id number, description varchar2(25)); Insert table t1(id, description) values(101,'…

  vijay.aproju

  1 replies

  11 years ago

  By: Luis Cazares

• Implementation question: lookup table vs bit flags

  I'm undecided on how to implement something. Because the system that I'm building is holding stude…

  Wayne West

  7 replies

  11 years, 1 months ago

  By: Wayne West

• Is it possible to embed a parameter in the name of stored procedure that's called from within another sproc?

  I have some code that I need to run every quarter. I have many that are similar to this one so I w…

  pharmkittie

  13 replies

  11 years, 1 months ago

  By: x

• CASE vs ISNULL? Which is faster?

  Hello everybody, I have a task to be accomplished at work and would like to ask you a question abou…

  shadabkhan87

  11 replies

  11 years, 1 months ago

  By: Eric M Russell

• Find Table in a linked server

  I have multiple linked servers and trying to find if a table (approximate table name) exists in one…

  AtoZ67

  3 replies

  11 years, 1 months ago

  By: AtoZ67

• Calculating Concurrent Users in a Database?

  I am researching this and playing with using the syss.sysprocesses view and counting the dbid colum…

  HookSQLDBA7

  1 replies

  11 years, 1 months ago

  By: Eric M Russell

• Duplicate Record results on 2 one to many tables!!!

  Hi, I hope i'm doing this correctly. I have 3 Tables TableA - TAID, Name, LastName TableB - MaleFri…

  corne660325

  1 replies

  11 years, 1 months ago

  By: Lynn Pettis

• i am trying to insert data into sql table using c# ssis script task +very soon +asap

  i am trying to insert data into sql table using c# ssis script task .. I am pasting below querry. I…

  sqlmaverick

  7 replies

  11 years, 1 months ago

  By: Eirikur Eiriksson

• Automating random inserts into a memory optimized table

  Hi I have this table CREATE TABLE [Sales].[Test_inmem] ( [c1] [int] NOT NULL, [c2] [nvarchar](20)…

  Paresh Motiwala

  3 replies

  11 years, 1 months ago

  By: Jeff Moden

• List of institutes more than half of accepted applicants

  I have 2 tables: tbl1: InstituteID, name tbl2 ApplicantID, InstituteID ,Applicant_Name, address, ci…

  lsalih

  2 replies

  11 years, 1 months ago

  By: lsalih

• Change Data Capture

  Hi All, I am trying to use change data capture to load the data into the secondtable from table 1 w…

  suppiunna

  1 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• SQL date code question

  Good evening, Not sure if this is the correct forum to post this in as I'm farely new to SQL. My q…

  edgar.ect

  2 replies

  11 years, 1 months ago

  By: psingla

• SQL SERVER Login

  Hi Experts. I have got the error “a network related or instance specific error occurred sql server …

  shaik.mussarath

  1 replies

  11 years, 1 months ago

  By: spaghettidba