SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Creating view for Repoting

  I am very new to using SQL, I need some help in creating a DataBase view. I keep getting this error…

  jeffrey.lowe

  5 replies

  17 years ago

  By: jeffrey.lowe

• Handling errors in TSQL and intercepting them in VB

  I am a VB6 developer who uses database techniques as part of my software development skills. Since …

  goodguy

  5 replies

  17 years ago

  By: goodguy

• There must be an easier way - 600k INSERTs

  I have a unique situation compared to most of you, I think. I am not a DBA, or even a developer, ri…

  jcrawf02

  10 replies

  17 years ago

  By: Jeff Moden

• Combine multiple selects to one row.

  I have the following script and get the following results. I want to show the P2 value as the last …

  Erin.

  1 replies

  17 years ago

  By: Carl Federl

• How to fetch data using OPENDATASOURCE and Linked Server

  Hi I'm using the following query to connect to my MSSQL 2000 DB1 and further use a linked server to…

  Ankit Mathur-481681

  8 replies

  17 years ago

  By: Ankit Mathur-481681

• seting a variale while a stored procedure is run

  Hi I have a local variable Declare @ret int and I have a stored procedure that simply selects the s…

  aayub

  4 replies

  17 years ago

  By: aayub

• How to load comma delimited data from a file into a Oracle table using SQL PLus

  Hi, I have a data.csv file with data like 123,john,texas 342,peter,china 111,craig,detroit I need t…

  royston_pledger

  2 replies

  17 years ago

  By: royston_pledger

• Locks on View

  I use a SQL-Server view to display data in a MS Access Listbox. Now I need to udpate data in one of…

  olli_d

  3 replies

  17 years ago

  By: olli_d

• query to display non distinct values of a column in table?

  Hi, In a table, out of 250,000 records only 248,245 records are distinct (a result of some process …

  royston_pledger

  5 replies

  17 years ago

  By: royston_pledger

• Convert rows to column

  I have a table of the following format ID Col DArea Val ----------------------------------…

  priya-766346

  3 replies

  17 years ago

  By: ChiragNS

• truncate value in a table

  Hi, I've a column Event_Desc(255)nvarchar in a table. If I insert a record in it through stored pro…

  freephoneid

  4 replies

  17 years ago

  By: Lowell

• Options for setting up a reporting server

  I have a production database on SQL Server 2000 that is being constantly hit by reports, I want to …

  fj

  2 replies

  17 years ago

  By: fj

• Analysis Services 2000 Data Source Change

  I have made a copy of a cube in Analysis Services 2000 and need to change the data source, but I ca…

  Will Whitley-465737

  1 replies

  17 years ago

  By: kgaudana

• Table Locking

  Is there a way either thru sql or using ADO Properties to tell whether or not a table is locked. B…

  mbender

  4 replies

  17 years ago

  By: Jack Corbett

• SQL Server Questions

  Hi, I would like to find out whether there is a way to perform the following things by using the fu…

  setlan1983

  6 replies

  17 years ago

  By: tosscrosby