Why are naturl JOIN keywords not an option for producing a self-join?
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 13, 2013 3:20 PM
JOIN statement, SQL procedure
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 13, 2013 3:20 PM
JOIN statement, SQL procedure
Retrieving data from SQL server 2005 using VB6? VB6??
This site appears to give a good example on how to use VB6 with SQL Server. http://www.codeproject.com/KB/vbscript/simple_sp_vb6.aspx Yep – VB6 is an ideal language to do that (if a little dated). Can you expand on what you want to do?
View Answer
| October 7, 2009 2:41 PM
SQL Server 2005, VB, Visual Basic
This site appears to give a good example on how to use VB6 with SQL Server. http://www.codeproject.com/KB/vbscript/simple_sp_vb6.aspx Yep – VB6 is an ideal language to do that (if a little dated). Can you expand on what you want to do?
View Answer
| October 7, 2009 2:41 PM
SQL Server 2005, VB, Visual Basic
How does SQL Server 2000 CAL licensing work
No any number of users can connect to the SQL Server. Each user that needs to be able to connect to the SQL Server will need to have a SQL Server CAL.
View Answer
| October 7, 2009 7:29 AM
SQL Server 2000, SQL Server CAL licensing, SQL Server licensing
No any number of users can connect to the SQL Server. Each user that needs to be able to connect to the SQL Server will need to have a SQL Server CAL.
View Answer
| October 7, 2009 7:29 AM
SQL Server 2000, SQL Server CAL licensing, SQL Server licensing
Change SQL Server licensing
SQL Server 2005 and up don’t really license this way any more. The server doesn’t really care how many CALs you purchase as long as you are legal.
View Answer
| October 6, 2009 6:28 PM
SQL Server 2000, SQL Server 2005, SQL Server licensing
SQL Server 2005 and up don’t really license this way any more. The server doesn’t really care how many CALs you purchase as long as you are legal.
View Answer
| October 6, 2009 6:28 PM
SQL Server 2000, SQL Server 2005, SQL Server licensing
Oracle LIKE statement on SQL Server 2005
Hi, Oracle SQL syntax, like most, requires a wild card to accurately use a LIKE % is a wild card that means zero or more characters _ is a wild card that means one (and only one) character col1 LIKE ‘ABC%’ would search col1 looking for values that start with ABC, whether anything follows or [...]
View Answer
| October 5, 2009 2:49 PM
LIKE statement, Oracle 10g, Oracle Statements, SQL Server 2005
Hi, Oracle SQL syntax, like most, requires a wild card to accurately use a LIKE % is a wild card that means zero or more characters _ is a wild card that means one (and only one) character col1 LIKE ‘ABC%’ would search col1 looking for values that start with ABC, whether anything follows or [...]
View Answer
| October 5, 2009 2:49 PM
LIKE statement, Oracle 10g, Oracle Statements, SQL Server 2005
SQL 2008 Security: How do I give users access to just views within a DB?
You’ll want to create a roll, and give the role access to the views. Then make the users members of the role.
View Answer
| October 3, 2009 11:43 PM
Microsoft Excel, SQL, SQL 2008
You’ll want to create a roll, and give the role access to the views. Then make the users members of the role.
View Answer
| October 3, 2009 11:43 PM
Microsoft Excel, SQL, SQL 2008
Best way to copy large amount files
you can used robocopy or teracopy http://www.codesector.com/teracopy.php http://technet.microsoft.com/en-us/magazine/2009.04.utilityspotlight.aspx —————————————- xcopy and drag and drop are basically the same thing. You can do either. By the way do you mean iSeries?
View Answer
| October 2, 2009 5:01 PM
Bulk Copy Program, Copy programs, NAS, NAS devices
you can used robocopy or teracopy http://www.codesector.com/teracopy.php http://technet.microsoft.com/en-us/magazine/2009.04.utilityspotlight.aspx —————————————- xcopy and drag and drop are basically the same thing. You can do either. By the way do you mean iSeries?
View Answer
| October 2, 2009 5:01 PM
Bulk Copy Program, Copy programs, NAS, NAS devices
installing sql server 2000 32-bit on vista 64-bit
Use some kind of Virtualuzation. Vmware server or Workstation.
View Answer
| October 2, 2009 11:34 AM
SQL Server 2000, SQL Server 2000 32-bit, Vista, Windows Vista 64-bit
Use some kind of Virtualuzation. Vmware server or Workstation.
View Answer
| October 2, 2009 11:34 AM
SQL Server 2000, SQL Server 2000 32-bit, Vista, Windows Vista 64-bit
Working TRIGGER and TRANSACTIONS QUESTION
First, everything is in some kind of “transaction”. When you do a “Begin Transaction”, you are stating that everything up to the next “Commit” (or Rollback) is to be considered as a single transaction. If you execute a SQL statement when there is no “Begin Transaction” active, that single statement is itself a transaction. From [...]
View Answer
| October 1, 2009 9:07 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER
First, everything is in some kind of “transaction”. When you do a “Begin Transaction”, you are stating that everything up to the next “Commit” (or Rollback) is to be considered as a single transaction. If you execute a SQL statement when there is no “Begin Transaction” active, that single statement is itself a transaction. From [...]
View Answer
| October 1, 2009 9:07 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER
Database Views in SQL Server
I think I forgot to mention that I am trying to create a crystal report which pulls from three different views that I created in SQL Server. Little hard to do when I can not access the views from crystal reports/database expert.
View Answer
| September 30, 2009 11:08 PM
Database Expert, SQL Server databases, Windows Server 2003, Windows XP
I think I forgot to mention that I am trying to create a crystal report which pulls from three different views that I created in SQL Server. Little hard to do when I can not access the views from crystal reports/database expert.
View Answer
| September 30, 2009 11:08 PM
Database Expert, SQL Server databases, Windows Server 2003, Windows XP
SQL Server 2000 hang and shrink won’t stop
Your database is in the process of checking the database before bringing it online. There’s no way to stop it. It’s going through the log committing completed transactions and rolling back aborted transactions. You should NEVER detach the database and delete the log file. If you don’t need point in time restores then change the [...]
View Answer
| September 29, 2009 9:04 PM
Event Viewer, SQL Database, SQL Server 2000
Your database is in the process of checking the database before bringing it online. There’s no way to stop it. It’s going through the log committing completed transactions and rolling back aborted transactions. You should NEVER detach the database and delete the log file. If you don’t need point in time restores then change the [...]
View Answer
| September 29, 2009 9:04 PM
Event Viewer, SQL Database, SQL Server 2000
Export Oracle data to Excel
You could use this code. This use ODBC to connect to an Oracle database and copies the entire recordset into the worksheet. Dim db as database Dim rs as recordset Dim SQLSt as string Set db = OpenDatabase(“ODBCDSNName”, False, False, “ODBC;DSN=ODBCDSNName;ConnectString=OracleHostName;UID=OracleUserName;PWD=OraclePassword”) sqlSt = “SELECT col1, col2, … FROM Table1 WHERE Col1 = ‘” & SomeVariable [...]
View Answer
| September 29, 2009 5:34 PM
Oracle, Oracle export, SQL, SSRS
You could use this code. This use ODBC to connect to an Oracle database and copies the entire recordset into the worksheet. Dim db as database Dim rs as recordset Dim SQLSt as string Set db = OpenDatabase(“ODBCDSNName”, False, False, “ODBC;DSN=ODBCDSNName;ConnectString=OracleHostName;UID=OracleUserName;PWD=OraclePassword”) sqlSt = “SELECT col1, col2, … FROM Table1 WHERE Col1 = ‘” & SomeVariable [...]
View Answer
| September 29, 2009 5:34 PM
Oracle, Oracle export, SQL, SSRS
Getting last entries from two different tables
You could try using the in line view like this: Select table1.col1, table1.col2, table1…., table2.col1, table2.col2, table2…. from (SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) as table1, (SELECT * FROM OtherTable WHERE dbo.OtherTable.ID = (SELECT max(ID) from dbo.OtherTable ID) as table2 —————- another approach from meandyou This works on [at [...]
View Answer
| September 29, 2009 12:02 PM
MSSQL, SQL tables
You could try using the in line view like this: Select table1.col1, table1.col2, table1…., table2.col1, table2.col2, table2…. from (SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) as table1, (SELECT * FROM OtherTable WHERE dbo.OtherTable.ID = (SELECT max(ID) from dbo.OtherTable ID) as table2 —————- another approach from meandyou This works on [at [...]
View Answer
| September 29, 2009 12:02 PM
MSSQL, SQL tables
sql 2008 system tray icon
You can download the free tool <b>SqlTrayManager </b>from this site <a href=”http://freesqltools.info/”>http://freesqltools.info/</a> It allows you to manage local and remote SQL servers , works with all versions of SQL server . Around 200k in size , requires .NET framework 2.0 though . I am using it my self on all servers .
View Answer
| September 28, 2009 8:29 PM
SQL Server 2000, SQL Server 2008
You can download the free tool <b>SqlTrayManager </b>from this site <a href=”http://freesqltools.info/”>http://freesqltools.info/</a> It allows you to manage local and remote SQL servers , works with all versions of SQL server . Around 200k in size , requires .NET framework 2.0 though . I am using it my self on all servers .
View Answer
| September 28, 2009 8:29 PM
SQL Server 2000, SQL Server 2008
SQL error
Is this an SQL error that you get or an error generated by your programs? Phil ========================================================================== You could use DSPATR(ND) to “hide” the value when you don’t want it displayed. Phil =========================================================================
View Answer
| September 28, 2009 4:43 PM
DB2, DB2/400, SQL error messages, SQLRPGLE
Is this an SQL error that you get or an error generated by your programs? Phil ========================================================================== You could use DSPATR(ND) to “hide” the value when you don’t want it displayed. Phil =========================================================================
View Answer
| September 28, 2009 4:43 PM
DB2, DB2/400, SQL error messages, SQLRPGLE
how to use sql server 2005
The SQL Server Management Studio should have been installed with SQL 2005. You can use that to manage your database. If it wasn’t installed (it’ll be listed in the Start > Programs > Microsoft SQL Server 2005 program group). If it isn’t there launch the SQL Server installer again and run through the installer. When [...]
View Answer
| September 27, 2009 5:37 PM
SQL Server 2005, SQL Server database
The SQL Server Management Studio should have been installed with SQL 2005. You can use that to manage your database. If it wasn’t installed (it’ll be listed in the Start > Programs > Microsoft SQL Server 2005 program group). If it isn’t there launch the SQL Server installer again and run through the installer. When [...]
View Answer
| September 27, 2009 5:37 PM
SQL Server 2005, SQL Server database
Error when insertin.g data into SQL table
One of the text or binary fields in the table is smaller than the value you are trying to put into it. You need to limit the size of the value or increase the size of the field.
View Answer
| September 26, 2009 9:33 PM
Microsoft Visual Studio, SQL Server 2005, SQL Server 2005 Express, SQL Server tables, SQL tables, VB.NET, VB.NET 2005, VB.NET 2005 programming, Visual Studio 2005
One of the text or binary fields in the table is smaller than the value you are trying to put into it. You need to limit the size of the value or increase the size of the field.
View Answer
| September 26, 2009 9:33 PM
Microsoft Visual Studio, SQL Server 2005, SQL Server 2005 Express, SQL Server tables, SQL tables, VB.NET, VB.NET 2005, VB.NET 2005 programming, Visual Studio 2005
synonym in SQL server 2005
You have to use the base_object_name column to figure it out. This code should do the trick. <pre>select *, object_name(object_id(substring(base_object_name, charindex(‘.’, base_object_name)+1, len(base_object_name)))) from sys.synonyms</pre> You can now use sys.objects to get the base object type. Something like this: <pre>SELECT o.name,o.type_desc FROM sys.objects o JOIN sys.synonyms s ON object_name(object_id(substring(s.base_object_name, charindex(‘.’, s.base_object_name)+1, len(s.base_object_name)))) = o.name WHERE [...]
View Answer
| September 25, 2009 6:56 PM
SQL Server 2005, SQL Server Synonyms, SQL Server System Tables
You have to use the base_object_name column to figure it out. This code should do the trick. <pre>select *, object_name(object_id(substring(base_object_name, charindex(‘.’, base_object_name)+1, len(base_object_name)))) from sys.synonyms</pre> You can now use sys.objects to get the base object type. Something like this: <pre>SELECT o.name,o.type_desc FROM sys.objects o JOIN sys.synonyms s ON object_name(object_id(substring(s.base_object_name, charindex(‘.’, s.base_object_name)+1, len(s.base_object_name)))) = o.name WHERE [...]
View Answer
| September 25, 2009 6:56 PM
SQL Server 2005, SQL Server Synonyms, SQL Server System Tables
Optimizing Query that uses linked tables and bound form w/joins
This makes sense as Access sees the tables as seperate objects so it will do the join within Access instead of in the SQL Server. The only way to handle this with a view would be to set it up so that each update only touched a single base table at a time. You could [...]
View Answer
| September 24, 2009 7:03 PM
Access, Linked Tables, SQL Server
This makes sense as Access sees the tables as seperate objects so it will do the join within Access instead of in the SQL Server. The only way to handle this with a view would be to set it up so that each update only touched a single base table at a time. You could [...]
View Answer
| September 24, 2009 7:03 PM
Access, Linked Tables, SQL Server
Windows Server and SQL database upgrade
The domain name change is totally separate from the other upgrades. After the domain has been renamed the SQL Servers will need to be rebooted. Nothing else should need to be done after this. You can optionally change the names of the Logins and users to match the new domain name. You don’t have to [...]
View Answer
| September 24, 2009 6:59 PM
SQL Server 2005, SQL Server Upgrade, Windows Server 2003 to Windows Server 2008 Upgrade, Windows Server 2008, Windows Server 2008 R2, Windows Server Upgrades
The domain name change is totally separate from the other upgrades. After the domain has been renamed the SQL Servers will need to be rebooted. Nothing else should need to be done after this. You can optionally change the names of the Logins and users to match the new domain name. You don’t have to [...]
View Answer
| September 24, 2009 6:59 PM
SQL Server 2005, SQL Server Upgrade, Windows Server 2003 to Windows Server 2008 Upgrade, Windows Server 2008, Windows Server 2008 R2, Windows Server Upgrades
