SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Howto create SP for DBCC CHECKDB that can be run from MS Access

  Our MSAccess applications use dsn-less connections with SQL Server Native Client (are distrubuted w…

  Mile Higher Than Sea Level

  1 replies

  10 years, 11 months ago

  By: Sean Lange

• BIGINT date format in comparison

  What is the best way to filter out records which has a orderdate column in bigint format ?

  SQL Kidu

  4 replies

  10 years, 11 months ago

  By: SQL Kidu

• Problem excecuting store thats return multiple result sets

  hello i have a store procedure that return multiple datasets i want to manipulate one of theses dat…

  artud2

  2 replies

  10 years, 11 months ago

  By: Lowell

• CTE to find average

  I am trying to get the average for number of Ids per day But , some how I get "0". Can anyone sugge…

  sharonsql2013

  2 replies

  10 years, 11 months ago

  By: Umer Akram

• DBCC CHECKDB

  How does DBCC CHECKDB works? What is the expected time to finish if the database size is about 800 …

  gracey

  5 replies

  10 years, 12 months ago

  By: PravB4u

• Working of the function

  I have an existing function on my DB which is used for date manipulations. Please explain how this …

  VSSGeorge

  5 replies

  10 years, 12 months ago

  By: ChrisM@Work

• Three tables SQL query

  I have a table (Vehicles) which contains a list of vehicles. VehicleID PlateNo CurrentDriver I also…

  milo1981

  7 replies

  11 years ago

  By: milo1981

• Join in two tables

  I have two tables: T1 and T2. T1 has 1 row as name and age T2 has 2 rows as name, money1 name, mone…

  ankit.gupta1

  5 replies

  11 years ago

  By: Dwain Camps

• Use SQL Server 2005 to select a column from Excel

  Hello, I have a spread sheet that has 300+ columns. I would like to create a loop that will s…

  jsilver 12057

  1 replies

  11 years ago

  By: Dwain Camps

• Use Excel to input data to SQL Server 2005

  Hi all, My first post here on SSC. Some of the core systems where I work use Oracle databases and H…

  kb1

  5 replies

  11 years ago

  By: kb1

• What would be best way to change datatype given slow Oracle Linked Server situation

  Working: Oracle Linked Server - however due to the extremely slow VPN, it took a couple of minutes …

  Mile Higher Than Sea Level

  1 replies

  11 years ago

  By: Mile Higher Than Sea Level

• sql 2012 certification

  Hi Can someone help me with correct certification path for SQL 2012 data platform.I have cleared my…

  atulyan.aries

  1 replies

  11 years ago

  By: Bhuvnesh

• joins

  Hiiiiiiiiiiii guys.. i want a detailed clarification on when to use particular joins on a group of …

  Trainee SQL

  1 replies

  11 years ago

  By: Abu Dina

• Problem excecuting store thats return multiple result sets

  hello sorry i have post the last time empty by error but now this is my issue i have a store proce…

  artud2

  2 replies

  11 years, 1 month ago

  By: Koen Verbeeck

• Isnull behavior

  Suppose I have 3 fields which are varchar Area_code Prefix_code Last4_code And suppose the Area_cod…

  mark.gilbert

  4 replies

  11 years, 1 month ago

  By: Rahul Bhosale