Search Results

Search found 27342 results on 1094 pages for 'sql denali'.

Page 262/1094 | < Previous Page | 258 259 260 261 262 263 264 265 266 267 268 269  | Next Page >

• Problem with user logins after db Restore

  - by JJgates

  I have two SQL 2005 instances that reside on different networks. I need to backup a database from instance A and restore it to a database in instance B on a weekly basis so that both databases hold the same data. After the restore, logins SIDS on database B are changed and therefore users can't log into database B and connection strings for the web application it supports are broken. Is there a work around for this? Thanks.

  Read the article

• How to give over right (table) permission in Sqlserver 2008?

  - by Ayyappan.Anbalagan

  I am using SQL Server 2008.i tried to modify the table.But it not allowing to over right. How to give overright(modify) permission in Sqlserver 2008?

  Read the article

• Erro while join table in SQL

  - by Color Shadow

  I have two tables that have relationship with UserName field. Based on UserName column, I want to get ID from CarReserve table. Here is my SQL statement: SELECT CarReserve.ID FROM CarReserve INNER JOIN aspnet_Users ON CarReserve.UserName = aspnet_Users.UserName WHERE UserName = @UserName Unfortunately, I am getting this warning: Ambiguous column name "UserName" Can anyone here tell me what is wrong with my statement?

  Read the article

• Side-by-side comparison of data by month in SQL

  - by ScottR

  I have table similar to the following: Year | Product | Value 2006 A 10 2006 B 20 2006 C 30 2007 A 40 2007 B 50 2007 C 60 I would like a query that would return the following comparison Product | 2006 Value | 2007 Value A 10 40 B 20 50 C 30 60 What are the options to do so? Can it be done without joins? I'm working with DB2, but answers in all SQL types would be helpful.

  Read the article

• Running a Query in SQL Plus

  - by WENzER

  Hi, I have to run a query in the loop in SQLPLUS. and the count of loop is coming from some other SQL query. So i have to declared a variable which will take the value of count. Now I want to use this variable in my query. How would i be able to do the same . Please suggest me Thanks in advance

  Read the article

• Looking for a good book on SQL

  - by hsatterwhite

  Was wondering if any one could recommend any and all books for learning more about SQL and DB concepts? I found this one while browsing SO, but was wondering if anyone had other or more up to date recommendations?

  Read the article

• Displaying SQL results using PHP

  - by mouthpiec

  Hi, I have an SQL query that returns an amount of tuples (about 50). Now I need to display the results, 15 tuples at a time, then I will have a "view more" button to view the next 15 results. Can you please help me how I can make this? The issue is that I cannot use the 'limits' because each time I run the query the results will be different, hence when pressing view more, I may get the same results of the same page. thanks

  Read the article

• SQL Alter: add multiple FKs?

  - by acidzombie24

  From here ALTER TABLE ORDERS ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID); How do i add several keys with SQL Server? is it something like the below? (I cant test ATM and unfortunately i have no way to test queries unless i run it through code) ALTER TABLE ORDERS ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID), ADD FOREIGN KEY (customer_sid2) REFERENCES CUSTOMER(SID2); or is it like ALTER TABLE ORDERS ADD FOREIGN KEY (customer_sid, customer_sid2) REFERENCES CUSTOMER(SID, SID2)

  Read the article

• Adding more attributes to linq to sql entity

  - by jess

  Hi, I want to add browsable attribute to some properties for entities generated by linq-to-sql.Is it a good idea? Since,these entities are auto-generated,and when I regenerate they(the attributes I have added) might be overwritten

  Read the article

• Check if a connection is in a transaction

  - by acidzombie24

  I am getting a SqlConnection does not support parallel transactions. exception and this answer mentions its when a connection tries to open two transactions. This is exactly what i am doing. I thought nested transactions were ok (i was using sqlite for the prototype). How do i check if the connection is already in a transaction? I am using Microsoft SQL Server Database File.

  Read the article

• SQL - Add up all row-values of one column in a singletable

  - by ThE_-_BliZZarD

  Hello Everybody, I've got a question regarding a SQL-select-query: The table contains several columns, one of which is an Integer-column called "size" - the task I'm trying to perform is query the table for the sum of all rows (their values), or to be more exact get a artifical column in my ResultSet called "overallSize" which contains the sum of all "size"-values in the table. Preferable it would be possible to use a WHERE-clause to add only certain values ("WHERE bla = 5" or something similar). The DB-engine is HSQLDB (HyperSQL), which is compliant to SQL2008. Thank you in advance :)

  Read the article

• Keeping the data in memory or sql database

  - by user14322

  I'm trying to learn SQL to store the data rather than reading the file and populating the whole data structure in memory. would it be like reading the data from disk instead of direct memory?

  Read the article

• "Ambiguous column name" error on one particular server

  - by jazbit

  This simple query throws the "Ambiguous column name TaskID" error on one db-server only. This is ridiculous. We tested this with the same database structure on different servers and different versions of ms sql (2005/2008), and it's only THIS particular client's server that throws the error. I'm actually frustrated. SELECT Tasks.TaskID FROM Tasks INNER JOIN TaskHelpers ON TaskHelpers.TaskID = Tasks.TaskID order by TaskID Yes, I know I can put "Tasks.TaskID" into the order by clause, but for some reasons I can't.

  Read the article

• join two tables but want one matching columns instead of showing it separately sql server 2008

  - by amby

  Hi i want to display join result of two tables but don't want to show matching column separately. I want it one instead of two. so please tell me what query should i use for this. I m using sql server 2008 and my query is like: select * from Customer_Order, optRelation where Customer_Order.orderNumber = optRelation.orderNumber AND optRelation.orderNumber = 21. please reply soon

  Read the article

• Date difference in SQL Server 2005

  - by naveen

  Hi, I have two dates of the form Start Date: 2007-03-24, End Date: 2009-06-26 Now I need to find the difference between these two in the below form: 2 years, 3 months and 2 days Can someone please … in SQL Server 2005

  Read the article

• What's the sql scheme for supporting Tags system?

  - by Tom

  Hi, i've coded a tiny forum software in php where people posts threads, and i want to support tags. How many SQL tables should i make for this ? and briefly how the tags system will work? Thanks

  Read the article

• Signs that a SQL statement is dangerous

  - by Matt

  Hi, I want to develop a function in PHP that checks how dangerous a SQL statement is. When i say dangerous i mean, certain symbols, characters or strings that are used to get data from a database that the user shouldnt see. For example: SELECT * FROM users WHERE userId = '1' can be injected in several ways. Although i clean the params, i also want to monitor how safe the query is to run. Thanks in advance

  Read the article

• LINQ display row numbers

  - by timvaines

  I simply want to include a row number against the returned results of my query. I found the following post that describes what I am trying to achieve but gives me an exception http://vaultofthoughts.net/LINQRowNumberColumn.aspx "An expression tree may not contain an assignment operator" In MS SQL I would just use the ROWNUMBER() function, I'm simply looking for the equivalent in LINQ.

  Read the article

• Get SQL Server 2008 Management Studio icons

  - by alex

  I want to get icons from SQL Server 2008 Management Studio. Is it free ? If so where can I download it ?

  Read the article

• INSERT 2000 records into SQL Database all at a time from C# .NET code

  - by padmavathi

  We need to INSERT 2000 records into SQL DB from C# .Net code. For this is there any way to INSERT all 2000 records at a time instead of executing the INSERT query for each record. Also how would be the performance impact of doing this? Thanks & Regards Padma

  Read the article

• MDF and LDF Files size

  - by Nazim

  I was wondering if there was any recommended max size for MDF and/or LDF Files for an SQL server instance. For example, if I want to create a 400 GBytes Database, is there a rule to help me decide how many mdf files I should create ? or should I just go ahead and create a single gigantic 400Gbytes mdf file? If so is this going to somehow affect the database performances ?

  Read the article

• SQL Server Redirection

  - by MrTehee

  We are switching from a SQL cluster to a mirrored solution. The problem is that we have a bunch of programs that would have to switch connection strings to handle the failover. Is there any way the we can set up a redirect or proxy that would take any legacy requests and forward them to the mirrored solution?

  Read the article

• SQL updating a column in a table

  - by tecnodude

  Hi, I have the following table in an access database id VisitNo Weight 1 1 100 1 2 95 1 3 96 1 4 94 1 5 93 Now row 2 and 4 are deleted. So i have... id VisitNo Weight 1 1 100 1 3 96 1 5 93 However what i need is... id VisitNo Weight 1 1 100 1 2 96 1 3 93 What is the SQL query i need to accomplish the above? thanks

  Read the article

• Find query that caused update

  - by MadMax

  We have been having problems with ghost updates in our DB (SQL Server 2005) fields are changeing and we cannot find the routine that is updating. Is there a way using an update trigger (Or any other way) to tell what caused the update?

  Read the article

• List all tables that are currently published for replication MS-SQL

  - by Scott Vercuski

  I need to get a list of all tables that are published for replication from MS-SQL 2005/2008 databases. Is there a system stored procedure or a query I could run to generate such a list? Thank you,

  Read the article

< Previous Page | 258 259 260 261 262 263 264 265 266 267 268 269  | Next Page >