SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Joining the TABLES from DIFFERENT DATABASES & From DIFFERENT SERVERS..

  I'm Using Asp.Net with C# & Sql Server 2005.. How to Join the TABLES from DIFFERENT DATABASES …

  Aswanth

  3 replies

  18 years ago

  By: Neelakandan V-453229

• Find the Weekend Date

  Hi I have a requirement that , i will be given a date and i want to find out the date of the weeken…

  webqatesting

  3 replies

  18 years ago

  By: Matt Miller (4)

• How to tell the current patch set level?

  Hello, I am learning SQL Server 2005. I understand that SP2 is available for this version. How can …

  grevesz

  2 replies

  18 years ago

  By: grevesz

• The row count

  Wonder if anyone can help me out. Whats the difference in execution between the following? Or do th…

  Fozzie

  15 replies

  18 years ago

  By: GSquared

• What's a suspended status?

  Hello, In activity monitor, there is an activity in suspended status and waiting for writelog. What…

  grevesz

  1 replies

  18 years ago

  By: pduplessis-723389

• parameter prompt in select statement

  I'm trying to create a simple select statement that will allow me to prompt whoever is running it t…

  mmiller-775091

  1 replies

  18 years ago

  By: GSquared

• How to populate a table with 100,000 rows?

  Hello, I am brand new to SQL Server with two decades of Oracle background. Therefore I may be looki…

  grevesz

  6 replies

  18 years ago

  By: grevesz

• SP running slow

  Hi, we have 1 sp which takes 16sec in dev environment while taks almost 4min in production environm…

  imran karbhari-401826

  9 replies

  18 years ago

  By: Ignacio A. Salom Rangel

• Changing row format

  I have a dilemma, it may be simple but the answer alludes me. I have a table that I imported from a…

  fred-642361

  20 replies

  18 years ago

  By: Jeff Moden

• validating Data using DTS Wizard

  Hi, I am using SQL Server 2000 to import data from a text file using the DTS wizard. I have one co…

  david-632701

  2 replies

  18 years ago

  By: pduplessis-723389

• Inserting into a Table

  Hello all i have been trying to get a junction table up and running and cannot seem to get columns …

  Scandalous

  5 replies

  18 years ago

  By: Christopher Stobbs

• Can the tell the SQL Server Agent to wait for a batch file to finish before proceeding?

  I'm setting up a Maintenance Plan to do a backup for me in the night of my SQL Databases but before…

  mporter-763627

  11 replies

  18 years ago

  By: GSquared

• Format Date to MM/DD/YYYY

  SELECT Top 1 ClassEndDate FROM Class WHERE ClassEndDate < GetDate() ORDER BY ClassEndDate DESC M…

  TheDirtyBird

  4 replies

  18 years ago

  By: GSquared

• Is there any way to use a field value as part of a SELECT statement?

  Is there any way to use a field value as part of a SELECT statement? For example, if I had Table1 I…

  mark-o-751804

  3 replies

  18 years ago

  By: GSquared

• SQL Query / Data export applications

  I'm in search of applications (or asp.net controls) that let me query and export data from sql serv…

  Gary Noter

  2 replies

  18 years ago

  By: Gary Noter