Search Results

Search found 43145 results on 1726 pages for 'sql select'.

Page 313/1726 | < Previous Page | 309 310 311 312 313 314 315 316 317 318 319 320  | Next Page >

• 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

• 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

• 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

• 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

• 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

• 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

• Edit all views and stored precedures, find and replace?

  - by johnboy

  Is there an easy way to do a find and replace on a string in every view and stored procedure in my SQL Server database. I need to replace something like 'X United Kingdom' with 'X(UK)'.

  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

• sql count() query for tables

  - by air

  i have two tables table1 fields fid,fname,fage a ,abc ,20 b ,bcv ,21 c ,cyx ,19 table2 fields rcno,fid,status 1 ,a ,ok 2 ,c ,ok 3 ,a ,ok 4 ,b ,ok 5 ,a ,ok i want to display rectors like this fid from table1 , count(recno) from table 2 and fage from table1 fid,count(recno),fage a ,3 ,20 b ,2 ,21 c ,1 ,19 i try many sql queries but got error Thanks

  Read the article

• basic differences between oracle and SQL Server?

  - by I__

  i am going on a job interview and have zero experience with ms sql, however i have 1 year with oracle. is there such a huge difference between the two? what programming questions can i expect?

  Read the article

• How to filter a duration in SQL Profiler

  - by user341460

  Hi Friends, I need to run a profiler on SQL 2005 to capture the SPs with which took longer than 1/10th of a second. Can you please let me know how can I do that. I dont see the option. Also in the duration is that measured in second or minute. I would apprecaite your help. Thanks,

  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

• Getting average from 3 columns in MS SQL

  - by barbarian

  I have table with 3 columns(smallint) in MS SQL 2005. Table Ratings ratin1 smallint, ratin2 smallint ratin3 smallint These columns can have values from 0 to 5 How to select average value of these fields, but only compare fields where value is greater then 0. So if column values are 1,3,5 - average had to be 3 if values are 0,3,5 - average had to be 4

  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

• Problem using IIS 7 and SQL SERVER 2008

  - by Daniel

  I have problem using IIS 7 and SQL Server 2008. When I trying to show my website using IIS as webserver I get the message "[SqlException (0x80131904): Login failed for user..." When I using the webserver included in Visual Studio 2010 to show same website there is no problem to access the database. Why is it working with VS2010 webserver but not with IIS?

  Read the article

• Is there anyway that we can get a label value to a Sql

  - by Pradeep

  SELECT COUNT(*) AS Expr1 FROM Book INNER JOIN Temp_Order ON Book.Book_ID = Temp_Order.Book_ID WHERE (Temp_Order.User_ID = 25) AND (CONVERT (nvarchar, Temp_Order.OrderDate, 111) = CONVERT (nvarchar, GETDATE(), 111)) In here i want to change my User_ID to get from a label.Text this Sql Statement is in a DataView. so in the Wizard it not accepting a text box values or anything. can someone please help me to solve this

  Read the article

• sql query help join (i think)

  - by milan

  I am having trouble figuring our how I can get results only when products.published, product_types.published, and product_cats.published = 1 but my query isn't working. Please help: SELECT `products`.`title`, `products`.`menu_id`, `products`.`short_description`, `products`.`datasheet_icon`, `products`.`datasheet`, `products`.`ordering`, `products`.`product_type_id`, CASE WHEN CHAR_LENGTH(`products`.`alias`) THEN CONCAT_WS(':', `products`.`id`, `products`.`alias`) ELSE `products`.`id` END AS slug FROM `products`, `product_cats`, `product_types` WHERE `products`.published=1 AND `product_cats`.published=1 AND `product_types`.published=1 AND `products`.`product_cat_id`='42' AND `product_types`.`id` IN (1,40,48,49,50) GROUP BY `products`.`id` ORDER BY `product_types`.`ordering`, `products`.`ordering`

  Read the article

• What is 'type' in systypes?

  - by cruzy

  In sys.systypes ... what exactly is 'type'? What exactly does .... bigint int varchar ... order mean when I execute select * from sys.systypes order by type desc

  Read the article

• sql: connecting tables that have no relation

  - by every_answer_gets_a_point

  if i have two tables that have nothing in common i want to do a select as follows: column from table1, column from table 2 how do i do it?

  Read the article

• What are JOINs in SQL (for)?

  - by sabwufer

  I have been using MySQL for 2 years now, yet I still don't know what you actually do with the JOIN statement. I really didn't come across any situation where I was unable to solve a problem with the statements and syntax I already know (SELECT, INSERT, UPDATE, ordering, ...) What does JOIN do in MySQL? (Where) Do I need it? Should I generally avoid it?

  Read the article

• SQL: column <> '%TEST%' does not work, why?

  - by Petr

  Hi, I do not understand why following code does not work? SELECT [column1], [column2] FROM table where Column1 <> ('%TEST%') ORDER BY 1 I want to have all rows where Column1 does not contain TEST Thanks

  Read the article

• [SQL server 2K] What is the impact coming from wildcard %

  - by user149578

  Hi guys: I need to add a new SELECT statement whose search condition include something like leagueCode='nba%'. I would like to know if the index against leagueCode is still exploitable or introduce any overhead after % is included in the target column.

  Read the article

< Previous Page | 309 310 311 312 313 314 315 316 317 318 319 320  | Next Page >