No announcements
Found 3763480 threads
-
1 Voteshow to Write query in better way
Alternatively, you could dynamically append WHERE clause within the report code (or front end) based on value selected in report and pass on the appropriate query ...Answered | 7 Replies | 2409 Views | Created by Aminesh - Tuesday, December 6, 2011 7:22 AM | Last reply by Brian Tkatch - Tuesday, December 6, 2011 2:32 PM
-
2 Votes
How to write insert query in vb code in msaccess2010
Please feel free to let us know if you have any concern/question.Answered | 3 Replies | 1686 Views | Created by WhiteSmile - Wednesday, January 2, 2013 6:50 AM | Last reply by Dummy yoyo - Wednesday, January 16, 2013 6:54 AM -
0 Votes
How to write sql query to insert values
To automate this process, or make it dynamic you could use the source table's schema, and then use dynamic sql to do a select into with all the values ...Answered | 11 Replies | 4508 Views | Created by Dr.X1987 - Sunday, July 17, 2011 6:11 PM | Last reply by Dr.X1987 - Monday, July 18, 2011 5:12 PM -
1 Votes
Better way to write this Query
I doubt this variation of the query will perform any different than your original query although you never know.Answered | 6 Replies | 1167 Views | Created by Diango - Monday, December 30, 2013 2:34 PM | Last reply by Naomi N - Monday, December 30, 2013 8:48 PM -
0 Votes
Best way to write INSERT in C#
>what is the best way to use INSERT INTO in C# and why?Answered | 5 Replies | 682 Views | Created by TakeshiKitano - Tuesday, September 27, 2016 4:30 PM | Last reply by Sabah Shariq - Wednesday, October 5, 2016 10:53 AM -
0 Votes
Efficient way to write Select
In case of exact match you write = instead of LIKE.Answered | 3 Replies | 4536 Views | Created by NSG12 - Friday, April 23, 2010 9:52 PM | Last reply by - Thursday, February 4, 2016 3:18 AM -
0 Votes
Is there any way to write dynamic queries for select, insert, update instead of writing hard coded query in every page in asp.net c#
User-573138384 posted You can use sp_execute for dynamically executing queries.Answered | 2 Replies | 48 Views | Created by Anonymous - Sunday, April 3, 2016 7:45 AM | Last reply by Anonymous - Tuesday, April 5, 2016 7:42 AM -
0 Votes
why select query has writes, how to avoid?
If you have any other questions, please let me know.Answered | 10 Replies | 1630 Views | Created by alanzhouoad - Tuesday, August 16, 2016 10:20 PM | Last reply by Lin Leng - Friday, August 26, 2016 2:00 AM -
0 Votes
How to write these queries dynamically ?
If you have a DataTable and not just an IEnumerable<DataRow>, you can use DataTable.Select(string filterExpression), otherwise you may be able to use the LINQ Dynamic ...Answered | 1 Replies | 4439 Views | Created by fndoomed - Thursday, August 5, 2010 2:22 PM | Last reply by Fabrice MARGUERIE - Monday, August 9, 2010 1:55 PM -
1 Votes
Is there a more graceful way to write this query?
Can you think of another way to do this?Answered | 6 Replies | 4282 Views | Created by Mantros Group - Monday, July 19, 2010 9:19 PM | Last reply by Mantros Group - Tuesday, July 20, 2010 3:09 AM -
0 Votes
Writing an Instead Of trigger for a table update
When we created the instead of triggers in SQL, their purpose was to allow updatable views.Answered | 5 Replies | 875 Views | Created by GretchenF - Friday, June 30, 2017 5:51 PM | Last reply by Xi Jin - Monday, July 3, 2017 5:53 AM -
0 Votes
Best Way write Query for parameter
This is awful programming in any programming language.Answered | 5 Replies | 640 Views | Created by sks_989 - Thursday, April 7, 2016 2:34 PM | Last reply by Sam Zha - Friday, April 8, 2016 5:24 AM -
0 Votes
Error in writing condition in a query
Please execute below to see if it gives you expected result declare @dte as datetime='2015-04-01' declare @StDt as Datetime = DATEADD(mm,DATEDIFF(mm,0,@dte), 0) declare ...Answered | 4 Replies | 1109 Views | Created by baiju krishnan - Saturday, April 4, 2015 8:50 AM | Last reply by Uri Dimant - Saturday, April 4, 2015 10:08 AM -
1 Votes
Need help with writing a query
Queries written in ANSI SQL are good when you have to write applications running against Microsoft and not Microsoft databases, but Stefan wanted only to give you code ...Answered | 6 Replies | 2286 Views | Created by MSDB - Tuesday, May 14, 2013 5:21 PM | Last reply by Papy Normand - Tuesday, May 21, 2013 1:51 PM -
0 Votes
Optimized way to write below query -
Maybe we can do this as - SELECT a.Answered | 4 Replies | 612 Views | Created by AK_87 - Wednesday, September 7, 2016 6:17 AM | Last reply by AK_87 - Wednesday, September 7, 2016 11:18 AM -
1 Votes
Best way to write the query for given Requirement
Is there any way that I can improve this query?Answered | 6 Replies | 728 Views | Created by Vijeth.Sankethi - Wednesday, October 14, 2015 9:07 AM | Last reply by Vijeth.Sankethi - Wednesday, October 14, 2015 11:26 AM -
1 Votes
write query with all possible permutations
When you get to the point in your question where you want to insert the code just click on the insert code block as shown in the above like.Answered | 6 Replies | 2574 Views | Created by rafuria - Tuesday, September 6, 2016 9:53 PM | Last reply by rafuria - Wednesday, September 7, 2016 11:12 AM -
1 Votes
How to write this query string
It was simply another way of doing the same loop.Answered | 12 Replies | 4495 Views | Created by truelyli - Monday, November 16, 2009 6:12 PM | Last reply by truelyli - Friday, November 20, 2009 4:43 PM -
0 Votes
BEST WAY OF WRITING CODE
You can check the performance of your query and decide, below is the URL which talks about how to check the actual performance of sql ...Answered | 6 Replies | 2062 Views | Created by KODI_KODI - Thursday, January 10, 2013 10:52 PM | Last reply by Varsha Mishra - Friday, January 11, 2013 12:40 PM -
2 Votes
storing images in sql server 2008 without writing queries and C# code
Bulk insert to do it; ...Answered | 2 Replies | 9406 Views | Created by Ansaria Jamshan - Thursday, August 5, 2010 4:42 PM | Last reply by Sylvain Lafontaine - Friday, August 6, 2010 5:47 AM - Items 1 to 20 of 3763480 Next ›
No announcements
