Search Results

Search found 28052 results on 1123 pages for 't sql tuesday'.

Page 253/1123 | < Previous Page | 249 250 251 252 253 254 255 256 257 258 259 260  | Next Page >

• ms sql server identity counterpart problem

  - by Guru

  hi there, I'm using MS Sql Server and I want to use identity constraint in it I know how to use it in following manner create table mytable ( c1 int primary key identity(1,1); ) the above code works fine but what if i want the identity column to have values as EMP001, EMP002,... instead of 1,2.... Thanks in advance, Guru

  Read the article

• PL SQL Where Clause with Column/Field name being a datatype

  - by Dale

  Quick question playing with PL SQL it seems that the tables column was named as the data type NUMBER so trying to perform a query fails since the column is being recognized as a datatype instead of a column name. Anyone know how to get around this without modifying the schema?

  Read the article

• Full text search on multiple fields in different tables

  - by crisgomez

  Hi, I want to create a a full text search usng ms sql 2005. here is the structure of my table User-contains fields of Id, fname,lname,email,alternativeemail Attachment-contains fields of id, name,category,filenameorurl Certification-contains of fileds of id, title,school,sdate,edate EducationalBackground-contain of fields of, id,qualification,sdate,edate,school,fieldofstudy EmploymentDetails-contain of fields position, positionlevelid,specializationid,description now the relationship of user to the other table is one to many relationship. now how can I create an effective query to have quick full text search and return the values of the different tables?any help please

  Read the article

• Keyword search on all columns of multiple tables in sql server

  - by hiralshah

  Dear all, We are maintaining the profile information’s (like profile first name, last name, address, city, state, age, religion, occupation, education, etc….) from tbl_profie table in sql server. The users can search profiles using any keywords like Example 1: MBBS, Delhi, India Example 2: MBA, Delhi, cricket Example 3 : London, Hindu Tbl_profile table defending some parent table like Tbl_city, Tbl_state, Tbl_country, Tbl_occupation, Tbl_education tables, etc. So how to fetch user search results from Tbl_profile and profiles related tables using user’s keyword with easiest way.

  Read the article

• Append SQL table name with today's date

  - by Ricardo Deano

  Hello all. I understand that I can change a sql table using the follow sp: EXEC sp_rename 'customers', 'custs' How would I go about appending this so that the new table has today's date as a suffix? I've attempt variations on the below theme with little success!! EXEC sp_rename 'customers', 'customers +(CONVERT(VARCHAR(8),GETDATE(),3))' Any help greatly appreciated.

  Read the article

• Install SQL express; msm file

  - by Jacek

  Where can I download sql server 2008 msm file from ?? I need to insall it with my software ?? Thanx :) Jacek

  Read the article

• I don't find the sql request

  - by user301089

  Hi everybody, Here it's my problem I've a list of the following measure : src1 dst2 24th december 2009 src1 dst3 22th december 2009 src1 dst2 18th december 2009 I would like to have just the latest measures with a sql request - 2 first lines in my case because the pairs(src and dst) aren't the same. I try to use DISTINCT but I have just the 2 first columns and I will all columns. I try too GROUP BY but I hadn't success. Anyone can help me ? Thx Narglix

  Read the article

• Change the precision of all decimal columns in every table in the database

  - by Jon

  Hi all, I have a rather large database that has alot of decimal columns in alot of tables, the customer has now changed their mind and wants all the numbers (decimals) to have a precision of 3 d.p. instead of the original two. Is there any quick way of going through all the tables in a database and changing any decimal column in that table to have 3.d.p instead of 2 d.p? The db is on sql 2005. Any help would be great.

  Read the article

• set difference in SQL query

  - by TheObserver

  I'm trying to select records with a statement SELECT * FROM A WHERE LEFT(B, 5) IN (SELECT * FROM (SELECT LEFT(A.B,5), COUNT(DISTINCT A.C) c_count FROM A GROUP BY LEFT(B,5) ) p1 WHERE p1.c_count = 1 ) AND C IN (SELECT * FROM (SELECT A.C , COUNT(DISTINCT LEFT(A.B,5)) b_count FROM A GROUP BY C ) p2 WHERE p2.b_count = 1) which takes a long time to run ~15 sec. Is there a better way of writing this SQL?

  Read the article

• php 5.3.2 + MS SQL (can`t connect)

  - by Dezigo

  I allways used php 5.2.3 version ,but now I updated php to 5.3.2 version. I have problem with mssql,I can`t connect to mssql server. I have downloaded a sql server driver for php 1.1 There are a lot of files, i used 'php_sqlsrv_53_ts_vc9' Put it on php/ext directory 'php_sqlsrv_53_ts_vc9' I have added - extension=php_sqlsrv_53_ts_vc9.dll (in php.ini),but it`s give an error Call to undefined function mssql_connect() in C:\webserver\www\MSSQl\db_mssql.class.php on line 26

  Read the article

• Transparent PNG not working in SQL Server Image field

  - by Midhat

  Hi I have tried uploading a transparent PNG image to a SQL server image field, and retrieving it using the DynamicData ImageHandler. The Transparent areas in the image appear white upon rendering. Please advise about any solutions

  Read the article

• SQl function in android

  - by rui.pereira

  Cursor cursor = db.rawQuery("SELECT COUNT(rat) FROM "+ TABLE_NAME_EXTRA +" apkid=\""+apkid, null); cursor.moveToFirst(); int somatotal = cursor.getInt(0); I'm trying to do a SQL function like count and sum, but this code returns a exception saying "emptyvalues". anyone know why?

  Read the article

• SQL Select statement that includes a column that isn't in the database

  - by Cypher

  I'm trying to execute a SELECT statement that includes a column of a static string value. I've done this in Access, but never with raw SQL. Is this possible? Example: Name Status John Unpaid Terry Unpaid Joe Unpaid In the above example, the "Status" column doesn't exist in the database.

  Read the article

• Determining if a SQL Server table is read-only

  - by rono

  What's the best way to determine if a given SQL Server table is readonly, either because of account permissions or the database being marked as read-only?

  Read the article

• if-else equivalent via linq-to-sql query in where clause c#

  - by Darcy

  Hi guys, Basically I wanted to have an if-else statement in my linq to sql statement. var query = from d in database if(x == y) { where d.Attr = x } else { where d.Attr = y } select d; Any ideas?

  Read the article

• difference between "=null" and "is null" in sql server 2008

  - by user329820

  Hi I asked the same question in this forum but I want to know that is there any differnce between "=null" and "is null" in sql server 2008? thanks

  Read the article

• Using NHibernate to insert/update using a SQL server-side DEFAULT value

  - by Joseph Daigle

  Several of our database tables contain LastModifiedDate columns. We would like these to stay synchronized based on a single time-source. Our best time-source, in this case, is the SQL Server itself since there is only one database server but multiple application servers which could potentially be off sync. I would like to be able to use NHibernate, but have it use either GETUTCDATE() or DEFAULT for the column value when updating or inserting rows on these tables. Thoughts?

  Read the article

• Ad hock queries vs stored procedures vs Dynamic SQL

  - by Kristaps

  Ad hock queries vs stored procedures vs Dynamic SQL. Can anyone say pros and cons? Best regards, Kristaps

  Read the article

• SQL Server and Table-Valued User-Defined Function optimizations

  - by John Leidegren

  If I have an UDF that returns a table, with thousands of rows, but I just want a particular row from that rowset, will SQL Server be able to handle this effciently? SELECT * FROM dbo.MyTableUDF() WHERE ID = 1 To what extent is the query optimizer capable of reasoning about this type of query? How are Table-Valued UDFs different from traidtional views if they take no parameters? Any gotchas I should know about?

  Read the article

• MS Access 97 application working directly with MS SQL Server 2005

  - by hgulyan

  Please, give me the most serious arguments against this. Application directly opens a connection to ms sql server, directly executes queries. So what I'd like to ask: 1) Why it is wrong? 2) What serious problems can that cause? 3) What should I do?:)

  Read the article

• Are any of these SQL Queries open to SQL injection attacks?

  - by Phil

  I have re-written my code after great help from some friendly stack overflow members (big thanks to Martin B and Kev Chadders especially). I would now like to check if my code is still open to SQL Injections after this work. I believe the code is now working as it should, but any blinding errors that you see i'd love to hear about too. My code is now looking like: -code removed-

  Read the article

• SQL Join Statement

  - by mouthpiec

  Hi I have the following SQL SELECT statement SELECT bar_id, bar_name, town_name, advert_text FROM bar, towns, baradverts WHERE town_id = town_id_fk AND bar_id = bar_id_fk My problem is that since not every bar has an advert in table "baradverts", these bars are not coming up in the results. In other words I need a NULL for those bars that do not have an advert string.

  Read the article

• SQL server SP : @Param 's with sometime NULL values

  - by openidsujoy

  I am very new to SQL Server Stored Procedures, I am trying to create a SP that will give return a list of records in a table by filter via StartDate and EndDate , but there will be 'View All' Option so sometime those @Param might not contain any values. Currently my SP is Like CREATE PROCEDURE [dbo].[spGetBonusRun] ( @StartDate as DATETIME, @EndDate as DATETIME ) AS SELECT [Id] ,[StartDateTime] ,[EndDate] ,[Status] FROM [Valt].[dbo].[BonusRun] WHERE StartDateTime <= @StartDate AND EndDate >= @EndDate How to active that ?

  Read the article

• Does SQL Server CE 3.5 SP1 install everything?

  - by Vaccano

  I am trying to set up a device remotely. I found this link: http://www.microsoft.com/downloads/details.aspx?familyid=FCE9ABBF-F807-45D6-A457-AB5615001C8F&displaylang=en That has SQL Server CE 3.5 SP1. I read the whole page, and can't seem to find out for sure if SP1 is a full install or if it needs SQLServer CE 3.5 first. Does anyone know?

  Read the article

• SQL query through an intermediate table

  - by Bryan

  Given the following tables: Recipes | id | name | 1 | 'chocolate cream pie' | 2 | 'banana cream pie' | 3 | 'chocolate banana surprise' Ingredients | id | name | 1 | 'banana' | 2 | 'cream' | 3 | 'chocolate' RecipeIngredients | recipe_id | ingredient_id | 1 | 2 | 1 | 3 | 2 | 1 | 2 | 2 | 3 | 1 | 3 | 3 How do I construct a SQL query to find recipes where ingredients.name = 'chocolate' and ingredients.name = 'cream'?

  Read the article

< Previous Page | 249 250 251 252 253 254 255 256 257 258 259 260  | Next Page >