How would I make a Visual Basic application talk to a web server? Someone will press something on the site and I want the application to display the information that the web site passes along to it.
Hi all,
I would like to know how to measure/know that one's stored procedure is optimum in performance. That stored procedure can be inserting/deleting/updating or manipulating data in that procedure. Please describe the way/approach how to know performance in SQL Server.
Thanks in advance!
I need to write an user menu for an embedded device (mips linux). The menu has to be accessible from network (web page - AJAX?) and it has to be able to read/write hardware settings. What would be the easiest way to implement such an app/server? Where do I start?
PS: c/c++ preferred.
PS 2: I have limited resources
How to insert rows in an Excel sheet into SQL Server 2005 or oracle ?
For example if I have 5000 rows in Excel sheet how can I insert these rows into a table in any database
Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database or by any other means?
This is for SQL Server 2008 Express Edition.
I have an intranet server running on a Windows XP computer and the internet connection on it has been known to be pretty unreliable (surprise, surprise) so I was wondering if there was a way to use an AppleScript to poll it every hour or so to see if it is up and running and if it isn't, execute something, like send myself an email.
Thanks in advance!
Is it possible to write a plugin or a form for SQL Server Enterprise Manager version 8? I'm doing some simple queries all the time to admin the databases. So wondering if I could write something for it.
I am trying to insert NULL value in Sql Server if I have null value in corresponding C# String object like below :
String Residence = xmlDoc.Descendants("Appointment").Single().Element("StateOfResidence") == null ? null : xmlDoc.Descendants("Appointment").Elements("StateOfResidence").Single().Value;
I am using Entity framework for Database access. So if Residence is null, 'NULL' gets inserted into Database instead of NULL. How can insert NULL for null ?
I'm doing a little digging and looking for a explanation on how SQL server evaluates MIN(Varchar).
I found this remark in BOL: MIN finds the lowest value in the collating sequence defined in the underlying database
So if I have a table that has one row with the following values:
Data
AA
AB
AC
Doing a SELECT MIN(DATA) would return back AA. I just want to understand the why behind this and understand the BOL a little better.
Thanks!
I am using Castle ActiveRecord as my ORM. When I try to store unicode strings, I get question marks instead.
Saving unicode strings worked perfectly when I was using mysql, but when I recently switch to SQL Server it broke. How should I go about fixing this?
I have an application which intensively uses DB (SQL Server).
As it must have high performance I would like to know the fastest way to insert record into DB.Fastest from the standpoint of execution time.
What should I use ?
As I know the fastest way is to create stored procedure and to call it from code (ADO.NET).
Please let me know is there any better way or may be there are is some other practices to increase performance.
Hi,
I have several developers which connect to production and test servers where we have DBs with similar names and structures. In SSMS there are info related to the connection, but sometimes are not properly displayed and/or hidden.
I know that it is possible to customize the status bar of each connection in SSMS, but how do you ensure that your developer is connecting to the right server before he runs a query? Is there any way to handle this?
THANKS!
I have Table-valued parameters in SQL Server 2008 e.g.
CREATE TYPE UserType AS TABLE
(
UserID int,
UserName nvarchar(100),
UserPassword nvarchar(100)
)
Can i use this type somehow in my Sql CLR stored procedure? for example as input parameter ??
[SqlProcedure]
public static void SomeFunction(/* what type should be here ?? */)
{
}
Will be appreciate even for attention, let alone for any help !
I use SQL Server 2000.
Suppose I have two tables like the following:
Area
----------------------------------
ID| Name | HierarchyLevel
----------------------------------
1 | World | 1
2 | America| 2
3 | Europe | 2
4 | Africa | 2
5 | USA | 3
and
AreaHierarchy
------------------------
ID | ParentID | ChildID
------------------------
1 | 1 | 2
2 | 1 | 3
3 | 1 | 4
4 | 2 | 5
where
AreaHierarchy.ParentID and AreaHierarchy.ChildID are FKs of Area.ID
How can I find the nth parent of USA?
Is it possible without looping?
Probably not.
Hi. I'm new to SQL Server Compact edition. I'm using Compact edition 3.5. I tried renaming the table. But, I couldn't do that through the following query.
alter table tablename to newname
Plz, someone help me.........
Hi, im trying to connect to a remote sql express server using win. authentication.
I´m logued with a user with username Administrator, but when loggin, i got the next error:
Login failed for user guest ...
Why is not using the Administrator account?
Thanks in advance.
Hello everyone,
I am learning and using SQL Server 2008 new Merge statement, merge statement will compare/operate source table and destination table row by row ("operate" I mean operations performed for when matched or not-matched conditions). My question is whether the whole merge process will be one transaction or each row comparison/operation will be one transaction?
Appreciate if any document to prove it.
thanks in advance,
George
Hello everyone,
I am using SQL Server 2008 Enterprise. I met with issue which says line 9 of store procedure foo is meeting with dead lock issue. My question is how to find exactly the 9th line of the store procedure?
My confusion is because of coding format issue, how to locate 9th line correctly.
thanks in advance,
George
Hi,
Is there any place where I can find all possible object dependencies in Sql Server?
What I mean by "object dependency" is a list of object that one object can depend on. For example, TABLE can depend on SCHEMA, TYPE, TABLE, FUNCTION, etc.
How can i update bulk data in sql server 2005 by sending the data in XML form ?
i am able to insert bulk data into the table, but i am not getting idea to update the data.
I've stuck with syncing a Sql server 2008 having changes tracking enabled with a 2005 one that doesn't have this mechanism.
Would you please point me a right track, how can I handle this.
Thank you,
Hi.
I'd like to indicate to SQL Server 2005, in my BEGIN CATCH...END CATCH block that the error is "handled"... That is, clear the error.
Is that possible??
Thanks.
A.
I have saved a picture in sql server and now i can not to retrieve image and set it's in picturebox with linq.
why byte[] x become null?
private void dataGridViewUser_CellClick(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow row = dataGridViewUser.CurrentRow;
byte[] x=(byte[])row.Cells["Image"].Value;
MemoryStream ms1 = new MemoryStream(x);
picuser.Image = Bitmap.FromStream(ms1);
}