I maintain a website that uses AbsoluteFP, a forms processor, for processing all forms. I am working on a reporting module and need to pull data out of their results table:
CREATE TABLE [dbo].[...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22795771.html
I need to copy a set of db's over to a second sql server instance and NOT have any of the security lost - if I was going to a instance on another server i would bring the system databases with and ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2311...
I would like to pass in the 'In' portion of a query to a stored procedure, but I'm having problems.
select * from table where phone IN ('555-5555', '666-6666');
that query correctly returns 2...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2314...
Hi experts, I need to info about migrating some sqlserver dbs to sqlserver 2005. We have a prd db a web db and a distribution db which need to be upgraded from sqlserver 2000 to sqlserver 2005. The...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23164499.html
HI,
I wnat to know if there is any way, where i will be able to export all the table structure +data in a text file so that i can execute to some other mysql server .
Reason is : I developed a...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23181...
IN MS Access I have a query to get time
AS
SELECT Now()-[intake_dt] AS [Time] FROM Table
How do I do that in SQLServer 2005
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2322...
I have a stored procedure
CREATE PROCEDURE rptServicePlanUpdateNotification
AS
DECLARE @WHERECLAUSE NVARCHAR(MAX)
SET @WHERECLAUSE = 'WHERE DATEDIFF(dd,INTAKE_DT,GETDATE()) > 240
AND ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23223231.html
I have a column named test and the datatye of the column is VARCHAR
The values in this column are datevalues for eg. 1/1/2005
In my select query if I say
SELECT * FROM Table Where test ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2323...
i setup sqlserver 2005 in a host(IP:222.255.2.252, Port:3999). i want config to clients can connect to it. Please help me. Thanks very much
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2323...
I have a query which is
SELECT CONVERT(VARCHAR,GETDATE(),100)
The output of this query is Mar 24 2008 3:37PM
How do I get the value Mar'08 by modifying this query.
Please help
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2326...
