• Connect database from Oracle to VB 6.0 in SQL Server

    I'm a BCA student. I'm doing my project on college management system with VB 6.0. I want to know how to connect a database from Oracle to VB 6.0 in a SQL Server. Thanks!

    eliza72472fathima5 pointsBadges:
  • SQL Select columns with columnized ntext data

    I have a table with 20 columns, where column 2 is an ntext, and it contains 133 comma separated 'fields'. How do I read the 19 columns and include in the output, the 133 columns from the ntext column.

    PeterGrierson45 pointsBadges:
  • SQL Server password issues

    How can I access a SQL Server without a password, how can I change a SQL Server password, and what is an SA on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server: Parameterize IN clause

    Is there a way to parameterize an SQL query that contains an IN clause with a variable number of arguments? Something along the lines of this: select * from Tags where Name in ('ruby','rails','scruffy','rubyonrails') order by Count desc I don't want to use a stored procedure/XML so what's the best...

    ITKE366,325 pointsBadges:
  • Schedule backups on regular intervals in Azure Backup

    I have SQL Server on premises, data is about 20GB. I want to scheduled backups on regular intervals in Azure Backup. Would like to how it works?

    mmreddykiran5 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • INSERT or CREATE record in SQL Server database

    I have this SQL Server table structure: MyTable(KEY, datafield1, datafield2...) And now I have to update an existing record / create a new one if it doesn't appear. What's the best way to do that?

    ITKE366,325 pointsBadges:
  • Ignores my new column-store index in SQL Server 2014

    I am using SQL Server 2014. I had an existing table with lots of indexes. I added a non clustered column-store index as a test. When I run test queries it ignores my new column-store index. I don’t know Why? Should I remove the old indexes, leaving just the column store?

    danieljones205 pointsBadges:
  • SQL Server – SSIS

    what is SSIs in Sql Server?

    90497265505 pointsBadges:
  • Difference between nvarchar(max) and NText

    Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

    ITKE366,325 pointsBadges:
  • How to fix this error in SQL and Excel?

    When I execute the T-SQL, I want to copy result and paste Excel sheet but the numbers had problem. For example in SQL, 4.2900 but when I copied Excel 42.900. Can you help this problem please?

    edwinjhoffer3,000 pointsBadges:
  • Check if a column exists in SQL Server database

    In a SQL Server database, is there a way to check if a column exists in a table? This is what I came up with but it keeps returning false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') Thanks!

    ITKE366,325 pointsBadges:
  • How am I blocking connections to SQL Server 2008?

    This is a fairly specific issue, but I'm at a loss for reasons to what might be happening. We have SQL Server 2008 running on what we'll call ServerA. We can RDP in ServerA, we can ping ServerA. If we RDP into ServerA, we can open up SQL Server Management Studio and connect to all of the database...

    edwinjhoffer3,000 pointsBadges:
  • Recovering a truncated table on a SQL Server

    How can I recover a truncated table on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Grant permissions to user for backup/restore in SQL Server

    Can anyone tell me what permissions must I give to a user inside SQL Server 2005 so that this user can backup and restore a database without given him sysadmin server role?

    edwinjhoffer3,000 pointsBadges:
  • Problem with SQL Server Database File(.mdf)

    I am using SQL Server 2008 R2 and I want to check my master database file (.mdf) but failed to open it.

    edwinjhoffer3,000 pointsBadges:
  • Remove duplicate rows from a large table in SQL Server

    For SQL Server, does anyone know the best way to remove duplicate rows from a large table? Here's what I have so far: MyTable ----------- RowID int not null identity(1,1) primary key, Col1 varchar(20) not null, Col2 varchar(2048) not null, Col3 tinyint not null Thanks!

    ITKE366,325 pointsBadges:
  • How to disable SQL Server Management Studio for a user

    Is there a way to prevent users from getting into SQL Server Management Studio so that they can't just edit table rows manually? They still need to access the tables by running my application.

    edwinjhoffer3,000 pointsBadges:
  • Report having more than 240 columns in SSRS 2005

    Hi folks, I am using SSRS 2005 BI. As per MSDN standards SSRS 2005 will not support more than 240 columns in excel (while exporting, will get error). Now I am having more than 240 columns though I am using SSRS 2005, I am not getting any errors. However there is an error here: Reporting Services...

    BhakthaprahladaReddy2,030 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

    How would I go about migrating SQL Server 2005 back to SQL Server 2000?

    SQL Server Ask the Experts2,585 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