I want to setup a table that can:
Save the data on the user's machine
Reference & present the data in the GUI
Capable of adding rows dynamically during runtime
What's the best way to go about this?
DataGridView or TableLayoutPanel or...? I'm having trouble with SQL server CE, as I was going to connect it with the DataGridView, but I'm very new to this kind of work, and wondered if it was even necessary to use SQL.
Is there a way to specify, for example 4 distinct values for a varchar column in MS SQL Server 2008?
For example, I need a column called Frequency (varchar) that only accepts 'Daily', 'Weekly', 'Monthly', 'Yearly' as possible values
Is this possible to set within the SQL Server Management Studio when creating the table?
Hi, I need to profile a large SQL query (in a particular database, not the whole server), and I cant figure out how to setup the profiler. I tried reading MSDN SQL web site, but it has not helped.
I am stuck at the Trace Properties "Events Selection" window. I need help as to which items to select in "Events Selection" window.
Thanks
Hi everyone,
I have a database in SQL Server 2008, and there are a lot of machines making queries against it. I know there is a SQL Server profiler, but I don't know very well how to use it.
Is there any way to know what are the most common queries executed in the database? Through the profiler or not, it doesn't matter.
Thank you very much in advance!
The current solution i implemented is awful!
I use a for... loop for inserting records from an ADO.NET data-table into an SQL table.
I would like to insert at once the data-table into the SQL table, without iterating...
Is that possible, or am i asking too much?
What are the option in terms of applications that help build SQL statements against a MSSQL database?
We have some users that need to build sql statements, perferably through drag and dropping or linking up tables etc.., against a MSSQL databse who don't have any experience in this area.
Any Ideas?
It doesn't seem like SQL Management Studio Express 2005 considers Internet Options proxy settings defined for the LAN when trying to connect to SQL Server 2005.
Is there a way to make it use the proxy settings?
I always considered database as a storage .
but never thought it can be used for querying across tables etc.
Which is a good book for sql for a developer. not just the syntax.
How to write a query in different ways
How internally queries are executed.etc
especially related to microsoft sql server
Hi,
I've got some excel files, that were exported from tables in Access, and I want to import them into sql express 2005.
I need a script that will convert nvarchar(255) columns to varchar(255) and preserve links, when importing the data into sql express.
Thanks
Hi All,
I have a small excel program.
I would like to be able to use this program to update a SQL table.
What would be the function to say update line 2 in SQL table Test in Database ABC
Thanks
I want to do sql certification but specific like mysql , postgresql , mSsql .
Is there any simple sql certification
If not which one would be good to do for company level.
which covers all topics
I am thinking of going in data warehousing, if that helps.
Hello,
I've a self join table when I delete or update it's id I want to delete or update all the direct and indirect affected records
SQL server does not allow this type of cycle cascading I've decided to use triggers but this triggers will file recursively and they will be terminated at 34 level and I don't know the depth of records and event I disable the trigger and re enable it after completing the process how can I construct a SQL statement that achieve this logic?
I have a project that involves recording data from a device directly into a sql table.
I do very little processing in code before writing to sql server (2008 express by the way)
typically i use the sqlhelper class's ExecuteNoneQuery method and pass in a stored proc name and list of parameters that the SP expects.
This is very convenient, but i need a much faster way of doing this.
Thanks.
Is there a refactoring tool available for SQL (TSQL in particular). Is there any tool that can do automatic simplification of SQL?
I have a set of views where only the top two are used, and I'd like to refactor this into only two views, hence 10+ queries into two queries.
i have two pc's on my lan (one with "iis and a public ip) and another with(sql server and lan ip). How i can access to the sql server pc trough iis pc From a pc on the internet?
Hi All...
Would like to know which is the best way to move data in bulk from oracle to SQL database programmatically in VB.NET application.This application is suppose to run continuously and moves data from Oracle to SQL whenever data comes.
I have found OPENDATASOURCE but does not know the exact syntax.
Can someone help me out.
Thanks in advance,
for a table valued function in sql why cant we write sql statements inside begin and end tags like-
create function dbo.emptable()
returns Table
as
BEGIN --it throws an error
return (select id, name, salary from employee)
END
go
while in scalar valued function we can use these tags like
create function dbo.countemp()
returns int
as
begin
return (select count(*) from employee)
end
go
is there any specific rule where we should use BEGIN & END tags
hi,
i have a blog application were Post belongsTo Category and Category hasMany Post
Post can have a Category or not - in latter case NULL value is present in Post.category_id field.
Now i would like to have following category count with single SQL query
category|post_count
--------------
PHP | 2
JavaScript | 4
SomeOtherCat | 1
NULL | 3
The clue here is that i also want to count posts without category (NULL row above). Is it posibble with one SQL query?
Hello, sorry for answer but how to enable TCP in SQL server 2005 express edition? I used configuration manager, find network configuration/protocols and there enabled TCP, after that I have restarted sql server service and tried installation of problematic software again (software which told me that TCP is not enabled) but I have the same problem :-(
Do some out there use stored procedures with linq to sql and why? should we use them ? their support is there in linq to sql . I am asking because i use to use it before my recent application