Do I need SQL?
SQL is a language commonly used to minupalate data in databases. If you are ‘just a home user and perform simple tasks’ you don’t need it. But, you might be talking about ‘SQL Server’ which is not the same. SQL Server is a database management system from Microsoft. Most likely you don’t need it directly, [...]

View Answer   |  November 25, 2010  2:15 PM
SQL, SQL procedure, SQL Server, SQL statements

Example of Cobol call to an SQL stored procedure
Without knowing a little more, it’s hard to say. There is a minimum set of statements needed. The first set would be somewhere in your Working-Storage section:<pre> EXEC SQL INCLUDE SQLCA END-EXEC.</pre> You will need the SQLCA to be included to give access to SQL error info, etc. You put it wherever seems best for [...]

View Answer   |  November 24, 2010  11:28 PM
COBOL, iSeries, iSeries Cobol programming, SQL stored procedures, Stored Procedures

IN and Exists in SQL?
There is difference in between them : When coding a SQL statement with tables in master-detail relationships, it’s common to have to decide whether to write the query using the WHERE EXISTS clause or the WHERE value IN clause. U may resist using WHERE EXISTS because it has the awkward syntax of returning a value, [...]

View Answer   |  November 24, 2010  9:47 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server

Microsoft SQL Server BCP Utility password
You can use the -T switch to use the windows account which the user is logged in with currently. If not you’ll need to pass in the -U and -P parameters.

View Answer   |  November 23, 2010  8:26 PM
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition

SBS monitoring
Hello Swan Digital, I am having the exeact same problem. I have done troubleshooting with Dell, but not able to resolve. Have you had any luck on it since your last post? NMCTechGuy

View Answer   |  November 22, 2010  9:44 PM
MSDE 2000, SBS 2003, Server management, Server monitoring, Small Business Server, Small Business Server 2003

Union operator in SQL server 2000
You could use your current query as an inline view. Something like this: <pre><b>SELECT * FROM (</b>SELECT ORGANIZATION_ID, INDIVIDUAL_ID, ISNULL(F_NAME, ”) + ‘ ‘ + ISNULL(M_NAME, ”) + ‘ ‘ + ISNULL(L_NAME, ”) AS ‘Name’, ISNULL(ADDRESS_LINE1, ”) + ‘ ‘ + ISNULL(ADDRESS_LINE2, ”) + ‘ ‘ + ISNULL(ADDRESS_LINE3, ”) + ‘ ‘ + ISNULL(ADDRESS_LINE4, ”) [...]

View Answer   |  November 22, 2010  3:41 PM
SQL Query, SQL Server, SQL Server 2000, SQL Server Query

SQL Server 2005 License
If you only have two CPU licenses you will need to physically remove the other two CPUs from the server. If you do not remove the other two CPUs then you will not be in compliance. With CALs you are on your honor to ensure that the users all have a CAL.

View Answer   |  November 19, 2010  10:34 PM
CAL, CPU, SQL 2005, SQL Server 2005 License, SQL Server licensing, Windows Server 2003

Blocking the use of web proxies.
Depending on how your network is setup, if your clients are using a Windows Domain and IE or Firefox as web browsers, you can force users to use the proxies that you setup. There are GPO settings built into Windows and you can download ADM policies for Firefox to set and force proxies for all [...]

View Answer   |  November 19, 2010  11:46 AM
DataCenter, Desktops, Management, Microsoft Windows, Network protocols, Networking, OS, Performance management, Security, Servers, SQL Server, Tech support

How to write text into word doc using SQL 2000 query analyzer
I am using this procedure to create and append the doc file but no result get till now why ??anybody clear it ?? alter PROCEDURE sp_AppendToFile(@FileName varchar(255), @Text1 varchar(255)) AS DECLARE @FS int, @OLEResult int, @FileID int EXECUTE @OLEResult = sp_OACreate ‘Scripting.FileSystemObject’, @FS OUT select @OLEResult IF @OLEResult <> 0 PRINT ‘Scripting.FileSystemObject’ –Open a file [...]

View Answer   |  November 19, 2010  7:05 AM
SQL 2000, SQL Query, SQL Query Analyzer, SQL Server 2000, SQL Server 2000 queries

Tomorrow at 4PM ET: ITKE Rolls Out New Badge System
cool.. all the best with the rolling out changes

View Answer   |  November 19, 2010  4:22 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server 2003

Is it safe to delete SQL Server Transaction Log?
Yes it is safe to remove from the database properties window. If there is a problem the database engine will return an error message before anything bad could happen.

View Answer   |  November 18, 2010  4:06 PM
Delete Transaction Log, SQL 2005, SQL Server 2005, SQL Server logs, SQL Server transaction logs, SQL transaction logs, Windows Server 2003

Copy BLOB to BLOB using TSQL
You could use an UPDATE statement (almost) as you would with other type of columns, but this could not be recommended depending on the amount of data being moved. —————

View Answer   |  November 18, 2010  4:01 PM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2

Can I direct query the Oracle database with SQL Plus?
With the appropriate credentials, you could connect to the database from SQL*Plus, and you would be able to query it if you know the appropriate object names and the user account has the appropriate privileges. So, it depends.

View Answer   |  November 18, 2010  3:08 PM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix

null v/s ” “(empty string) in Java
Null has no bounds, it can be used for string, integer, date, etc. fields in a database. Empty string is just regarding a string; it’s a string like ‘hgjko0p’ is, but is just has no length. If you have no value for a field, use null, not an empty string. Null is an absence of [...]

View Answer   |  November 18, 2010  8:41 AM
Java, Java code, Java developers, NULL, String name

Help running a CmdEXEC from the SQL Server
Make sure the path to your script exists and that the account being used has the necessary privileges to access it. Also, the script itself might not be seen as an executable by the system. For example, if you want to run a vbscript, the step command should be: <pre><b>cscript </b>c:pathscript.vbs</pre> and not just: <pre>c:pathscript.vbs</pre> [...]

View Answer   |  November 17, 2010  12:24 AM
CMD, SQL Server, VB script, Visual Basic Script

Delete all tables in SQL Server database?
Sql Server has an option of navigating to all tables using stored procedure sp_MSforeachtable For e.g the following command will drop all the tables in the database: exec sp_MSforeachtable 'DROP TABLE ?' The below command will clear all the tables: exec sp_MSforeachtable 'DELETE FROM ?' So by using the procedure sp_MSforeachtable you can navigate to [...]

View Answer   |  April 19, 2013  4:15 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables

Error Message ORA-00903 in SQL table
ORA-00903 IS “invalid table name”. Maybe you are receiving an ORA-00904, which means “invalid column name”. If tourid is a defined attribute in a table called Tour, then you can only use it when querying that table.

View Answer   |  November 15, 2010  5:19 PM
ORA-00903, SQL, SQL Plus, SQL tables

Can I backup the entire SQL drive?
I’ve removed the answer which provided you no useful information at all. If the SQL Server service is running then you can not backup the folders with the SQL Server databases in them as the files are locked. You have two options. 1. Just before your upgrade backup all the databases using the SQL Server [...]

View Answer   |  November 15, 2010  1:24 PM
Backup Exec, SQL Backup, SQL Express 2005, SQL Server, Veritas Backup Exec

What is the best way to replicate SQL 2008 DBs to a failover site?
There are a lot of questions which need answering before you can decide on a solution. 1. How much data are you willing to loose when a failover occurs? 2. What sort of downtime is acceptable when you need to fail over? 3. What sort of window is acceptable when you need to fail back? [...]

View Answer   |  November 15, 2010  1:17 PM
Failover, SQL Server, SQL Server 2008, SQL Server database, SQL Server replication

.mdf file backup in Visual Studio
When you published the application the database would have been attached to the SQL Server instance. Once the database file has been attached to the instance you’ll need to use the SQL Server’s BACKUP DATABASE command as the file is attached to the SQL Server process and can’t be touched while the SQL Server is [...]

View Answer   |  November 15, 2010  1:10 PM
.MDF files, Backup, C# .NET, MDF, Visual Studio