Removing data in a column after a hyphen
We imported a text file and one of the columns has first and last names in it. However, there is sometimes a hyphen with a title after the name. We need to create a SQL statement that will look for the hyphen and remove it and anything following it. Example: Column 1 Column 2 02/18/09 [...]

Answer Question   |  May 20, 2009  4:39 PM
SQL Database, SQL Database Formatting, SQL statement

Display Query for OS/400 SQL script
Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.

Answer Question   |  May 19, 2009  3:15 PM
OS/400, OS/400 Query, Query for OS/400, SQL scripts

Changing Database Collation
Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.

Answer Question   |  May 20, 2009  9:23 AM
Collation, Database collation, SQL Server 2000

Remote connection on SQL Server 2005 Express
shibu.govind is online. shahina: http://support.microsoft.com/kb/914277 Sent at 11:26 PM on Tuesday shahina: F:C#PROJECTSQMSED2.0QMSEDBINDEBUGQMSEDQMSED.MDF Sent at 11:52 PM on Tuesday shahina: firewall.cpl Sent at 12:20 AM on Wednesday shahina: C:Program FilesVMSRlink SMS Ed V2.0 3:35 AM NODE3SQLEXPRESS;Initial Catalog=G:C#ProjectsVMSClinic1.0QMSEdbinVMSClinicVMSClinic.MDF;Integrated Security=True” />–> ——————————————————————————– shahina: Hello, I have microsoft sql express installed on one computer running on windows authentication. [...]

Answer Question   |  May 20, 2009  8:19 AM
Remote connection, SQL Express 2005, SQL Server 2005 Express

Finding nth most recent action with SQL
I am trying to determine the date on which a certain number of things have happened cumulatively, eg I have a varying number of buyers each month. I want to find out on what date of that month, those buyers make their 3rd purchase. My SQL doesn’t seem to support TOP or ROWCOUNT so I [...]

Answer Question   |  May 19, 2009  10:11 PM
COUNT statement, Database programming, SQL, SQL query optimization, SQL statements, SUM statement

question: T-SQL stored procedure conversion to C# CLR assembly….
I’m wondering why it is difficult to find an example ( in literature or Internet ) example of converting a T-SQL procedure which contains “out” variables into identical C# CLR stored procedure. Is there something which prohibits this conversion ? If not, can someone provide or cite example ? Real world T-SQL procedures may tend [...]

Answer Question   |  May 19, 2009  4:49 PM
C#, CLR, T-SQL, T-SQL Stored Procedures

Crystal Reports in Web application with SQL Server 2005 Express
i want to create crystal report in asp.net 2.0 web application with sql server 2005 express edition. now the name of my database which i have created its name is Database.mdf. now whenever i expert database i can find my server name but in the dropdownlist of database i can`t find my database name. there [...]

Answer Question   |  May 18, 2009  4:56 AM
ASP.NET 2.0, Crystal Reports, SQL Server 2005, SQL Server 2005 connectivity, SQL Server 2005 Express, Web applications, Web development

Performance issues with a large table in SQL Server 2005
I have an application that is managing inventory for a company that has multiple locations. Items are being inserted into an inventory table roughly every 5-6 seconds from three locations. At the same time, this company is packing inventory in boxes in order to fulfill orders. I have a table setup for this in which [...]

Answer Question   |  May 18, 2009  12:11 AM
SQL Server 2005 performance, SQL server 2005 performance tuning, SQL Server query optimization

SQL Server Agent Job Creation
Hello, My self Ashish Amodia from India, I want to send Automatic mail with an attachment for that I have created job and from job that I want to open my web page automatically – I am using SQL server 2000. If u know how to open web page from job than please let me [...]

Answer Question   |  May 15, 2009  4:48 AM
SQL Server 2000, SQL Server 2000 administration, SQL Server Agent, SQL Server Agent Jobs

SQL 2000 Upgrade
I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?

Answer Question   |  May 29, 2009  4:23 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2005

Going from SQL Server 64-bit Enterprise to 32-bit Standard
Can the database be moved from a 64-bit Enterprise Edition SQL server to the 32-bit Standard Edition? What kind of issues there might be associated with this move?

Answer Question   |  May 15, 2009  1:02 AM
SQL Server (32-bit), SQL Server (64-bit), SQL Server migration

EMC networker MSSQL Restore hangs
I am trying to restore the model database on a EMC MSSQLv5.1 client The EMC server is version 7.4.2 When running the restore we can see no activity on the Client and in the Networker console it shows the server as “browsing”. In the devices tab no tapes are loading and nothing is reading from [...]

Answer Question   |  May 13, 2009  5:25 PM
EMC, EMC NetWorker, EMC Server 7.4.2, MSSQL

Deadlocks and Conflicting resources
I have a program that loops through a temp table, and for each row looks up a value in another table, and depending on the result returned inserts a record into one of two tables. Some days this takes 10 minutes to run and others it takes 2 hours to run. There are no other [...]

Answer Question   |  May 13, 2009  1:52 PM
SQL Server 2000, SQL stored procedures

Invalid String or buffer length ERROR
I am trying to connect to SQL server 2005 express edition using JDBCODBC bridge driver. I have succesfuly configured the data source but when I use DriverManager.getConnection(“jdbc:odbc:sql”)–>sql is the data source name.. I catch this Exception.. Many thanks in advance

Answer Question   |  March 5, 2012  7:19 PM
JDBCODBC, SQL Server 2005, SQL Server 2005 Express, SQL Server error messages

stored procs in Master db, sql server 2005
Does anyone know where I can get a list describing, in layman’s terms, all the sp_usr… stored prodedures in the Master database? New to all this and don’t have the time or knowledge to decipher the TSQL behind it. Hope someone can help! Cheers

Answer Question   |  May 16, 2009  3:49 PM
SQL Server 2005, SQL Server stored procedures, T-SQL

Connecting VB2008 to SQLServer2005
How to connect VB2008 with SQLServer2005 through coding.. Not through OleDBAdaptar.. Also Let me know the code for Add,Edit, Delete & Save in VB2008

Answer Question   |  September 2, 2011  6:02 PM
OLE, SQL Server 2005, VB 2008, Visual Basic

sql Help
I have a ten character field and need to exclude records if the first 2 character equal a specific pattern how do you do that?

Answer Question   |  May 11, 2009  5:21 PM
SQL, SQL Fields

Oracle OMS – Please Help
i’m expert on SQL Server, but new to Oracle world. the oracle is installed on Windows 2000, if i need to do anything (backup, creation of new Shema, importing data…)it gives me that i have to use OMS . i found that OMS needs sysman user, or after searching i found that this username doesn’t [...]

Answer Question   |  May 12, 2009  3:18 PM
OMS (Oracle Management Server), Oracle 9i, Oracle Management Server, SQL Server, SYSMAN, Windows Server 2000

How to use DateDiff to calculate costs?
Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod [...]

Answer Question   |  May 13, 2009  10:16 AM
Database programming, DATEDIFF, Microsoft Access

Querying database tables with their descriptions
I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?

Answer Question   |  May 11, 2009  10:01 AM
SQL, SQL queries, SQL Server Query