SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• What data type should I use for "date" of birth

  I want to store "date" of birth. Normally a "date" of birth consist of year, month, day, but there …

  andis59@gmail.com

  3 replies

  14 years ago

  By: Paul White

• data mining

  can we use clustering to find cluster with following data? PrdID Thk Wt x1 2.3 3.4 x1 …

  vnj

  2 replies

  14 years ago

  By: Devendrakumar

• cretaed trigger in sql server 2000

  create trigger jam_spu_csp_insert on customer_special_prices for insert as referencing new as new_n…

  venu9099

  4 replies

  14 years ago

  By: patrickmcginnis59

• comparsion of users between two servers

  Can we compare users between two servers, for ex: users in production and test environments to see …

  DBA_Learner

  6 replies

  14 years ago

  By: spaghettidba

• syntax error???

  Hi, Getting a syntax error on the following.. INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA) …

  jbalbo

  9 replies

  14 years ago

  By: jbalbo

• Retrieving rows with unique data in certain fields

  I have yet to come up with a simple but fast way of retrieving rows from a table that have unique v…

  mike.barrett

  3 replies

  14 years ago

  By: Jason Wolfkill

• service name

  is thereany difference between @@servicename and @@servername?

  Satya_0000

  2 replies

  14 years ago

  By: padhis

• DB recovery to a "point in time"

  I'm aware of how a full recovery mode database can be restored using the latest backup and the (cha…

  andyscott

  5 replies

  14 years ago

  By: Gail Shaw

• Count fields that do not meet specified condition

  VIDSERVERIPBASESCOREEXPLOITABILITYSCANCOMPLETE 51192.168.0.15H some date 31…

  c2k

  9 replies

  14 years ago

  By: Paul White

• Get Max Value from Linked Table

  Hi: I have a quick question, a little gray on syntax I think. The query below works great. SELECT …

  steve.anderson 7639

  7 replies

  14 years ago

  By: Paul White

• Question

  Can any one explain me the difference between an Entity and an object

  na1774

  4 replies

  14 years ago

  By: Lowell

• Add Convert for UTC time

  Okay, I have to add a convert for the UTC column and I have no idea where to put it, can some one h…

  lkennedy76

  10 replies

  14 years ago

  By: stephen99999

• Timed Out when calling from VBA function

  I have a vba function below. I call a stored procedure but it times out. Even if I set the timed …

  mramey

  4 replies

  14 years ago

  By: mramey

• query using time

  the following query select member_number, date, time_in, time_out from member_time where time_out &…

  bill.akin

  7 replies

  14 years ago

  By: bill.akin

• Non Clustered Covering Index Column Selection Rules

  I have a table with around 19 columns which contains reasonable large amount of data and is primari…

  Soumya Nayan Kar

  2 replies

  14 years ago

  By: Divine Flame