I am programming an Access 2007 (accdb, not adp) frontend at connect to a SQL Server 2005 backend. How can I call a scalar user defined function from my vba code?
Hi there,
I am wanting to sync data between a sql 2008 db and some sql ce.
Its only a one way requirement so when data is updated in the main sql server the updates are sent to the ce databases.
Is this easy to setup with the sync framework. I was able to find a demo however I couldnt compile it
Hi,
I have a Database (Sql-server) with table named 'ProcessData' and columns named 'Process_Name' (Data Type: nvarchar(50)), 'Start_At' (DataType: DateTime) and 'End_At' (Data Type: DateTime).
I need to konw for each 'Time-Interval' (let's say 1 second) how many processes (Process_Name = PN) was open (after or equal to the 'Start_at' column and before or equal to the 'End_At' column) during this time (It can be a few rows with the same data).
Does anyone know how to make this query?
Many thanks,
Hi everyone,
I have a stored proc I'd like to debug in the SQL Server 2008 management studio. I see a number of tutorials about doing this, but the ones I've seen don't have any input parameters going into the SP. My SP has several, and an output parameter as well.
Could someone show me how to do debug a stored procedure with parameters in SQL 2008? Thanks very much.
When you have an application and send a select command, the sql server gathers all the data and sends them back to your application and fills your datagrid (for example)
If you performed the same select command in sql management studio, immediately as the query starts running and finding data the results panel would start filling with the data found.
How can I do that for my winforms application?
Is there a technique or a standard method of doing something like this?
Links to good examples would be an immense help.
thanks
I've got a database with collation Danish_Norwegian_CS_AS and lots of varchar columns. I'd like to convert all this data to unicode, but haven't found a way to convert this data yet. If I've understood correctly, the encoding used is UCS-2 little endian.
For example I've got a column containing 'PÃ¥l-Trygve' which is easily converted with C# to 'Pål-Trygve' using Encoding.Default.GetString(Encoding.UTF8.GetBytes("PÃ¥l-Trygve"));
Is there a way to do this conversion in the Microsoft SQL Server client?
How do you make the server go offline or restart it in turbogears ? I typed "paster serve development.ini" for it to go online. After it goes online, the cursor is there in dos window but nothing I type is displayed.
Hello,
Does anybody know why when connecting two dial-up modems the maximum protocol you can use to stablish the communication is V.34 -33.6K?
I've read that you can connect with the server modems of the ISP using V.92 or V.90 and I would like to know if there is any explanation to this.
Thanks in advance.
Hi folks,
I'm trying to run an app from a remote X session (Ubuntu, 9.04) on a handheld device powered by Windows Mobile. I want to do this by running an X-server of some description on the mobile device and using SSH/PocketPuTTY or similar for a tunnel, as you'd do it on a standard PC/Mac.
Can anyone pls. point me in the direction of some X servers for Windows Mobile, if they exist? Having a hard time finding them.
Cheers
Hi Team,
I am using SQL Server 2005. I have a requirement to list out all the tables (and the column) whcih has the value 'xyzeee'.
Is there a query to achieve this?
Thanks
Lijo
I want to transfer data from SQL Server table to Excel sheet using 3 tier architecture in asp.net 3.5. After user has made required changes in the Excel sheet I want Excel sheet to get uploaded and update data in the table with validation for proper data.
Hi,
I'm querying an SQL Server database using SQLAlchemy and need to cast a column to varbinary(max). The thing I am struggling with is the "max" part. I can get the cast to work for any actual number (say varbinary(20)), but I cannot find how to get it to work for the "max" size of the varbinary column.
Any pointers? Links? Solutions?
Regards,
Mark
I have used MS SQL Server Management Studio for most of my database modeling to this point in my career. I am a database developer (not a DBA), but interested in the benefits with using Sparx systems Enterprise Architect for data modeling. I do not have the need to generate scripts for different databases, other than that what does using Sparx EA buy me that SQL Management Studio does not?
I'm playing around trying to write a client for a site which provides data as an HTTP stream (aka HTTP server push). However, urllib2.urlopen() grabs the stream in its current state and then closes the connection. I tried skipping urllib2 and using httplib directly, but this seems to have the same behaviour.
Is there a way to get the stream to stay open, so it can be checked each program loop for new contents, rather than waiting for the whole thing to be redownloaded every few seconds, introducing lag?
I have an application on my server that is called leaf.exe, that haves two arguments needed to run, they are: inputfile and outputfile, that will be like this example:
pnote.exe input.pnt output.txt
The executable is at exec/, inputfile is at upload/ and outputfile is on compiled/. But I need that a PHP could run the application like that, then I want to know:
How could I do this?
How could I echo the output of the program?
Is there a method of accessing an Exchange server that does not have IMAP or POP3 enabled without Outlook? It does not appear that Outlook Express supports Exchange (only IMAP and POP3).
Hi,
I have a tabel in an Sql Server 2005 database. I have the following column
IndPL INT DEFAULT 0 NULL
I want to change the column to be of the type NVARCHAR but I receive a constraint violation due to the fact that the column has a default value constraint attached to it.
I need to find out how to remove a default value constraint from a table column or how to change the column type without impeding the constraint.
I want to write a query like this:
For a table that has these columns:
ColA ColB ColC, ColD
select first(ColA, ColB, ColC, ColD)
distinct(ColB, ColC)
from table
order by ColD
The query is supposed to order the table by ColD, then group the results by the combination of ColB and ColC (they may have different data types) and returns the first rows (with all the columns of the table) in the groups.
How is it possible in MS SQL Server 2005?
Hi,
Is there any configuration for JBoss Application Server's Log configuration
where in the logs get deleted automatically if the log size exceeds some threshold or if it is older than a certain date ?
My ASP.NET MVC web app has a weird issue. In VS debugging mode it works as expected, but when I publish it to dedicated web server (windows 2003, IIS6) a sql query returns previous data even though underlying data was already updated through the same connection. It looks like as if a query returns cached data. What might be the problem?
hi, i m not able to modify table in SQL server. i m new to databases.
use work
go
alter table employee
modify id varchar(20)
error message is-
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'modify'
here is an screenshot
thanks
I want to backup my Outlook email into Gmail.
I have setup my Gmail account in Outlook using IMAP like is suggested here - http://www.keenerliving.com/importing-outlook-into-gmail - and I can successfully upload Outlook emails into Gmail, but Exchange mail doesn't copy across the sender and receivers. All Exchange emails in Gmail are listed as sent by (unknown sender).
How do you upload Exchange emails into Gmail from Outlook while maintaining the correct From and To email addresses?