sql query of datediff between two columns
i am having one table in sql 2000 that is called (personal), in that table i am having two columns name date of birth(dob) and date of enrollment(doe). i want to write a query to get the actual difference between two date i.e like 10 years 03 months 22 days. Can somebody help me out [...]
Answer Question
| October 12, 2012 5:01 PM
SQL 2000
i am having one table in sql 2000 that is called (personal), in that table i am having two columns name date of birth(dob) and date of enrollment(doe). i want to write a query to get the actual difference between two date i.e like 10 years 03 months 22 days. Can somebody help me out [...]
Answer Question
| October 12, 2012 5:01 PM
SQL 2000
SQL SERVER
The SQL Server mobile edition is supported on?
Answer Question
| October 10, 2012 8:40 AM
SQL, SQL 2005 Database, SQL 2005 Database design
The SQL Server mobile edition is supported on?
Answer Question
| October 10, 2012 8:40 AM
SQL, SQL 2005 Database, SQL 2005 Database design
Database
How to create a database of prison management system using SQL?
Answer Question
| October 9, 2012 4:33 PM
SQL, SQL Database
How to create a database of prison management system using SQL?
Answer Question
| October 9, 2012 4:33 PM
SQL, SQL Database
Sql Query
I have save data with special character (Enter Mark) in DB. But when I query the table and copy & paste result in excel then (Enter Mark) character does not come. I have refreshed the DB server due to some technical problem. Before reset it was working properly. But not now. plz help.
Answer Question
| October 3, 2012 1:37 PM
SQL Server
I have save data with special character (Enter Mark) in DB. But when I query the table and copy & paste result in excel then (Enter Mark) character does not come. I have refreshed the DB server due to some technical problem. Before reset it was working properly. But not now. plz help.
Answer Question
| October 3, 2012 1:37 PM
SQL Server
CR 11 connection to sql 6.5
I need too connect CR 11.5 to SQL 6.5. Which connection method do I use?
Answer Question
| September 25, 2012 6:17 PM
SQL 6.5
I need too connect CR 11.5 to SQL 6.5. Which connection method do I use?
Answer Question
| September 25, 2012 6:17 PM
SQL 6.5
Trigger
What is the use of the trigger?
Answer Question
| September 21, 2012 9:02 AM
SQL Trigger, Triggers
What is the use of the trigger?
Answer Question
| September 21, 2012 9:02 AM
SQL Trigger, Triggers
I am getting following error for SQL server 2005/2008
Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL [...]
Answer Question
| September 12, 2012 6:35 PM
SQL Server 2005, SQL Server 2008
Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL [...]
Answer Question
| September 12, 2012 6:35 PM
SQL Server 2005, SQL Server 2008
How to create an XML File from typed XML data stored in Multiple Rows and is referring to same XSD
I want to create a single XML file from typed XML data stored in Multiple Rows and it is referring to a single XSD I want to use this XSD to find the position of the respective elements present in various rows. I am using SQL Server 2008 and I am using an XML Datatype [...]
Answer Question
| September 10, 2012 5:36 PM
SQL Server 2008, XML
I want to create a single XML file from typed XML data stored in Multiple Rows and it is referring to a single XSD I want to use this XSD to find the position of the respective elements present in various rows. I am using SQL Server 2008 and I am using an XML Datatype [...]
Answer Question
| September 10, 2012 5:36 PM
SQL Server 2008, XML
machine name/sqlexpress2008r2 is giving error
Dear friends, I have just installed sql server. I created an instance name, but was not able to connect to the server. However, if I put the /SQLEXPRESS2008R2 before the machine name I am able to connect to the DB. However, when using the same connection string in the VB.Net, its giving some error. Can [...]
Answer Question
| September 7, 2012 3:31 AM
SQL Server 2008
Dear friends, I have just installed sql server. I created an instance name, but was not able to connect to the server. However, if I put the /SQLEXPRESS2008R2 before the machine name I am able to connect to the DB. However, when using the same connection string in the VB.Net, its giving some error. Can [...]
Answer Question
| September 7, 2012 3:31 AM
SQL Server 2008
Security Awareness training for FTI
I am responsible for the Security Awareness program and I’m trying to put together my IRS Security Awareness training. I work for a government agency and we have to have annual training for security FTI (federal tax information) data, which is required by the IRS. I am looking for a video that we can distribute [...]
Answer Question
| August 30, 2012 3:25 PM
FTI, IRS, security awareness training
I am responsible for the Security Awareness program and I’m trying to put together my IRS Security Awareness training. I work for a government agency and we have to have annual training for security FTI (federal tax information) data, which is required by the IRS. I am looking for a video that we can distribute [...]
Answer Question
| August 30, 2012 3:25 PM
FTI, IRS, security awareness training
SQL table connectivity via odc
Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.
Answer Question
| August 30, 2012 2:18 PM
Microsoft Excel, Microsoft odc, SQL Database
Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.
Answer Question
| August 30, 2012 2:18 PM
Microsoft Excel, Microsoft odc, SQL Database
Sql Search
Hi, I have a Search box on my site at top. Where visitor can enter any keyword. I have Full Text Search enabled on my DB and index the Columns. I have one Columns SalesTitle in one of Table Catalog.Product, which contains almost our required keyword, like ProductNumber, Description, BrandName, Product Size, etc… I am [...]
Answer Question
| August 23, 2012 8:56 AM
SQL Full Text Search, SQL Server
Hi, I have a Search box on my site at top. Where visitor can enter any keyword. I have Full Text Search enabled on my DB and index the Columns. I have one Columns SalesTitle in one of Table Catalog.Product, which contains almost our required keyword, like ProductNumber, Description, BrandName, Product Size, etc… I am [...]
Answer Question
| August 23, 2012 8:56 AM
SQL Full Text Search, SQL Server
how do I cause a field to be null, using DFU?
how do I cause a field to be null, using DFU to update/insert a record?
Answer Question
| August 21, 2012 6:43 PM
DFU, Nulls
how do I cause a field to be null, using DFU to update/insert a record?
Answer Question
| August 21, 2012 6:43 PM
DFU, Nulls
Career change RPG/ILE to ASP.net
After almost 30 years of RPG (from the old RPG I days) I am making the change to .Net. I felt that ASP.net would offer more of a challenge and reflect more of today’s business needs. I am still working for the same company so no real risk in the move. My question is what [...]
Answer Question
| August 21, 2012 5:19 PM
AS/400, SQL Server 2008, Visual Studio 2008
After almost 30 years of RPG (from the old RPG I days) I am making the change to .Net. I felt that ASP.net would offer more of a challenge and reflect more of today’s business needs. I am still working for the same company so no real risk in the move. My question is what [...]
Answer Question
| August 21, 2012 5:19 PM
AS/400, SQL Server 2008, Visual Studio 2008
Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] on production server
Hello, I am getting the below error on customer production error, Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC’s record sets. if I try to run that queries on SSMS directly I am not getting that error. How to identify exactly which query leads this [...]
Answer Question
| August 20, 2012 8:38 AM
Microsoft SQL Server, SSMS
Hello, I am getting the below error on customer production error, Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC’s record sets. if I try to run that queries on SSMS directly I am not getting that error. How to identify exactly which query leads this [...]
Answer Question
| August 20, 2012 8:38 AM
Microsoft SQL Server, SSMS
Trigger Perormance Issues when Journalling Started
I have an external trigger program (RPGIV) that is added to about 50 files. Its task is to store record images upon insert, delete, update in any of the 50 files. It stores the images in another file (the monitor file) which also contains an identity field (generated always as identity). All files, including the [...]
Answer Question
| August 11, 2012 12:57 PM
Journal, performance, TRIGGER
I have an external trigger program (RPGIV) that is added to about 50 files. Its task is to store record images upon insert, delete, update in any of the 50 files. It stores the images in another file (the monitor file) which also contains an identity field (generated always as identity). All files, including the [...]
Answer Question
| August 11, 2012 12:57 PM
Journal, performance, TRIGGER
2003 Sever Domain Issue
Currently my customers running a Windows 2003 server with 2005 SQL and a Active Server.We just put a 20 meg Fiber service into the Office. The issue we are having is it will still take 1-3 mins to load a web page. The DHCP on the router has been placed inactive for a block of [...]
Answer Question
| July 31, 2012 2:42 PM
Server 2003 in network with domain, SQL 2005 Database design, SQL 2005 Service pack 3
Currently my customers running a Windows 2003 server with 2005 SQL and a Active Server.We just put a 20 meg Fiber service into the Office. The issue we are having is it will still take 1-3 mins to load a web page. The DHCP on the router has been placed inactive for a block of [...]
Answer Question
| July 31, 2012 2:42 PM
Server 2003 in network with domain, SQL 2005 Database design, SQL 2005 Service pack 3
Internet Connection Battle in windows 2003 Server.
My customer currently is using a Windows 2003 server with 2005 SQL server, and an active directory in place. The server is set to do DHCP and DNS on the LAN. We have a Cbeyond Cisco Fiber router recently installed. All workstations are set to Static IP address same Sub net with Default Gateway being [...]
Answer Question
| July 27, 2012 10:00 PM
Server 2003, SQL 2005 admin, SQL 2005 Database, SQL 2005 Database design
My customer currently is using a Windows 2003 server with 2005 SQL server, and an active directory in place. The server is set to do DHCP and DNS on the LAN. We have a Cbeyond Cisco Fiber router recently installed. All workstations are set to Static IP address same Sub net with Default Gateway being [...]
Answer Question
| July 27, 2012 10:00 PM
Server 2003, SQL 2005 admin, SQL 2005 Database, SQL 2005 Database design
Restore SharePoint 2003 database/s on SQL Server 2005
I am not sure if this should be addressed by the SQL Server group or SharePoint Server group. Since I am more familiar with SQL Server than SharePoint I started here. We have SharePoint Server 2003 installed on Windows 2003 server running SQL Server 2005. We have been backing up daily, two of the SharePoint [...]
Answer Question
| July 24, 2012 3:52 PM
Restore Database, SharePoint 2003, SQL 2005
I am not sure if this should be addressed by the SQL Server group or SharePoint Server group. Since I am more familiar with SQL Server than SharePoint I started here. We have SharePoint Server 2003 installed on Windows 2003 server running SQL Server 2005. We have been backing up daily, two of the SharePoint [...]
Answer Question
| July 24, 2012 3:52 PM
Restore Database, SharePoint 2003, SQL 2005
Restore SQL Server 2008 database backup error specified cast is not valid
Received a SQL Serer 2008 database backup newdatabase.bak from a site in UK and attempted to restore it onto my server in USA. Receive error . I assume this is a Server Collation difference issue. Can anyone help me overcome this so that I may be able to restore this backup on my SQL Server [...]
Answer Question
| July 20, 2012 5:37 PM
Server configuration, SQL Server 2008 administration
Received a SQL Serer 2008 database backup newdatabase.bak from a site in UK and attempted to restore it onto my server in USA. Receive error . I assume this is a Server Collation difference issue. Can anyone help me overcome this so that I may be able to restore this backup on my SQL Server [...]
Answer Question
| July 20, 2012 5:37 PM
Server configuration, SQL Server 2008 administration
