sql access /rights
In order to create databases you need dbcreator role. The following article expalins the various roles and what permissions they give. While sysadmin would give you GOD power over the server and sounds like that isn’t something the client is comfortable with, there is no standard role that will give you the specific things you [...]
View Answer
| September 17, 2012 5:45 PM
SQL Security
In order to create databases you need dbcreator role. The following article expalins the various roles and what permissions they give. While sysadmin would give you GOD power over the server and sounds like that isn’t something the client is comfortable with, there is no standard role that will give you the specific things you [...]
View Answer
| September 17, 2012 5:45 PM
SQL Security
DBMS query
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 14, 2013 11:11 AM
Database
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 14, 2013 11:11 AM
Database
Out look email
This should help: http://ask.metafilter.com/105489/How-to-export-Outlook-email-to-a-spreadsheet-including-DateTime-fields http://www.techrepublic.com/blog/msoffice/quickly-export-outlook-e-mail-items-to-excel/744 Good Luck.
View Answer
| August 27, 2012 3:59 PM
Outgoing email, tables
This should help: http://ask.metafilter.com/105489/How-to-export-Outlook-email-to-a-spreadsheet-including-DateTime-fields http://www.techrepublic.com/blog/msoffice/quickly-export-outlook-e-mail-items-to-excel/744 Good Luck.
View Answer
| August 27, 2012 3:59 PM
Outgoing email, tables
Powershell, loop through two different arrays?
I am not sure I understand exactly but here is what I think you are trying to do. You want to read in two files one with a list of computer names and the other with just the alphabet. You want to read in the comp name from file 1, do some work and then append file [...]
View Answer
| February 11, 2013 11:12 PM
Arrays, LOOP statement, PowerShell, PowerShell Scripts, Scripting
I am not sure I understand exactly but here is what I think you are trying to do. You want to read in two files one with a list of computer names and the other with just the alphabet. You want to read in the comp name from file 1, do some work and then append file [...]
View Answer
| February 11, 2013 11:12 PM
Arrays, LOOP statement, PowerShell, PowerShell Scripts, Scripting
Want to move into Technical Side
Graduation in Chemistry, Post Graduation in HR and now you want to do DBA or DW. Your profile would not be able to fetch you interview calls – as it will not convince the recruiter (yourself being one for last 3 years, would you shortlist for a DBA position or DWH developer position a person [...]
View Answer
| December 29, 2012 11:26 AM
Career development, DBA, IT careers
Graduation in Chemistry, Post Graduation in HR and now you want to do DBA or DW. Your profile would not be able to fetch you interview calls – as it will not convince the recruiter (yourself being one for last 3 years, would you shortlist for a DBA position or DWH developer position a person [...]
View Answer
| December 29, 2012 11:26 AM
Career development, DBA, IT careers
Exceeding maximum record locks in Access
Have you thought about unlocking it?
View Answer
| June 28, 2012 4:47 PM
Access, Access Records, INSERT statement, Windows XP
Have you thought about unlocking it?
View Answer
| June 28, 2012 4:47 PM
Access, Access Records, INSERT statement, Windows XP
Create a Flat File from Access 2007 Database
you click on external data, then click on ‘text file’, browse for the file you want, then choose the first option which says ‘import the data into a new table in curretn database’. you then double click on the table which has the data added to it on the left hand side!! hope this helps!!x
View Answer
| November 21, 2012 3:29 PM
Access 2007, Access Database, Flat files, Windows 7
you click on external data, then click on ‘text file’, browse for the file you want, then choose the first option which says ‘import the data into a new table in curretn database’. you then double click on the table which has the data added to it on the left hand side!! hope this helps!!x
View Answer
| November 21, 2012 3:29 PM
Access 2007, Access Database, Flat files, Windows 7
Creating Access table
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 14, 2013 2:48 PM
Access, Access Database, Access Database Design, Access Tables, Database design, ER diagrams, Windows 7
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 14, 2013 2:48 PM
Access, Access Database, Access Database Design, Access Tables, Database design, ER diagrams, Windows 7
Wireless Telecom Certifications
This is going to depend on what you’re looking to accomplish. Is it for a specific business initiative? For your personal career? The CWNP certifications are held in high regard, so check those out.
View Answer
| January 30, 2013 9:27 AM
IT careers, IT certification, IT certification and training, Wireless Certification, Wireless phones, Wireless Telecom, Wireless Training
This is going to depend on what you’re looking to accomplish. Is it for a specific business initiative? For your personal career? The CWNP certifications are held in high regard, so check those out.
View Answer
| January 30, 2013 9:27 AM
IT careers, IT certification, IT certification and training, Wireless Certification, Wireless phones, Wireless Telecom, Wireless Training
AS400 – SQL
Below is the sample code for what you are asking,hope it will help: Declare name varchar(10); begin name:=’Juzer’; Update File Set Fname = Substr(name,1,3) Where empno=99; end; /
View Answer
| July 5, 2012 8:07 AM
AS/400 SQL, AS400 - SQL Queries, SQL queries, SQL Query
Below is the sample code for what you are asking,hope it will help: Declare name varchar(10); begin name:=’Juzer’; Update File Set Fname = Substr(name,1,3) Where empno=99; end; /
View Answer
| July 5, 2012 8:07 AM
AS/400 SQL, AS400 - SQL Queries, SQL queries, SQL Query
AS400 Shell command
Change the subsystem description to allow more jobs to run: CHGSBSD SBSD(MySbs) MAXJOBS(n+2) where n = current MAXJOBS. This should not cause a problem with regular batch jobs — it will not suddenly start running multiple batch jobs at once. Let’s say your subsystem MySbs has 1 jobq MyJobQ assigned to it, and MyJobQ has [...]
View Answer
| October 12, 2012 5:07 AM
AS/400 CSV, AS400 - STRQSH, AS400 Shell command, CSV, Shell commands
Change the subsystem description to allow more jobs to run: CHGSBSD SBSD(MySbs) MAXJOBS(n+2) where n = current MAXJOBS. This should not cause a problem with regular batch jobs — it will not suddenly start running multiple batch jobs at once. Let’s say your subsystem MySbs has 1 jobq MyJobQ assigned to it, and MyJobQ has [...]
View Answer
| October 12, 2012 5:07 AM
AS/400 CSV, AS400 - STRQSH, AS400 Shell command, CSV, Shell commands
MS Access DATABASE and combobox in VB6.0
‘Use this codeOn Error Resume NextDo While Not Form6.Adodc1.Recordset.EOF = TrueCombo1.AddItem Form6.Adodc1.Recordset.Fields(“REF_ID”)Adodc1.Recordset.MoveNextLoop‘End If
View Answer
| October 12, 2012 4:26 AM
Access Database, ComboBox, Microsoft Access, VB 6.0, Visual Basic
‘Use this codeOn Error Resume NextDo While Not Form6.Adodc1.Recordset.EOF = TrueCombo1.AddItem Form6.Adodc1.Recordset.Fields(“REF_ID”)Adodc1.Recordset.MoveNextLoop‘End If
View Answer
| October 12, 2012 4:26 AM
Access Database, ComboBox, Microsoft Access, VB 6.0, Visual Basic
How do I create a database using C language?
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 15, 2013 4:01 AM
C++, CREATE DATABASE statement, Data base design, Database, Database management
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 15, 2013 4:01 AM
C++, CREATE DATABASE statement, Data base design, Database, Database management
Storing HTML in a Physical File
I have a similar function with similar restrictions (for those same reasons). Minimal benefit to being the pioneer who first implements a better process (I like learning new/better methods but tough to do when we’re SO busy). I set up a PF to contain the results (html plus other fields used by the email creation [...]
View Answer
| July 5, 2012 1:21 AM
Database, DDS, HTML, PF, System i
I have a similar function with similar restrictions (for those same reasons). Minimal benefit to being the pioneer who first implements a better process (I like learning new/better methods but tough to do when we’re SO busy). I set up a PF to contain the results (html plus other fields used by the email creation [...]
View Answer
| July 5, 2012 1:21 AM
Database, DDS, HTML, PF, System i
Extra Page Printing
Remove formatting from extra cells. Formatting equals “I want this printed,” somehow in Excel. Select the right-hand columns you don’t want to print, right-click, and select Delete. This doesn’t work when you simply hit the delete key. Repeat for rows at the bottom of the page. If you format cells for the entire workbook, you [...]
View Answer
| June 22, 2012 11:04 PM
Microsoft Access 2007, Microsoft Access printing
Remove formatting from extra cells. Formatting equals “I want this printed,” somehow in Excel. Select the right-hand columns you don’t want to print, right-click, and select Delete. This doesn’t work when you simply hit the delete key. Repeat for rows at the bottom of the page. If you format cells for the entire workbook, you [...]
View Answer
| June 22, 2012 11:04 PM
Microsoft Access 2007, Microsoft Access printing
New member contest: ASK, Answer and Win a $50 Amazon gift card
“As 2008 winds to a close,” implies this is either wrong or a copy-and-paste job. If you are still having trouble getting rid of the $50 Amazon gift card, make it a gift to your local homeless shelter.
View Answer
| June 22, 2012 10:47 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP
“As 2008 winds to a close,” implies this is either wrong or a copy-and-paste job. If you are still having trouble getting rid of the $50 Amazon gift card, make it a gift to your local homeless shelter.
View Answer
| June 22, 2012 10:47 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP
GROUP BY mysql
What column are you wanting to group by? I’ll just call it groupColumn for now, ok? So taking that into account, here is what I’d do: SELECT groupColumn, max(VersionNumber) FROM tableName GROUP BY groupColumn; Hope that help! Ron <a href=”http://mysqlexchange.com”>
View Answer
| June 22, 2012 4:01 PM
MySQL, MySQL Database, MySQL query
What column are you wanting to group by? I’ll just call it groupColumn for now, ok? So taking that into account, here is what I’d do: SELECT groupColumn, max(VersionNumber) FROM tableName GROUP BY groupColumn; Hope that help! Ron <a href=”http://mysqlexchange.com”>
View Answer
| June 22, 2012 4:01 PM
MySQL, MySQL Database, MySQL query
Soon you can redeem knowledge points for Amazon.com gift cards
Thanks (this is old and not really a question).
View Answer
| June 16, 2012 4:03 AM
AS/400, Channel, CIO, CRM, Data Center, Database, Development, Exchange, Linux, Lotus Notes, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows
Thanks (this is old and not really a question).
View Answer
| June 16, 2012 4:03 AM
AS/400, Channel, CIO, CRM, Data Center, Database, Development, Exchange, Linux, Lotus Notes, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows
Embedded SQL Update Query
Try this: ————– update FileA set telefon = (select telefon from FileB where FileA.empid = FileB.empid) where empid in(<here is comma-list of ids of your 3-4 employee>) —————-
View Answer
| June 13, 2012 3:15 PM
Embedded SQL
Try this: ————– update FileA set telefon = (select telefon from FileB where FileA.empid = FileB.empid) where empid in(<here is comma-list of ids of your 3-4 employee>) —————-
View Answer
| June 13, 2012 3:15 PM
Embedded SQL
Delete query in Embedded SQL
Use c+ GET DIAGNOSTICS :delrowcnt = ROW_COUNT after delete statement that should give number of deleted records
View Answer
| November 28, 2012 2:22 PM
Embedded SQL
Use c+ GET DIAGNOSTICS :delrowcnt = ROW_COUNT after delete statement that should give number of deleted records
View Answer
| November 28, 2012 2:22 PM
Embedded SQL
