SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Does SQL Server 2000 has a 'WITH' CLAUSE

  Hello All, Please anybody let me know does SQL Server 2000 supports "WITH" clause. If no, then w…

  kam7395

  3 replies

  16 years ago

  By: Jeff Moden

• Determining the number of business days between two dates

  Hello Everyone, I am new to SQL Server 2000, I would like to know how to "determine the number o…

  kam7395

  3 replies

  16 years ago

  By: Jeff Moden

• How to count the occurences of weekdays in a year

  Hi Everyone, I am new to SQL Server 2000, Please somebody let me know how to "count the occurenc…

  kam7395

  4 replies

  16 years ago

  By: kam7395

• DTS empty table delay

  I have inherited a system where a website's tables occasionally get updated with new (or updated) d…

  saivko

  2 replies

  16 years ago

  By: saivko

• Can many inserts cause a table lock?

  1. We want to insert million records to a table. Will these many inserts cause table lock? I know…

  jungnaja

  2 replies

  16 years ago

  By: Ian Scarlett

• Pulling multiple records efficiently

  Hey everyone, So our company is creating crystal reports based off of information we are pulli…

  freakin_penguins

  2 replies

  16 years ago

  By: Greg Snidow

• Whats faster, flat files or SQL table

  I have 5000 txt files of Date,open, high, low, close, volume data. Each file is named after the sto…

  Digs

  6 replies

  16 years ago

  By: Carl Federl

• Organising databases and servers

  I'm going to be developing 3 or 4 small/medium size databases over the next year. Should I run them…

  Jas_The_Ace

  1 replies

  16 years ago

  By: DNA_DBA

• Best Practise DB acces of data

  I allow users to read and update records that are specific to them in a SQL 2005 database My code …

  Digs

  3 replies

  16 years ago

  By: RTaylor2208

• Installing SQLSERVER

  Hello, This is my first time on this forum and with SQL Server. I was given the task of deploying a…

  Adomi

  2 replies

  16 years ago

  By: tosscrosby

• SQL Server Login and SQL Server Database user

  I restored a database dump to a new instance in my test environment. I created a login and tried to…

  EMtwo

  2 replies

  16 years ago

  By: EMtwo

• Convert string to human readable date/time format

  We have an application where the date-time stamp is stored as varchar(50) instead of datetime. I ne…

  n.heyen

  10 replies

  16 years ago

  By: Jeff Moden

• Invalid column name help

  I write a SP to retrieve data from database when there is any data inside the table. So far everyth…

  cl_see

  7 replies

  16 years ago

  By: Lowell

• Linked server issue

  When i added my sql 2005 server as a linked server to my sql 2000 server Im only able to view the t…

  Eswin

  2 replies

  16 years ago

  By: Jack Corbett

• Help me with this

  Hi Expertz Can you please tell me what does this select statement return and what is the column "la…

  Eswin

  1 replies

  16 years ago

  By: Gail Shaw