SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Error

  I am not sure why I am getting an error on query. Below is a subset of query that is causing an err…

  nfpacct

  5 replies

  13 years, 10 months ago

  By: nfpacct

• SQL Server - Scope of table variables and temporary tables? Why is the following not getting executed?

  Hi everyone, I am new to sql server and I do not know why the following is throwing errors. Any hel…

  pgraka

  8 replies

  13 years, 10 months ago

  By: Lynn Pettis

• arithmetic overflow error converting expression to data type datetime

  Hi This is my function CREATE FUNCTION [dbo].[dateadd1] (@birth_date datetime) RETURNS int AS BEG…

  pragyan.banerjee

  6 replies

  13 years, 10 months ago

  By: Lowell

• Automating an import routine for text files into SQL SERVER tables with Stored Procedures

  I created a stored procedure which will import an text file from the network into MSSQL and insert …

  timeless2003-1

  18 replies

  13 years, 10 months ago

  By: GSquared

• Linked Server Naming Issue?

  Hi all, Trying to set up my first linked server. All our servers have a naming convention of "Site…

  Staggerlee

  2 replies

  13 years, 10 months ago

  By: Staggerlee

• Programs like Showcase Query

  Currently we use Showcase query as a query management tool. We like it because of its ease of use f…

  bostonjoey

  4 replies

  13 years, 10 months ago

  By: aaron.reese

• Getting my Server details from Registry

  When I use SQL Server Management Studio it tells me that my "Server" is "MEDESKTOP\GARY", which is …

  gary.p.heath

  4 replies

  13 years, 10 months ago

  By: Orlando Colamatteo

• Available Space

  Is there a way to regain Available Space from a database other than Shrinking the database... which…

  rummings

  2 replies

  13 years, 10 months ago

  By: SQLRNNR

• Calculate total from sveral fields with values from other table (idea)

  Hello all, One thing before my story. I am not looking for a complete solution but I am looking for…

  r.van.kwawegen

  4 replies

  13 years, 10 months ago

  By: r.van.kwawegen

• Crazy long trigger

  I have a staging database where I receive data once a day that needs to be placed in different data…

  DBAmes

  4 replies

  13 years, 10 months ago

  By: CapnHector

• Parent Child Relationships

  I have a requirement to store the address for an object in two separate tables -- one for State and…

  rpnew

  2 replies

  13 years, 10 months ago

  By: Lowell

• Retrieve String Name & Data Value From Within Registry Key

  I know that the following will load all of the String Names (i.e. all instances of SQL Server) into…

  gary.p.heath

  1 replies

  13 years, 10 months ago

  By: gary.p.heath

• Stored procedure taking more time than expected

  Hello All, I am new to sql server,am working in sql server 2000,We are facing very strange problem.…

  pragyan.banerjee

  5 replies

  13 years, 10 months ago

  By: OTF

• Best practice needed for shrinking SQL Server Databases

  We were running out of space on a SQL Server 2008 instance. I shrank all of the "Log" files.... sti…

  rummings

  3 replies

  13 years, 10 months ago

  By: Lynn Pettis

• Extract the middle portion of a string

  Hello All, I want to extract all characters between the first and second dash. The below seems to …

  Chrissy321

  10 replies

  13 years, 10 months ago

  By: Chrissy321