[microsoft:sql-server] Forum Topics

this open source thing I am using uses typical contains formsof inflections. I will post the exact syntax if you want. However, it does not do partial word search. How do I incorporate wild-card search with contains formsof inflections?

I have this form, and this antinjection. I have checked for anti injection in three places and it still is quite easily injectable. Code: [code]<?PHP $sql_server = "localhost"; //<-- MSSQL server address/ip $sql_user = "sa"; //<-- MSSQL username $sql_pass = "sa"; //<-- MSSQL password $sql_data = "database"; //<-- MSSQL database …

I have made connection in web.config file,Its working ,I want to just confirmed dat Whether i m doing it in right way or not! Web.Config File- [code] <configuration> <appSettings/> <connectionStrings> <add name="Connection" connectionString="Data Source=(local);Initial catalog=sonia;User ID=sonia;Password=sonia;" providerName="System.Data.SqlClient"/> </connectionStrings> [/code] Code Behind Page [code] public partial class FrmPractise : System.Web.UI.Page { …

I want to create a procedure which takes one input parameter(@name) and list all the fully or partially matching results. I used [code=sql]Select * from Table1 Where Name LIKE @Name[/code] but it didnt work. Can you help plz?

How can I add a check constraint to make sure that a date is equal to Today or within the last year and another check constraint to ensure that dateA is equal to dateB or earlier by a maximum of 3 days ?

hi, i have a problem,that is i have 2 datatables.in that tables item_id is uniqueidentifier and primary key column for both tables.remaing columns are diffrent columns.if i insert the data generate only item_id same guid for both tables,in remaing data is saved remaing columns.plz help me.i search a lot of …

i takes the current date value and then save it to text1.text Text1.Text = Format(Now, "m/dd/yyyy") then i am passing Text1.Text which actually contains date to Sql String which Delets all record that matches the Expiry date.. if current date = expiry date then delete that record.. strSQL = "DELETE …

So, i'm working on VB.NET application but I'm having problem with one MSSQL query. [CODE]SELECT ISNULL(Sezona.NogSezona, '') FROM Trener LEFT JOIN Licenca ON Trener.BrTrenerskeIskaznice = Licenca.BrTrenerskeIskaznice LEFT JOIN Sezona ON Sezona.IDSezona = Licenca.IDSezona AND Licenca.IDSezona=3[/CODE] This is the code I've been using 'til now, but it's not working as I …

I want to just bind the dropdown with DB,I have three rows in mine DB.Instead of adding the column data,In mine dropdown System.Data.DropDown is coming three times y So??? [code] using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; …

I've got the following tables : Em_table Em_No nchar(3) Primary key Em_type nchar(20) , (values it can be inserted into that column are 'P', 'T' and defaults to Work_table(w_type)) . . Work_table w_No ...... w_type nchar(20) values it can be inserted into that column are 'P', 'T' ) . . …

HI experts..I need ur help.. VB.NET category I need script that can be used to do settings for allowing SQL SERVER 2005 Express to allow remote connections. The settings that we do manually after installation [COLOR="Green"][B]i.e to enable TCP/IP in remote connection in Configration Manager , start Browser service, set …

hi friends I used these codes for restoring my DB.But it has error.plz help me. [CODE] string backupfile = "D:\\Backup.bak"; Server svr = new Server("."); Database db = new Database(svr, "library"); Restore rs = new Restore(); rs.NoRecovery = false; rs.Database = "library"; rs.Action = RestoreActionType.Database; BackupDeviceItem bdi = default(BackupDeviceItem); bdi …

I want to select multiple records from sql table and insert it to a dataset when the selected index is changed from a combo box. for example if i select "1" from the combo box then, only values with "1" in the sql table's mentioned column should be inserted into …

Hi All, Re-doing a giant, old, crusty sp. So here's a questions for all of you. I have two temp tables: #temp_acct_codes and #temp_hour_tracker. #temp_acct_codes contains these two columns in addition to a slew of others: week, hours, date_worked. #temp_hour_tracker contains week, hours_already_worked, 1_0_hrs, 1_5_hrs, 2_0_hrs, diff_hrs, eper_hrs, loc (different …

Hi, I have a table which was holding values in a text field in ISO-8859-1 format. I am wanting to convert this data to UTF-8. I started by changing the field type to ntext. Should I also need to pull out the data, re-encode it in UTF-8 and put it …

cmd = New SqlCommand(sql, myConnection) reader = cmd.ExecuteReader() While reader.Read() For Columns = 0 To reader.FieldCount - 1 Category = reader.Item(Columns) 'READ COLUMN FROM DATABASE cmbfld.Items.Add(Category) ComboRow += 1 Next End While this code is populating the records instead of the field name.what can i do pls?

I have made one crystal report.In which i hv used sql server 2005 db and ms access db .It works properly but it doesn't work with vb.net. I want to know how to make connection string for both db for a single report in vb.net.

hi guys I want know that whether is it possible that to implement Client - Server architecture by using SQL SERVER 2005 EXPRESS EDITION as a main server and on other client PCs also I have SQL SERVER 2005 EXPRESS EDITION . So can i connect to main server from …

I can't get my website to connect to the built-in db for ASP.NET login funtions (ASPNETDB.MDF). I've been trolling multiple forums for weeks now, and nothing seems to work. I've tried every combination I can think of but get some variation of 'cannot open database' or 'login failed'. Where am …

I am working with a third party program that sends data and files to a web based repository for our customers. I have rewritten the ASP side of things and cleaned that up but we have run across a problem. The internal (3rd party) software when sending files to the …

hi 'm aparna... Am developing a web application with j2ee and sql 2005 Express edition as the back end.. When i connect with the jdbc driver in system DSN and test the connection, the connection turns out to be successful, and when I run the application, the web page is …

hi, i developed an application ie web application using asp.net 2005(C#.net) and sql server 2000. It is used to store the data in database via excel sheet. ie application contains 3 buttons . if we click on button1 ,it opens the excel sheet and we can enter the data. button …

Hello, I have 10 lines of FileUpload (1-10) i have some problem during the upload event. When i put 10 files there is no problem and everything work fine. When i put 3 or 4 files i get error message. Looking for help / solution Pllllease. the message is: "Could …

Hello, I was created some website for digital printing solutions. users can make orders from a form in the website. All the order information and the files they are upload going to sql server the files NOT store in sql they are store in a server folder. Im tryin to …

can someone please check my code because it doesnt update my database.. i set the room no. as the primary key.. can you please help, its urgent.. i need it tomorrow.. thanks. [CODE]Dim con As New OleDb.OleDbConnection con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=..\data\YayaDB.mdb" con.Open() Dim query = "UPDATE Rooms SET …

So Im editing a page on my site, and I tried to edit a code, because I got an error... cant remember what it is right now, but anyways, I changed it and got another error, something about unexpected T_DNUMBER? Well I decided to change it back, and now I'm …

I am using the SQL 2005 Express edition for SQL server. The database resides on another server and I connect to it from my machine through the object explorer. I have created a trigger to run certain queries and updates, but can't seem to find the trigger listed under [QUOTE]MyDB->Programmability->Database …

i need to save doc file in sql database but have no idea to choose the field data type, i think it'll require binary data type. and how to save selected doc file from window based application using c#.net ,please share any solution regarding this....

Hello everyone, So, far i have worked on employee management system(sap - abap), inventory payroll system (C lang), Reverse engineering(assembly),Quiz (VB). Now i want to work on java so that i connect my project with any server file like Sql connectivity,ms access, ms excel etc (i don't know how to …

Hello; I am have written a few lines of programming code that returned data from a SQLBase database. This code has been running successfully without fail up until yesterday afternoon. No changes has been done to it, but the program now crashes with an Time Out Error on the OleDBDataAdaptor.fill …

Hi All! I am working with an MSSQL DB which stores images as blob's. When I pull out the blob it seems to be cut off at a fixed length. Every image only displays the top 1/3 or so. My query is very basic and has no limitations in it …

I want to create a procedure to update a table. It takes number of input parameters(one of them is the @pID) and updates four columns which have the pID=@pID and only one of these four columns can be updated if the value of another column='F' in addition to pID=@pID. How …

Hi, I have database connection problem. A part of the source is shown Below [code=csharp] private void Form3_Load(object sender, EventArgs e) { string connectionstring="Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\hospdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; SqlConnection con=new SqlConnection(connectionstring); DataSet ds=new DataSet(); string command="SELECT Name,Address,Phone,Branch,Class FROM hosptab WHERE (Branch = 'SKIN')"; SqlDataAdapter da=new SqlDataAdapter(command,con); da.Fill(ds,"hospital"); DataTable dt=ds.Tables["hospital"]; //da.Fill(hospdbDataSet, …

Hi, i am now want to insert data(fault and visual(bold)) into the table. After done the calculation, i would like to insert the fault and visual value into my table summary. My field name in table summary for fault(fo_ratio) and visual(visual) So below is my coding. How can i save …

I have been reading up quite a bit on the topic of Stored Procedures (SPs) and keep coming across contradicting opinions from various 'SQL experts' on whether or not they should be used. Sometimes it's a downright 'No' ([I]Frans Bouma's[/I] Blog for example -- google the term for the article), …

hello i want two table records in substring query table1 name (membermaster ) column names [B]mficode,centercode,membername[/B] values ex [B]045323,1061,shanthi[/B] table2 name (memberloanmaster) column names [B]loanrefcode ,centercode,closedate[/B] values ex [B]045323/1,1061,2009-04-03,[/B] both tables mficode and loanrefcode and centercode as comman, how do i select mficode and centercode and membername, compare with loanrefcode …

Hi I need to generate a CSV of names and address from a table and I would like only one result (it doesn't matter which) per distinct email address. If possible, they also need to be ordered by DateAdded descending so I can select just the most recent 1000 results. …

Hi Everyone, MY name is Philip I am a Programmer Analyst. BS in CIS. I am a mid level VB.NET programmer and MCITS Certified in SQL Server. Glad to meet everyone, PhilipJohn

I used COALESCE with LIKE in my query: [code=sql]WHERE Column1 LIKE '%' + COALESCE('Togas', Column1) + '%'[/code] apparently the rows with "[" and "]" characters are excluded from query result. is it possible to include those rows in the result? thanks in advance!

Hi I have three MS SQL 2000 Servers distributed as follows: (img Server 1: Name: JBCB_SRV1 OS: Windows 2003 SE DB: MS SQL 2000 Server SE MS SQL Replication: Publisher Source DB: Northwind Server 2: Name: WEB OS: Windows 2000 Server SE DB: MS SQL 2000 Server SE MS SQL …

Is there a way to isolate the nth record from a table using [U]sql queries alone[/U]? The table is a [U]non relational[/U] one and you cannot use any temporary tables...Do u think there is a possible solution for this in MS SQL Server 2000? Otherwise tell me whatever you know? …

hi this may sound simple but i can not get it to work i have try for about 5-6 weeks now and this my last hope all my project is to make a job dater base that workers can add jobs and cliences can see there job but i am …

Pls see my code.Nothing is displaying in the grid [code]Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connString As String = "Provider=SQLOLEDB;Data Source=MSALAMEEN;uid=sa;pwd=Sa1;Initial Catalog=Biometric" Dim myConnection As OleDbConnection = New OleDbConnection myConnection.ConnectionString = connString Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select ID from bdata", myConnection) …

Hai, I don know how to store data from datagrid to SQL database. I also don know how to find the number of records in dataset or datareader. for an example [B]myCommand = New SqlCommand("Select * from discounts", myConnection) dr = myCommand.ExecuteReader()[/B] How can I know whether there is any …

[CODE]// set up connection to the database myConnection = new System.Data.SqlClient.SqlConnection(); myConnection.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\Craig\\Desktop\\Project\\App_Data\\ASPNETDB.MDF;Integrated Security=True;User Instance=True;";[/CODE] Hi this is my above connection string which works fine on my personal computer. I need to move the entrive Project folder to a different location which will not have access to the …

Hi, In my DB I have 2 tables Units and Groups In Units I have Id Name In Groups I have Id Name UnitID This is my code [code] BMDataClassesDataContext db = new BMDataClassesDataContext(); TreeNode rootNode = new TreeNode("BM"); var n1 = from node in db.Units select node; foreach (var …

Hello everyones, I want to delete where my id has unique identifier in the table in my database.... how can I do it? Thanks

I have sqltable which has two fields category_id category_name 1 india 2 africa 3 china In front end i have 2 text boxes categoryid category name But the category id field is read only , i mean i am automatically incrementing it by one. Then i am displaying the data …

I'm writing my first program. It's a C# console program. I need to connect to a database I've created as part of the project in VS Express. I've added the tables as Data Sources for the project. I'm writing to ask about the basics of dealing with databases. Like what …

Is there anyone knows how to make either bar or pie graph in vb.net and getting the data on sql 2005. I need it for our thesis please help me on my problem. Thanks