• SQL Server table structure

    Hi, i want to know is there any command other than SP_help or SP_columns to see the STRUCTURE of TABLE.

    Tablestructure15 pointsBadges:
  • Compare Two Tables With Identical Fields

    Need to compare two tables A & B with identical fields and report when rows don't match and rows from B are missing in A.

    Jaggerdude60 pointsBadges:
  • Documentum Stops Processing

    During import of Excel files, documentum just stops processing & disappears. There's nothing in the log, other than 49 files were processed & no errors. EMC cannot duplicate the error in their lab. Installation gone awry? CC me at morgans@southcoastplaza.com with solution.

    CMSteven5 pointsBadges:
  • How to connect PowerBuilder 10 with Microsoft SQL Server?

    connect Powerbuilder 10 with Microsoft SQL??

    Matiusk5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • SQL Query for Time Filed

    I have a sql table where the field tr_time contains the trade time and datatype of the filed is Datetime. I want to retrieve records where the time is in multiple of 5 seconds, so records where the seconds are in multiple of 5 only. How can I do this?

    Akshah10 pointsBadges:
  • To write a stored procedure

    there are two tables one ZipCode and one tempTable each has ZipCode and CongDist as columns. Each Zipcode has more than one CongressionalDistrict. How can I write a SP to have a seperate entry for each senario of Zipcode and Congressional District in tmp Table

    SProcedure25 pointsBadges:
  • SQL server query to search for table and column data in database

    I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

    Linu438910 pointsBadges:
  • SP Dynamic SQL with LIKE Operator

    Hi. I want to create a stored procedure whereby the variable comes after the LIKE operator. For example, the code would look something like this: CREATE PROCEDURE SPFIND @VARIABLE1 VARCHAR SELECT * FROM TABLE1 WHERE FIELD1 LIKE '%@VARIABLE1%' Then to execute the procedure, EXEC SPFIND...

    Eabouzeid175 pointsBadges:
  • SQL indexes

    hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • SQL Server partitioning

    Hello Sir, i m creating a partition  as  use master go create database mypartpracdb214 on primary (name=db_dat, filename='c:partitionpracticedb.mdf',size=4mb), --filegroup fgi --(name=fgi_dat,filename='cpartitionpracticefgi.mdf',Size=2mb), filegroup fg2...

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Have you taken a shot at the Intel Open Port IT Scavenger Hunt?

    If you're answer is no then what are you waiting for? Get in the hunt! You could win... GRAND PRIZE WINNER: Dell Precision T7500 Tower Workstation FIRST RUNNER UP: $100 Amazon.com Gift Card SECOND RUNNER UP: $50 Amazon.com Gift Card THIRD RUNNER UP: $25 Amazon.com Gift Card IT Knowledge Exchange...

    EmNichs3,250 pointsBadges:
  • DBFs into SQL Server 2008

    Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the "import into Access, then import the Access files into SQL server-method")? I don't work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once a...

    ITKE346,430 pointsBadges:
  • Using stored Procedure in SSRS

    Hi.... I am trying to create a Report using Report wizard in MSSRS 2005, I am trying to use Stored Procedure. The steps which I am following are below.... Solution Explorer--> Add New Report--> Next(as DB is already shared one)--> Query Builder (But when going into query builder the...

    Rohitd235 pointsBadges:
  • Spatial query optimizing

    I have a development machine and a production machine with identical databases, but I'm getting huge differences in execution plans when running a spatial query. First, my development machine: It's SQL Server Express x64 with Reporting Services running on Win7 with 8Gb RAM. Then my production...

    Overtech65 pointsBadges:
  • Error in the installation of SQL Server 2005 (64-bit)

    We are trying to upgrade our installation to SQL Server 2005 (64-Bit) Edition, but we cannot get past the following error reported in the Event Log: *********************************** Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 11706 Date: 17/07/2008 Time: 14:01:43...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server enterprise manager

    how to register enterprise manager to connect to database

    Cslaybec5 pointsBadges:
  • Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • Import data file into SQL database

    I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

    Anamika8315 pointsBadges:
  • Virtualizing SQL

    Is it possible to run SQL Server 2000 on a VM on a workstation? If so, anything special to consider?

    greg08115 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following