No announcements
Found 1026079 threads
-
0 Votes
With in sql query
WITH can either denote the start of a common table expression (CTE) or a locking hint so in the case of a CTE the semi colon is mandatory to end the statement preceding its declaration so the ...Answered | 6 Replies | 1244 Views | Created by miruan - Tuesday, May 7, 2013 10:58 AM | Last reply by Andre Ranieri - Tuesday, May 7, 2013 2:07 PM -
0 Votes
sql query
Hi Naomi, Your query returns 0 rows.Answered | 16 Replies | 1060 Views | Created by Shaky1988 - Tuesday, April 29, 2014 12:11 PM | Last reply by HimanshuSharma - Wednesday, April 30, 2014 11:24 AM -
0 Votes
SQL Query
newTable; set @sql='select * into newTable from (' + @sql + ') s'; exec(@sql); select * from newTable;Answered | 10 Replies | 653 Views | Created by Tech Aspirant - Monday, December 7, 2015 11:36 AM | Last reply by Sam Zha - Wednesday, December 9, 2015 2:46 AM -
0 Votes
Access query vs SQL query
I think your query has got the wrong WHERE conditions.Answered | 6 Replies | 3803 Views | Created by Swan_E - Wednesday, July 1, 2009 11:28 AM | Last reply by John Ang_ - Wednesday, July 1, 2009 1:46 PM -
0 Votes
SQL Query
Please get a book on basic RDBMS and SQL.Answered | 4 Replies | 493 Views | Created by Ryan88878 - Sunday, July 10, 2016 12:25 PM | Last reply by PrasadSahoo - Monday, July 11, 2016 8:14 AM -
0 Votes
SQL QUERIES
i used following queries --GET all database name SELECT * FROM sys.sysdatabases Select name,filename,crdate,version From ...Answered | 4 Replies | 2088 Views | Created by Esha2nk - Tuesday, September 25, 2012 12:37 PM | Last reply by SQLZealots - Tuesday, September 25, 2012 1:00 PM -
0 Votes
sql query
is there any query in sql to print next line like:- abc xyz You can use the carriage return or line feed to achieve this.Answered | 2 Replies | 5716 Views | Created by Varu007 - Friday, February 12, 2010 8:44 AM | Last reply by Clive Strong - Saturday, February 13, 2010 2:27 PM -
0 Votes
SQL Query
SELECT COUNT(*) FROM WebSalesLine WHERE '@SearchType' LIKE '%WSH1076%' You need the column in the WHERE clause like: SELECT COUNT(*) FROM WebSalesLine ...Answered | 2 Replies | 3830 Views | Created by kishanraj - Tuesday, March 23, 2010 7:24 AM | Last reply by Kalman Toth - Tuesday, March 23, 2010 7:32 AM -
6 Votes
SQL Query
You can either use an aggregate function along with CASE statement or a PIVOT operator like below; DECLARE @Attendance AS TABLE ( Name ...Answered | 5 Replies | 922 Views | Created by Sunil404 - Friday, November 14, 2014 10:48 AM | Last reply by Krishnakumar S - Friday, November 14, 2014 11:26 AM -
0 Votes
SQL Query
The minimal polite behavior on an SQL forum is to post DDL.Answered | 4 Replies | 1127 Views | Created by akhilrajau - Tuesday, April 23, 2013 12:53 PM | Last reply by --CELKO-- - Tuesday, April 23, 2013 1:35 PM -
0 Votes
SQL Queries
That means you can connect to the server but failed to execute queries?Answered | 2 Replies | 5799 Views | Created by adrw - Tuesday, October 12, 2010 1:50 PM | Last reply by Rick Byham, Microsoft - Wednesday, October 13, 2010 3:21 PM -
0 Votes
SQL Query
Second, since there are 10 different time related types in SQL Server, you don't want to keep adjusting this "fraction of second" part checking at the column's exact type ...Answered | 5 Replies | 1841 Views | Created by Raj ku - Friday, February 22, 2013 9:31 PM | Last reply by TiborK - Saturday, February 23, 2013 7:29 AM -
0 Votes
SQL queries
for basic understanding of SQL check this out http://www.w3schools.com/sql/default.asp Nothing is Permanent... even Knowledge....Answered | 2 Replies | 4144 Views | Created by jeromejp - Tuesday, July 26, 2011 2:42 PM | Last reply by Surendra Nath GM - Tuesday, July 26, 2011 5:59 PM -
1 Votes
sql query
thnx for helping me but my problem is not solved '"DvgContact.SelectedRows(0).Cells(2).Value "' is String ...Answered | 7 Replies | 3257 Views | Created by ovais71 - Sunday, October 9, 2011 9:35 AM | Last reply by Khanna Gaurav - Tuesday, October 11, 2011 12:20 PM -
4 Votes
Sql Query
your query is costing 0.0183403 while with union it is ...Answered | 8 Replies | 2815 Views | Created by Gangadhar Thumu - Monday, February 13, 2012 6:28 AM | Last reply by David Frommer - Saturday, February 18, 2012 11:05 PM -
0 Votes
SQL query
You can use the CONVERT function with argument 101: select convert(datetime, '12/31/2016 01:03:03PM', 101) Since you asked in the Training and Certification ...Answered | 1 Replies | 1475 Views | Created by Gunjan1402 - Tuesday, July 5, 2016 1:24 PM | Last reply by Alberto Poblacion - Wednesday, July 6, 2016 5:32 AM -
0 Votes
SQL query
Dataset query: select username, userrights from yourtable Row Group: username Column Group: ...Answered | 3 Replies | 700 Views | Created by SQLrocket3003 - Sunday, November 2, 2014 10:40 PM | Last reply by cruellogic - Monday, November 3, 2014 5:37 AM - Items 1 to 20 of 1026079 Next ›
No announcements