• Column extention in SQL

    Hi I want to expand the number of columns that SQL would permit me to create. How do I start? any suggestions? example: 1032 maximum column limit I want in the area of upper 5000 range for a table. Someone help. Thanks!

    Ctc12320 pointsBadges:
  • SQL Server 7 database restore

    I'm working with SQL Server 7 and I made a backup from a Database and I need to restore it, but this error appear: "The RAID set for database is missing member number 1". What can I do?

    Claudiofuentes15 pointsBadges:
  • Deleted SQL Server 2005 database

    Hi, actually I know the importance of backup, but I don't have the back up in any-how condition. Accidentally the database deleted by me. How do I recover it? How to use the transaction.log file to restore deleted database in SQL Server 2005?

    Lalit35 pointsBadges:
  • Advantages and disadvantages of certain SQL commands

    Where can I find information about the advantages and disadvantages of using SQL commands like BCP, BULK INSERT, SELECT INTO, etc.?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Date formats in SQL Server Stored Procedures

    This one will be easy, I'm sure. I'm a novice at Stored Procedures, and I'm wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)? I am on SQL Server.

    Wandasoozq5 pointsBadges:
  • Eliminating Nulls in T-SQL

    If I want to return null values in a query that has "Where Field1<>'test' is there an option I can turn on? Example: CREATE TABLE myTable(Field1 varchar(25)) GO INSERT INTO myTable VALUES ('test') INSERT INTO myTable VALUES('test2') INSERT INTO myTable VALUES(null) GO Select * From myTable...

    TJay85 pointsBadges:
  • Being notified when a delete operation is performed on SQL Server

    How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ASP.NET

    I have four textboxes and a database which is already created. What I want to do is if i enter the value in the four textboxes and press button, it should automatically gets updated or saved in the database.

    5555544425 pointsBadges:
  • Creating a username and password on a SQL Server database

    How we can create a username and password on my SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connection of Crystal Report 2008 with VB6.

    Please let me know the procedure to bring the controls of Crystal Report 2008 in VB6? What control has to be select and what coding should be use for the same? I'm using SQL 2000 as a back-end. Please help.

    Anishrohlx5 pointsBadges:
  • Create aggregate tables in SQL Server

    Hi TechTarget Artifacts, How can we Create aggregate tables? Can you please tell me the Syntax? Thank you

    Srinivasreddysap5 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When I tried to insert 5000lines of HTML code to the variable in Java, I'm getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • Convert time to GMT time

    In T-SQL, I want to store the date from the getDate() function in GMT time instead of local time.

    Apinto5 pointsBadges:
  • Free Chapter – Beginning Spatial with SQL Server 2008

    Another free chapter download is available on the IT Bookworm Blog. Written by: Alastair Aitchison Book: Beginning Spatial with SQL Server 2008 Overview: "Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the...

    BrentSheets6,925 pointsBadges:
  • How to backup a SQL Server database

    Hello, I wonder if you can help. We are just about to start implemetation of SQL 2005 Server. Can anybody, let me know how we go about backing up the database? We have veritas 9.1 but I guess we need to back-up live if possible. What is our best option?

    Garrybreed45 pointsBadges:
  • Backing up SQL Server with specific settings

    I have set up my SQL Server backup using the native backup and restore option, but I want to have the files append for 5 days and then have the original file overwritten for the next 5 days. Right now, it's set to append the entire time, and this fills the disks rather quickly. How can I achieve...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I structure this in SSIS?

    Within SSIS, I need to do the following: Select the max(to_date) + 1 from a table in SQL Server. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1. How can I do...

    SQL Server Ask the Experts2,585 pointsBadges:
  • combo box in dbgrid

    I want to drop combo box in dbgrid. How to do it?

    Sysmatics25 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    I want to make the SQL connection with VB 6. How do I open the connection in SQL?

    Vishalngp15 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 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