Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
14,811 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 593
Page Size: 10 · 25 · 50

Tag filtered by:  SQL-Server [x]
Answer 13 May 2013   license: CPOL
You need to either understand PIVOT / UNPIVOThttp://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[^]orCreate two select statements and use them as derived tables. Then you can join on ID and get your output.i.e.Select a.Id, a.Time InTime, b.Time...
ASP.NETSQL-Server
Question 13 May 2013   license: CPOL
Hi friends when convert ms access database into sql server database using sqlserver importdata the following error is occured. The Workgroup information file is missing or opened exclusively by another user.but i did not open MsAccess file any where in the system while...
SQL-Server
Article 13 May 2013   license: CPOL
View and rate box art for your favorite Xbox games!
C#SQL-ServerMobileDevIntermediateAzureCloudWindows-Phone-8
Question 13 May 2013   license: CPOL
I have one column named as Time with another column named as ID.I want to divide the column Time in two different columns as InTime & OutTime.But the important thing is that if the count of that ID present in a ID column is even, the corresponding value present at that ID of column Time...
ASP.NETSQL-Server
Article 13 May 2013   license: CPOL
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables
SQL2000SQL2005SQLSQL-ServerDBADevBeginnerIntermediateSQL-ServerSQL2008, +
Article 13 May 2013   license: CPOL
Example of Application with GitHub, SQL-CE, EF and SQL-Azure integration with Azure WebSites
SQL-CEC#SQL-ServerSQL-ServerAzureGitNHibernateAzureWebSites
Answer 13 May 2013   license: CPOL
Hi,Try this...SELECT distinct r.rate as Rate,f.bthid as Batchid,CASE WHEN r.rate = '1' THEN '100' WHEN r.rate = '2' THEN '75' WHEN r.rate = '3' THEN '50' WHEN r.rate = '4' THEN '25' ELSE '0' END AS Translated_Rate FROM bthfac fINNER JOIN faculty fa ON...
SQL-Server
Question 13 May 2013   license: CPOL
Faculty table records as follows:- Facid Faculty 1 MADHAVAN 2 Sekar 3 John 4 vinoth 5 Ramesh Batch table records as follows Bthid Examdate 1 14/9/2011 2 24/10/2011 3 9/12/2011 4...
SQL-Server
Answer 13 May 2013   license: CPOL
Hi,Check the following CodeSELECT GETDATE()GO-- SQL Server 2000/2005SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond,CONVERT(VARCHAR(10),GETDATE(),101) AS DateOnly;GO-- SQL Server 2008 OnwardsSELECT CONVERT(TIME,GETDATE()) AS HourMinuteSeconds;SELECT...
ASP.NETSQL-ServerDateTime
Answer 13 May 2013   license: CPOL
Here, SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime[^]
ASP.NETSQL-ServerDateTime
Question 13 May 2013   license: CPOL
I have a column which has date-time,i want to convert that into hours and minutes/minutes only,any sql statement that can help me?(NB still a learner)
ASP.NETSQL-ServerDateTime
Answer 13 May 2013   license: CPOL
select CAST(DATEDIFF(dd,'2013-04-16 05:00:00' , '2013-04-19 20:00:10') as varchar) +':'+convert(char(5), dateadd(ss, DATEDIFF(ss,'2013-04-16 05:00:00' , '2013-04-16 20:00:10'), cast(0 as DateTime)) , 108)
SQL-Server
Answer 13 May 2013   license: CPOL
Try this:ALTER PROCEDURE sp_ArchiveTable1( @StartDate datetime, @EndDate datetime, @DateColumn VARCHAR(100), @TableName VARCHAR(100), @NewTableName VARCHAR(100))ASBEGIN DECLARE @NextIDs TABLE(UniqueID int primary key) DECLARE @statement nchar(1000) = N'SELECT * INTO...
SQL-Server
Answer 12 May 2013   license: CPOL
Please, see this article: Building Dynamic SQL In a Stored Procedure[^]
SQL-Server
Answer 12 May 2013   license: CPOL
I think you have to use exec(here your query) command for this to get executed.Hope this helps...
SQL-Server
Question 12 May 2013   license: CPOL
Currently I have started creating a procedure, which gets the parameters and should copy the contents of one table to another with certain conditions. I have copied the codes here. It compiles good. But nothing is affected.ALTER PROCEDURE sp_ArchiveTable1(@StartDate datetime,@EndDate...
SQL-Server
Question 12 May 2013   license: CPOL
Hi friends I have tried to convert ms access database to sql database.but i could not able to done it successfully. the below methods are i have been using so for1.from sql server 2008 i created a empty database and try to import data from task but it shows cannot start your...
SQL-Server
Answer 12 May 2013   license: CPOL
Try this:SELECT DISTINCT *FROM Tmp Tmp inner JOIN MARKET_PLACE_DESIGN_RELATION MPDR ON MPDR.MARKET_PLACE_DESIGN=Tmp.MarketDesignhttp://www.w3schools.com/sql/sql_distinct.asp[^]
SQL-Server
Question 12 May 2013   license: CPOL
i have a table market_place_design which has different market places and designs.1 design exists in different market places.I have another table temp which has only column design filled in it.Now after joining the tables i am getting multiple data for a single design whereas i need only 1...
SQL-Server
Answer 12 May 2013   license: CPOL
http://social.msdn.microsoft.c...
SQL-ServerIndexes
Question 12 May 2013   license: CPOL
how to i use BETWEEN in sql server for the column with varchar datatype?please help...i want to select the rows between the row which has column saysomething with value "Hello" and another row which has value "lol" for the same column..
SQL-Server
Answer 12 May 2013   license: CPOL
http://beginner-sql-tutorial.c...
SQL-Server
Answer 12 May 2013   license: CPOL
Declare @Seconds as intDeclare @SubtractDate as datetime--Enter Number of Seconds hereSet @Seconds=9974501Set @SubtractDate=DateAdd(s,@Seconds,getdate()) - Getdate() Select Convert(varchar(10),DateDiff(day,'1900-01-01',@SubtractDate))+ ' Day(s) '...
SQL-Server
Question 12 May 2013   license: CPOL
Following Query returns me Number difference in format of "HH:MM:SS"select convert(char(8), dateadd(ss, DATEDIFF(ss,'2013-04-16 05:00:00' , '2013-04-16 20:00:10'), cast(0 as DateTime)) , 108)output of above query is " 15:00:10 " which is correct but if i change query as below...
SQL-Server
Answer 12 May 2013   license: CPOL
Read the following : http://databases.aspfaq.com/general/why-do-some-sql-strings-have-an-n-prefix.html[^]
SQL-Server
Page 1 of 593
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 13 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid