473,387 Members | 1,516 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How add rows to table in Microsoft SQL 2008 Server

Hi!
Simple questio - how to add rows to table in Microsoft SQL 2008
Server.
I don't mean by executing query (INSERT INTO...), but by clicking on
table or something - not by writing query manual.
When I'm clicking RMB on table I can't see nothing like "open",
"add"... Insead of these I have "new table...", "design", etc.
Nov 14 '08 #1
9 12709
krzys wrote:
Hi!
Simple questio - how to add rows to table in Microsoft SQL 2008
Server.
I don't mean by executing query (INSERT INTO...), but by clicking on
table or something - not by writing query manual.
When I'm clicking RMB on table I can't see nothing like "open",
"add"... Insead of these I have "new table...", "design", etc.
SQL is not Access. You probably want to create an Access file with
linked tables pointing to SQL, or the equivalent with Access replaced
by (insert favorite front-end tool here).
Nov 14 '08 #2
On Nov 14, 4:31 pm, Ed Murphy <emurph...@socal.rr.comwrote:
>
SQL is not Access. You probably want to create an Access file with
linked tables pointing to SQL, or the equivalent with Access replaced
by (insert favorite front-end tool here).
What, you're not going to recommend he look at Dataphor! :)

www.beyondsql.blogspot.com
Nov 14 '08 #3
As far as I can remember in SQL Server 2005 by clicking RMB on table
there was option "open"...
Nov 15 '08 #4
On Fri, 14 Nov 2008 23:03:14 -0800 (PST), krzys wrote:
>As far as I can remember in SQL Server 2005 by clicking RMB on table
there was option "open"...
Hi krzys,

That has been replaced by "Edit top 200 rows", and as far as I know can
still be used to enter new rows.

However, I suggest that you don't use this option, nor the "edit" option
in SQL 2005. There are various known issues with both methods of
entering data.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Nov 15 '08 #5
On 15 Lis, 22:53, Hugo Kornelis <h...@perFact.REMOVETHIS.info.INVALID>
wrote:
On Fri, 14 Nov 2008 23:03:14 -0800 (PST), krzys wrote:
As far as I can remember in SQL Server 2005 by clicking RMB on table
there was option "open"...

Hi krzys,

That has been replaced by "Edit top 200 rows", and as far as I know can
still be used to enter new rows.

However, I suggest that you don't use this option, nor the "edit" option
in SQL 2005. There are various known issues with both methods of
entering data.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog:http://sqlblog.com/blogs/hugo_kornelis
Great answer - thansk a lot!
Nov 16 '08 #6
steve wrote:
On Nov 14, 4:31 pm, Ed Murphy <emurph...@socal.rr.comwrote:
>SQL is not Access. You probably want to create an Access file with
linked tables pointing to SQL, or the equivalent with Access replaced
by (insert favorite front-end tool here).

What, you're not going to recommend he look at Dataphor! :)

www.beyondsql.blogspot.com
No, at least not yet. Dataphor may be a useful platform for new
project development, but (as I've said many times before) for existing
projects - of which there are many - the cost of switchover would
usually hugely outweigh any potential benefits.

I'll take this opportunity to quote something I wrote back on
October 22 - you haven't replied yet, would you like to do so now?
As previously discussed, I agree that table-type variables would be
useful in other situations, though I still think you're shooting
yourself in the foot by constantly pointing to an instance (Dataphor)
that would incur a huge switchover cost for existing projects. SQL
Server 2008 has table-valued parameters, albeit limited to read-only
input parameters; within that limit, do you approve of them?
Nov 17 '08 #7
On Nov 16, 8:26*pm, Ed Murphy <emurph...@socal.rr.comwrote:
[snipe]

I'll take this opportunity to quote something I wrote back on
October 22 - you haven't replied yet, would you like to do so now?
As previously discussed, I agree that table-type variables would be
useful in other situations, though I still think you're shooting
yourself in the foot by constantly pointing to an instance (Dataphor)
that would incur a huge switchover cost for existing projects. *SQL
Server 2008 has table-valued parameters, albeit limited to read-only
input parameters; within that limit, do you approve of them?
Hello Ed,

To be charitable I suppose some will make use of it. I don' see that
it can do any harm except psychologically. It seems to me that I can
only pass the Orders table in the Northwind db if it's something else
(I assume their using the temp db). Then obviously I can't pass Orders
itself:) It reminds of the riddle, when is a door not a door? When
it's ajar:) Most users probably can't appreciate where I coming from
because they do not know what it 'really' means to pass a table as a
parameter (as I've shown in many articles). Perhaps I'll further
dissect the craziness of the idea of a TVF in its own special article.
In the meantime I suspect there are much bigger fish to fry :)

best,
steve
www.beyondsql.blogspot.com
Nov 17 '08 #8
steve wrote:
To be charitable I suppose some will make use of it. I don' see that
it can do any harm except psychologically. It seems to me that I can
only pass the Orders table in the Northwind db if it's something else
(I assume their using the temp db). Then obviously I can't pass Orders
itself:)
I agree that SQL 2008 doesn't cover all of your suggestions - I was
just pointing out that it seems to cover at least some of them.
Most users probably can't appreciate where I coming from
because they do not know what it 'really' means to pass a table as a
parameter (as I've shown in many articles).
That's probably true in many cases, but here is (I suspect) why they
aren't learning from you in particular:

1) Dataphor is a niche product. Existing projects, of which there are
many, would suffer major switchover costs. Even new projects would
require the developer to spend some time learning Dataphor's
interface for app development. There are cases where these costs
would be worth it, but by failing to address these limits, you come
off sounding like an impractical ivory-tower theorist and/or fringe
religious cultist.

This would be greatly mitigated if you translated your ideas into
hypothetical extensions of SQL, and lobbied to have such extensions
added to the industry standard. I've even given examples of this
in the past, but you didn't seem to see any significant value in
it; even SQL 2008's actual (albeit incomplete) progress on this
front was met with no more excitement than "meh, might help a bit".

2) Grammar can't just be swept under the rug with "my style is more
important". First, technical subjects require clear communication,
full stop. Second, your style is far from unique; even in artistic
fields, only a few of us can be a cummings or Silverstein.
Nov 18 '08 #9
On Nov 18, 1:39*pm, Ed Murphy <emurph...@socal.rr.comwrote:
>...here is (I suspect) why they aren't learning from you in particular:
1) Dataphor is a niche product.
I was hoping it would be seen as a Nietzschean type product:) Note
that many
products are nichey along the way to becoming widely used. MySql was
once a niche product (a label used pejoratively by MS and other
vendors). Today it's advocates would argue it's quite the mainscream.
Existing projects, of which there are many, would suffer major switchover
Nov 20 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Bill | last post by:
I have a table I'd like to copy so I can edit it and play around with the data. How do I create copy of a table in SQl Server? Thanks, Bill
7
by: iqbal | last post by:
Hi all, We have an application through which we are bulk inserting rows into a view. The definition of the view is such that it selects columns from a table on a remote server. I have added the...
1
by: Rajesh Tiwari | last post by:
hi group plz tell how to generate XSD of a table in sql server. thanks -- Rajesh Tiwari S/W Engineer Digital Offshore Solutions(www.dospl.com) Gurgaon,HR
5
by: dadofgage | last post by:
I have an application that was written in access and it is linked to data on a microsoft SQL server. I have no problems getting the data out of the database but if I want to update the data, I...
1
by: JIM.H. | last post by:
Hello, Here is part of my code to retrieve some data from FoxPro and populate DataGrid. It works fine. What is the best and easiest way to import data from Dataset to a table in SQL Server. '...
1
by: cherychoclatecandy | last post by:
How to change a datetime column to date format only using microsoft sql server management studio? eg 5/2/2008 8:49:48 AM to date format only (5/2/2008)
8
by: Siv | last post by:
Hi, What is the best way to get the field names of a table in SQL server where you only have Windows Authentication access to a database. Previously I have used the SQLDMO object to get this, but...
1
by: TG | last post by:
Hi! I have an application in which I have some checkboxes and depending which ones are checked those columns will show in the datagridview from sql server or no. After that I have 2 buttons:...
1
by: Ken Fine | last post by:
I have set up Microsoft Search Server 2008 Express. I want to know how I can query against it and return results in a form that can be bound to ASP.NET controls like ListViews. If there's simply...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.