.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Dynamics sql correct way to write it --> eu_securityrole LIKE ('+% Doc %+')'

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server


How do you write properly for a string :

set @CRM_FilteredSystemUser = 'Select * from FilteredSystemUser where

businessunitidname = + Spain +

 and CRMAF_FilteredSystemUser.isdisabled = 0 

 and eu_reporthubname is not null

 and CRMAF_FilteredSystemUser.eu_securityrole LIKE ('+% Doc %+')'


eu_securityrole LIKE ('+% Doc %+')'       AND  businessunitidname = + Spain +

Sorry ... it works like that below... I just don't know the correct way to write it in dynamic sql


where businessunitidname = 'Spain'

 and CRMAF_FilteredSystemUser.isdisabled = 0 

 and eu_reporthubname is not null

 and CRMAF_FilteredSystemUser.eu_securityrole LIKE '%RAM%' 

View Complete Post

More Related Resource Links

Write Custom WebParts for SharePoint 2007

The popularity of SharePoint Portal Server 2003 led Microsoft to tightly integrate the next SharePoint version, Microsoft Office SharePoint Server (MOSS) 2007, with its ASP.NET 2.0 WebPart framework. This tight integration enables the ASP.NET and SharePoint developer to do a number of things that previously weren't possible

Serial Port Communication Read and Write using C#.net

In this simple article you will learn that how you can Open and read COM port data using System.IO.Ports Namespace.
Simply just create New Project of windows application in C#.

Import ServiceProcess APIs
using System.IO.Ports

Imports System.IO.Ports

Write Parsing functions which parse port data according to attached device

Does this look correct for saving a file/ new record to a database


So thank you for all your help so far, So I think i got this right,
but would like for you all to look it over to see if there is any
areas I might run into trouble with:

//using asp.net mvc 2
the table (sql server 2005, using entities framework)
table fields
"Pattern_Media_GUID  uniqueid 
"Pattern_GUID  uniqueid
"Media varbinary(max)  
"height int
"Width int
"Media_Type String (50)

the form:
<h2> Add Media to this pattern</h2>
<% Html.EnableClientValidation(); %>
<% Html.BeginForm("AddMedia", "Pattern", new { id= Model.Pattern_Guid} , FormMethod.Post, new {enctype = "multipart/form-data"}); %>
    <%: Html.Label("height") %>
    <%: Html.TextBox("height") %>

    <%: Html.Label("width") %>
    <%: Html.TextBox("width") %>

    <%: Html.Label("Media") %>
    <input type="file" id="Media" name="Media" />
    <input type="submit" name=

How to write SQL Datasource programatically in VB


Can someone pls help me to rewrite this programatically!


<asp:SqlDataSource ID="DS" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                SelectCommand="SELECT * FROM [Products] WHERE ([ProductID] = @QSID)">
                    <asp:QueryStringParameter DefaultValue="" Name="QSID" QueryStringField="ID"
                        Type="Int32" />


Thank You in advance!


How to write xml file?


I am having a three text box. I want to write the fields given in text boxes to xml file and the xml file should be open as save dialog box for the user to download the xml file. I want without saving the xml file in the physical path of the server 
Any idea let me know?


I am having a three text box. I want to write the fields given in text boxes to xml file and the xml file should be open as save dialog box for the user to

How to write in .dbf file with c#


Hi all

can anybody help me to solve my problem : writing in .dbf  , as following is my code with this error :

[ ERROR [07002] [Microsoft][ODBC dBase Driver] Too few parameters. Expected 3 ]


SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=test;Integrated Security=True");
        SqlDataAdapter da = new SqlDataAdapter("select * from test", cn);
        DataSet ds = new DataSet();
        da.Fill(ds, "test");
        string odbccon = "Dsn=TEST.DBF;dbq=E:\\FOX;defaultdir=E:\\FOX;driverid=533;fil=dBase 5.0;maxbuffersize=2048;pagetimeout=5";

        OdbcConnection connection = new OdbcConnection(odbccon);
        OdbcCommand createCommand = connection.CreateCommand();

        createCommand.CommandText = "CREATE TABLE test (ID int, name varchar(50),last_name varchar(50))";

Willing to Write Urdu in my text box


 hi want to write urdu in text box of my application if anyone has the solution how to do this kindly let me know

Correct me with report.setDatabaseLogon and .setDataSource


Hi All,

I was getting a load report failed error on the server before (locally it was working fine). I tried everything one of the solutions that helped me partially was adding below lines to the code.

 ext.SetDatabaseLogon("UserId", "Password","DataBaseTest","ServerName");

When I add the above Line to Local Mechine it is working fine and returning data.(Records)

But When I publish this code to server I am getting a screen that has

Server Name : Filled

DataBaseName : EMPTY

UserName :Filled


screen and I am unable to enter the databaseName.

Scenario 2:


ext.SetDatabaseLogon("UserId", "Password","DataBaseTest","ServerName");

 When I add these 2 lines to local mechine all the crystal report with heading and date is coming up but the data from the sql server is not appearing. Actually this is loading the report correctly but unable to get the data from the data base. (Not displaying any records although it is supposed to display 100 Recs)

When I deploy it to the server it is acting the same way.Displaying the record with heading , date, page number etc, but no data

Do you know what should I do to

Crystal Report gives System.AccessViolationException: Attempted to read or write protected memory. T


when a crystal report for same id is opened again at same time or refreshed then it gives the

"System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt."

Stack Trace is :-

Stack Trace:

[AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.]
CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetConnectionInfos(ConnectionInfos ConnectionInfos) +0
CrystalDecisions.CrystalReports.Engine.Table.ApplyLogOnInfo(TableLogOnInfo logonInfo) +362
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetTableLogon(Tables tables, String user, String password, String server, String database, Boolean ignoreCase) +258
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDatabaseLogon(String user, String password, String server, String database, Boolean ignoreCase) +204

{ End Bracket }: Engineers Who Write


Writing is good exercise for developers and software engineers. Richard Ward explains how writing can help you focus your thoughts and communicate more precisely.

Richard Ward

MSDN Magazine November 2008

Write On!: Create Web Apps You Can Draw On with Silverlight 2


We build a Silverlight 2.0 application using the InkPresenter to let users annotate a pre-defined collection of images, perform handwriting recognition, and save the annotations and recognized text into a server-side database.

Julia Lerman

MSDN Magazine August 2008

Mobile WCF: Write an IM App with the .NET Compact Framework


The .NET Compact Framework 3.5 provides a subset of Windows Communication Foundation (WCF) functionality that you can harness to communicate between Windows Mobile devices and desktop PCs. We'll show you how.

Andrew Arnott

MSDN Magazine Launch 2008

Share Code: Write Code Once For Both Mobile And Desktop Apps


If you're building .NET client apps already, target them to Windows Mobile using the same skills and toolsets.

Daniel Moth

MSDN Magazine July 2007

.NET Profiling: Write Profilers With Ease Using High-Level Wrapper Classes


Here Joachim H. Fröhlich and Reinhard Wolfinger show you how to get all the great functionality of the .NET Profiling API the easy way, with custom wrappers.

Joachim H. Fröhlich and Reinhard Wolfinger

MSDN Magazine April 2006

Wandering Code: Write Mobile Agents In .NET To Roam And Interact On Your Network


In artificial intelligence, an agent is a logical entity that has some level of autonomy within its environment or host. A mobile agent has the added capability that it can move between hosts. In this article Matt Neely brings mobile agents from the halls of academia to a dev shop near you.

Matt Neely

MSDN Magazine February 2006

Unit Testing Tips: Write Maintainable Unit Tests That Will Save You Time And Tears


Everybody's talking about unit testing and you want to get into the game too. But you don't want the tests to take up all your development time and energy. Fortunately Roy Osherove is here to dispel some testing myths and put you on the road to efficient unit testing.

Roy Osherove

MSDN Magazine January 2006

C++: Write Faster Code with the Modern Language Features of Visual C++ 2005


The next version of Visual C++ has a new syntax that is both elegant and powerful. It has new optimization technology that has improved the speed of Microsoft. It has new compilation modes that ensure Common Language Infrastructure compliance and verifiability for the .NET Framework, and it has new models for interop. In this article Stephen Toub explains these and other improvements to Visual C++.

Stephen Toub

MSDN Magazine May 2004

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend