By default users won’t have access to any objects. If the user doesn’t have access to query a table then they will not be able to view the table.
View Answer | January 7, 2010 7:16 AM
SQL Server 2005, SQL Server permissions, SQL Server User Accounts, Windows Vista
Someone anwered the question Clock Time (ms.) Total is the # of ms taken to execute the bcp…. select (Average)*(Clock Time (ms.) Total )/1000 = rows copied select 15281.25 *239.578 = 3661051
View Answer | January 6, 2010 8:00 PM
BCP Utility, SQL 2005, SQL Server 2005
This gets a little involved, but if you break out the parts of this operation it isn’t too hard. > create a table to hold the results: tblnm = RESULTS cols = TBL_OWNR, TBL_NAME, COL_NAME, CNT, LITERAL > what we want to end up with is a list of queries, one qery for each column [...]
View Answer | January 6, 2010 5:04 PM
SQL Server, SQL Server database
What is the error message that you are getting? SQL Dumper shouldn’t stop you from logging into the Server.
View Answer | January 3, 2010 12:46 AM
Not sure if it will work from mainframe COBOL, but from WINTEL COBOL (MicroFocus), this works: EXEC SQL SELECT COLUMN_NAME INTO :VARIABLE_NAME FROM TABLE_NAME WHERE COLUMN 1 = :VARIABLE1 AND COLUMN 2 = ‘Hard Coded Value’ END-EXEC. ============================================================ Since Microsoft is the DB vendor, all you need to do is obtain the appropriate ODBC or [...]
View Answer | December 24, 2009 9:50 AM
It shouldn’t be a problem at all. Just put the SQL 2005 drivers on the machines with the powerbuilder app. If that becomes a problem, just continue to use the SQL 2000 driver. Of course you’ll want to test before hand a SQL 2000 to SQL 2005 is a very big upgrade.
View Answer | December 22, 2009 9:43 PM
PowerBuilder, PowerBuilder 7.0, SQL 2005
Yes you can connect an application written in Visual Studio 2003 to a SQL Server 2008 database without issue. As long as you have the correct driver installed on the machine you can connect just about anything to SQL Server.
View Answer | December 22, 2009 9:30 PM
SQL Server 2008, Visual Studio 2003
You could use the <a href=”http://msdn.microsoft.com/en-us/library/ms187928.aspx”>CONVERT</a> function to format dates (although it could be more efficient to do that on the front-end), and the ‘+’ operator to concatenate strings.
View Answer | December 22, 2009 3:34 PM
Microsoft Access, Query Manager, SQL 2005
In ODBC data source System DSN Add new DSN Name = test Desc = test server = lksql Next user login id and password enterer by user check Connect to sql server to obtain default setting enter user name and pw next change the default database to: only has the default db the user is [...]
View Answer | December 21, 2009 5:27 PM
ODBC, ODBC Errors, SQL 2000, SQL 2008
Yes a data driven subscription is what you want to use.
View Answer | December 18, 2009 10:41 PM
SQL Server Reporting Services, SSRS, SSRS reports
Typically large high transaction SQL Servers are not typically good candidates for virtualization. First when you virtualize a server you can’t assign as more cores to the VM as you currently have. The most cores you can assign are the number of cores on a single physical CPU. So if your VMware server has 4 [...]
View Answer | December 16, 2009 3:24 AM
Database, Database administration, Enterprise Virtualization, SQL Server Virtualization
Yes you can do this. No SQL 2008 wouldn’t fix this problem. The problem isn’t a problem with SQL Server, but a lack of 64bit Jet drivers. The Jet driver is the ODBC driver which you use to talk to the Access database. The Jet driver is only available in a 32bit driver at this [...]
View Answer | December 15, 2009 8:15 PM
MS Access, SQL Server, SQL Server 2005
What hardware and software are you using? ———– Yes, you can do that on MySql. Remember that aplying functions to fields in the where clause, prevents the database system from using indexes. -CarlosDL
View Answer | December 15, 2009 5:06 PM
MySQL functions, RIGHT JOIN, SQL join
Hi Sherry. Welcome back to ITKE. ISNUMERIC is a T-SQL function, and Oracle doesn’t have an equivalent. However, you can easily build your own. Something like this: <pre>CREATE OR REPLACE FUNCTION isnumeric(p_value IN VARCHAR) RETURN NUMBER IS l_value NUMBER; BEGIN l_value := p_value; RETURN 1; EXCEPTION WHEN value_error THEN RETURN 0; END; / </pre> After [...]
View Answer | December 14, 2009 7:42 PM
SQL error messages, SQL Testing, WINSQL Numeric Function
You’ll want to open up a binary stream and read that binary stream into a variable. Then take that variable and write the value into the table or stored procedure.
View Answer | December 14, 2009 8:04 AM
Microsoft Office, SQL Server 2000, VB6, Visual Basic
It depends on how you measure efficiency. For example the generated C code is not as fast as well crafted code. However the user response time difference is likely to be trivial. For developer efficiency, I can build, test and deploy 3 SQL stored procedures in a half hour while an RPG developer takes 2 [...]
View Answer | December 14, 2009 1:52 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
Oh what a disappointment, there must be a lot more people curious about Foxpro than the AS/400. Phil What I feel is that if we start time limit in which a question can be answered, then we will have vastly reduced the effectiveness of this site.
View Answer | December 11, 2009 4:42 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Yes, you can. <pre>SELECT * FROM yourTable WHERE field1+field2 IN (’01XX’,’02YY’,’03ZZ’);</pre>
View Answer | December 10, 2009 3:39 PM
SQL Server development, SQL Server tables, WHERE condition
You’ll want something like this. <pre>select * from Employee join (select Department, avg(Salary) Salary FROM Employee group by Department) a on Employee.Department = a.Department and Employee.Salary > a.Salary</pre>
View Answer | December 10, 2009 9:37 AM
SQL, SQL tables
A job would be used to run a DTS package by calling dtexec.
View Answer | December 8, 2009 6:09 AM
DTS package, SQL Jobs, SQL stored procedures