Database
The first step is to figure out all the information which will need to be stored in the system. From there you can start to figure out what the tables are that you need to create. Building a prison management system is a pretty large complex system. You might want to start with something easier [...]
View Answer
| October 9, 2012 4:33 PM
SQL, SQL Database
The first step is to figure out all the information which will need to be stored in the system. From there you can start to figure out what the tables are that you need to create. Building a prison management system is a pretty large complex system. You might want to start with something easier [...]
View Answer
| October 9, 2012 4:33 PM
SQL, SQL Database
SAP UPGRADATION PROJECT PHASES ?
sap upgrades is good for protecting from viruses
View Answer
| December 6, 2012 7:38 AM
Execution Plan, SAP upgrades
sap upgrades is good for protecting from viruses
View Answer
| December 6, 2012 7:38 AM
Execution Plan, SAP upgrades
Connection of VB6 with SQL Server 2000
View Answer
| July 6, 2012 6:47 AM
SQL Server 2000, SQL Server database, VB 6, Visual Basic 6
View Answer
| July 6, 2012 6:47 AM
SQL Server 2000, SQL Server database, VB 6, Visual Basic 6
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
Remove SQL Injection script
Take a look at this similar question/answer: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sql-query-5/”>SQL Query</a>
View Answer
| June 20, 2012 3:51 PM
SQL injection
Take a look at this similar question/answer: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sql-query-5/”>SQL Query</a>
View Answer
| June 20, 2012 3:51 PM
SQL injection
Connecting MS SQL server and database.
ODBC (Open Database Connectivity) • A standard interface for connecting from C++ to relational databases • It allows individual providers to implement and extend the standard with their own ODBC drivers Here are procedures or rather steps used in the industry in C++ coding for connecting to a database Read more at here http://www.techyv.com/questions/visual-basic-sql-connection-problem
View Answer
| June 19, 2012 4:26 AM
SQL Server 2005, Visual C++
ODBC (Open Database Connectivity) • A standard interface for connecting from C++ to relational databases • It allows individual providers to implement and extend the standard with their own ODBC drivers Here are procedures or rather steps used in the industry in C++ coding for connecting to a database Read more at here http://www.techyv.com/questions/visual-basic-sql-connection-problem
View Answer
| June 19, 2012 4:26 AM
SQL Server 2005, Visual C++
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
SQL server
Generate script for this sp as CREATE TO and run it on another database.
View Answer
| June 14, 2012 5:34 PM
Stored Procedures
Generate script for this sp as CREATE TO and run it on another database.
View Answer
| June 14, 2012 5:34 PM
Stored Procedures
SQL Query
<pre>select table_NAME FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME =’PID’ intersect select table_NAME FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME =’EID’ </pre>
View Answer
| June 4, 2012 5:36 PM
SQL Server, SQL Server tables
<pre>select table_NAME FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME =’PID’ intersect select table_NAME FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME =’EID’ </pre>
View Answer
| June 4, 2012 5:36 PM
SQL Server, SQL Server tables
To get password fron sql server?
You can get the loginname and the encrypted password from sys.syslogins. You can not pull out a logins password in plain text though. select name, password from sys.syslogins. If you need to copy a login then MS has a proc that you can use for that as well. Details at link below. http://support.microsoft.com/kb/246133
View Answer
| May 21, 2012 2:50 PM
SQL Server, SQL Server Passwords
You can get the loginname and the encrypted password from sys.syslogins. You can not pull out a logins password in plain text though. select name, password from sys.syslogins. If you need to copy a login then MS has a proc that you can use for that as well. Details at link below. http://support.microsoft.com/kb/246133
View Answer
| May 21, 2012 2:50 PM
SQL Server, SQL Server Passwords
Compression in SQL Server 2008
BACKUP DATABASE [dbname] TO DISK = N’drive:pathfilename.bak’ WITH NOFORMAT, NOINIT, NAME = N’Name Database Backup’, SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10 GO Or use the GUI and just specify to use compression on the options tab.
View Answer
| May 18, 2012 10:50 PM
compressed backup, SQL Server 2008
BACKUP DATABASE [dbname] TO DISK = N’drive:pathfilename.bak’ WITH NOFORMAT, NOINIT, NAME = N’Name Database Backup’, SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10 GO Or use the GUI and just specify to use compression on the options tab.
View Answer
| May 18, 2012 10:50 PM
compressed backup, SQL Server 2008
Sql Server 2008R2 on Windows Sever 2008 R2
I think that you will find the solution to your problem in the links below (it explains that you must install SQL 2008 R2 SP1 first) http://wadingthrough.com/2009/09/14/problem-installing-sql-server-2008-on-windows-2008-r2/ http://support.microsoft.com/kb/955725
View Answer
| May 16, 2012 1:46 PM
SQL Server 2008, SQL Server 2008 R2, Windows Server 2008 R2
I think that you will find the solution to your problem in the links below (it explains that you must install SQL 2008 R2 SP1 first) http://wadingthrough.com/2009/09/14/problem-installing-sql-server-2008-on-windows-2008-r2/ http://support.microsoft.com/kb/955725
View Answer
| May 16, 2012 1:46 PM
SQL Server 2008, SQL Server 2008 R2, Windows Server 2008 R2
conversion of SQL Server 2008 stored procedure to Oracle 10g
There are lots of differences. For example there is no VARCHAR data type in Oracle, you’ll have to use VARCHAR2 instead. Using user defined functions is basically the same. The big difference is that SQL Server using T/SQL and Oracle uses PL/SQL as the programming language. All the code within the procedure will need to [...]
View Answer
| May 15, 2012 3:20 AM
Oracle 10g, SQL Server 2008, SQL stored procedures
There are lots of differences. For example there is no VARCHAR data type in Oracle, you’ll have to use VARCHAR2 instead. Using user defined functions is basically the same. The big difference is that SQL Server using T/SQL and Oracle uses PL/SQL as the programming language. All the code within the procedure will need to [...]
View Answer
| May 15, 2012 3:20 AM
Oracle 10g, SQL Server 2008, SQL stored procedures
Defrag SQL Database
Diskeeper would be a way to degrag the physical database files and then use DBCC REINDEX to rebuild the indexes. A search on Google for defrag SQL shows a couple of articles about this ================ If you are comparing it to the defragment tools such as the utility software used to defrag the hard disk [...]
View Answer
| May 2, 2012 5:01 PM
SQL Server, SQL Server 2000
Diskeeper would be a way to degrag the physical database files and then use DBCC REINDEX to rebuild the indexes. A search on Google for defrag SQL shows a couple of articles about this ================ If you are comparing it to the defragment tools such as the utility software used to defrag the hard disk [...]
View Answer
| May 2, 2012 5:01 PM
SQL Server, SQL Server 2000
Load balance of SQL database
SQL Server does not have a true way to scale out. The most you might be able to do is offload some read activity to a mirrored copy of the database, if you are using SQL Server 2012 and Always On, this read only copy is not available in any other version. . Or you [...]
View Answer
| May 2, 2012 4:45 PM
SQL Server 2005, SQL Server database
SQL Server does not have a true way to scale out. The most you might be able to do is offload some read activity to a mirrored copy of the database, if you are using SQL Server 2012 and Always On, this read only copy is not available in any other version. . Or you [...]
View Answer
| May 2, 2012 4:45 PM
SQL Server 2005, SQL Server database
How can we get shell when dbms is SQL2008 and we found an sql vuln in REFERER field, which revealed version,dbs,tables etc?Sqlmap didn’t work.
What REFERER field in the headers? That’s from a web server not the SQL Server. If the web server if returning something that it shouldn’t then the web developer needs to fix that. If you can’t enable xp_cmdshell within the SQL Server then you can’t get to the shell. That’s sort of the point.
View Answer
| April 26, 2012 7:15 PM
MSSQL 2008, SQL injection
What REFERER field in the headers? That’s from a web server not the SQL Server. If the web server if returning something that it shouldn’t then the web developer needs to fix that. If you can’t enable xp_cmdshell within the SQL Server then you can’t get to the shell. That’s sort of the point.
View Answer
| April 26, 2012 7:15 PM
MSSQL 2008, SQL injection
Free online practice exercises on SQL/Oracle
A Gentle Introduction to SQL http://sqlzoo.net/ SQLCourse – Interactive Online SQL Training for Beginners http://sqlcourse.com/ SQLCourse2 – Advanced Online SQL Training http://sqlcourse2.com/ SQL Exercises – Online SQL (DML) Training <a href=”http://www.sql-ex.ru/”>www.sql-ex.ru/</a> w3schools you want online free test check this: it is more usefull………… www.wiziq.com/tests/sql ///////////////////////////////////// www.sqlzoo.net //////////////////////////////////////
View Answer
| April 17, 2013 3:56 AM
MySQL, Oracle, SQL Server
A Gentle Introduction to SQL http://sqlzoo.net/ SQLCourse – Interactive Online SQL Training for Beginners http://sqlcourse.com/ SQLCourse2 – Advanced Online SQL Training http://sqlcourse2.com/ SQL Exercises – Online SQL (DML) Training <a href=”http://www.sql-ex.ru/”>www.sql-ex.ru/</a> w3schools you want online free test check this: it is more usefull………… www.wiziq.com/tests/sql ///////////////////////////////////// www.sqlzoo.net //////////////////////////////////////
View Answer
| April 17, 2013 3:56 AM
MySQL, Oracle, SQL Server
How to Upload Image into SQL Server 2005
Convert the image into bytes and store them in the table
View Answer
| April 11, 2012 3:10 PM
SQL Server 2005, VB.NET 2008
Convert the image into bytes and store them in the table
View Answer
| April 11, 2012 3:10 PM
SQL Server 2005, VB.NET 2008
How do I subtract 3 days from current date only when current day = 2, so that I retrieve the previous Fridays date?
Try this <pre>select date, DATEADD(dd,case when datename(dw, date) = ‘monday’ then -3 else -1 end, date) from table</pre> <a href=”http://www.sql-tutorial.ru/en/book_tsql_datetime_functions.html”>date/time functions</a>
View Answer
| April 10, 2012 2:07 PM
T-SQL, T-SQL 2008 R2
Try this <pre>select date, DATEADD(dd,case when datename(dw, date) = ‘monday’ then -3 else -1 end, date) from table</pre> <a href=”http://www.sql-tutorial.ru/en/book_tsql_datetime_functions.html”>date/time functions</a>
View Answer
| April 10, 2012 2:07 PM
T-SQL, T-SQL 2008 R2
unable to connect sql server 2000 on network
Are you trying to connect via Windows authentication? If so they you either need to have all the computers on a Windows domain or the account that you are logged into your computer with needs to have an account on the SQL Server with the same username and password.
View Answer
| April 7, 2012 4:45 AM
SQL Server 2000, SSMS
Are you trying to connect via Windows authentication? If so they you either need to have all the computers on a Windows domain or the account that you are logged into your computer with needs to have an account on the SQL Server with the same username and password.
View Answer
| April 7, 2012 4:45 AM
SQL Server 2000, SSMS
