2,935 Topics
 | |
 | afternoon everyone, I am new to using MSSQL and need help with SUBSTRING function. i have a strings like below s2-Total Solids - Std Method V1E-RVT4/2.5@20degC Initial V1Y-LVT2/60@20deg Initial A2-Alkalinity - ISO Method(%) I would like to only get the data before the first "-" IE s2 V1E V1Y A2 … |
| | So how can you tell if you've maxed out express and need to move to the full blown version. Not referring to database size but performance? Asking because we are moving a website and the webhost master asked if he will be on express or full version claiming that express … |
 | HI I want to create new sql account in sql server 2005,and user only able view sql agent job history details only.How do I do this.Please help. Thanks Tank50 |
| | Hello everybody and thank you in advance for taking the time to read this. I am having trouble connecting to a remote MSSQL server from our web page server using the SQLSRV Connect. I have installed all the necessary php extensions and sql drivers, and they all appear as they … |
| | Team - This has to be way more simple that I am getting. Been searching google for hours with no luck. Simply stated, I am trying to delete a datalist row which is bound to a mssql database. Simple right! I am missing where it is putting the key or … |
| | |
| | Hi, I'm fresher for sql injection, i have already worked and having a good knowledge about the MY sql server 2000, 2005, and 2008. Did anybody can able to give me steps and how to work in sql injection, as a part of testing engineer. Kindly send me the links … |
| | IIf(Time()>=TimeValue("00:00:00");IIf(Time()<=TimeValue("07:00:00");Format(Now()-1;"dd mm yyyy");Format(Now();"dd mm yyyy"))) |
| | Okay, I have a table called InGameTime with the following columns: CharName varchar(30) InTime datetime OutTime datetime HH int MM int SS int I am trying to make a trigger, that will once data is updated, it will update the HH,MM,SS to add the total hours, minutes, seconds spent in … |
| | Column A (datetime) ----------------------- 2011-04-01 00:00:00.000 2011-04-01 00:00:00.000 2011-04-09 00:00:00.000 2011-04-01 00:00:00.000 2011-03-31 00:00:00.000 Column B (datetime) ----------------------- 2011-03-25 15:45:56.457 2011-03-25 15:52:37.933 2011-03-25 15:54:37.197 2011-03-25 16:05:30.023 2011-03-27 00:43:23.713 When i try to query the above record [CODE] Select * from table where A between '1900-01-01' and '2012-01-01' [/CODE] this work … |
| | Hi someone help in distinct command i have created 2 tables department and balance, 1. Department dep_id, dep_code, dep_name 2 001 Bloom Room 3 002 Tahmeco Th 4 003 Kniting 2. Balance dep_id, Date, Amount 2 01/Mar/2011 10000 3 02/Mar/2011 15000 4 20/Mar/2011 25000 3 22/Mar/2011 10000 2 26/Apr/2011 27000 … |
| | Hello to all, I got problem in my vb.net program in publishing it. I am using Microsoft Visual Studio 2008, when I publish my program and I got the setup file and when i tried to run into another computer I got some error saying that it cant connect into … |
| | Right now we're having an issue with SQL, it's currently using 1.7GB of memory, and with the size and usage of our application, this isn't always enough. The server it's on is a 32 bit Windows Server 2003 Enterprise Edition, with 15.9GB of RAM. Is there any way to break … |
| | Does anyone know how to turn this excel function into an sql statement? The function looks at my address and route. If it is different than the one prior it increments column G by 1 if it is the same it keeps column G as the same number. Ive been … |
| | I created the following tables and inserted few values. create table books(bookid integer primary key, booktitle varchar(20), year integer, publisherid integer foreign key references publisher(publisherid), price integer, number integer) create table publisher(publisherid integer primary key, publishername varchar(20)) create table author(authorid integer primary key, authorname varchar(20)) create table bookauthor(bookid integer foreign … |
| | Copy a table from one database to another database in another ms sql server using sql server management studio : If your table was in the same ms sql server but in another database, you would copy it using t-sql like this : SELECT * INTO NewTable FROM existingdb.dbo.existingtable; However, … |
| | Hi everyone, I have a huge problem with importing data into Microsoft SQL server 2008. First of all I have created the database with the foreign keys etc. And now I want to import data. I have used BULK method i.e. [CODE]BULK INSERT tablename FROM 'c:\tablename.txt' WITH ( FIELDTERMINATOR = … |
| | in a table having the fields of starttime & endtime ,I want to fetch only the records having starttime & endtime of same days.  |
| | create table #TempRouting( id int, routetype char(4), routesequence int) insert into #TempRouting (id,routetype) values (1,'MON') insert into #TempRouting (id,routetype) values (1,'MON') insert into #TempRouting (id,routetype) values (2,'MON') insert into #TempRouting (id,routetype) values (3,'MON') insert into #TempRouting (id,routetype) values (4,'MON') insert into #TempRouting (id,routetype) values (5,'MON') insert into #TempRouting (id,routetype) values … |
| | I have a stored procedure that retrieves customer data from one table and calls 2 UDFs to perform a calculation on data obtained from joined tables for accounting data. The calculation needs to be performed for every row based on matching criteria of previous records. The query returns very few … |
| | I'm trying to run the following code but get a casting error. How can I rewrite my code to achive the same ? [CODE] boolResult= (bool?)dataReader["BOOL_FLAG"] ?? true; intResult= (int?)dataReader["INT_VALUE"] ?? 0;[/CODE] Thanks  |
| | I have 2 tables, MPW1400 LeaseRecNo PropNo BldgNo UnitNo LeaseStartDate MPW1482 LeaseRecNo EffectiveDate AnnualAmount CertNo My Objective is to get the total of 'AnnualAmount' Where MPW1400.LeaseRecNo = MPW1482.LeaseRecNo and CertNo = '1' Example: MPW1400 ------------------------------------------------------- LeaseRecNo | PropNo | BldgNo | UnitNo | LeaseStartDate ------------------------------------------------------- 12345 | RG52 | 24 … |
| | I have a view that pulls in a field, the feild has data in the following format. A1-an987389 B21-At081l0 AA1-ath01882 how would i get the infoamtion before the "-" IE A1 B21 AA1 the size of the data before the "-" can be anything from 1 up 5 charcters i …  |
| | Hi, I have replication configured on a SQL 2008 Database. The tables involved are something like this; [INDENT]tbl.Product ProductID Int ProductName NVarchar(max) ImageID Int FK_Product_Image FOREIGN KEY(ImageID) REFERENCES tbl.Image (ImageID) tbl.Image ImageID Int Image Image[/INDENT] tbl.Product is part of a Transactional publication with updatable subscriptions. tbl.Image is part of a … |
| | I have a program that works access 2003 and i convert tables to sql Server 2005, but the problem is that program works only on the server but does not work on client .the internal network is workgroup and system is Windows XP . what can i do to get … |
| | I'm having a hard time to return a string value. I usually do this by passing an int, which works just fine. Now, I need to pass a string but couldn't. Is this possible? Or int is only type that SQL can return? |
| | I have declared the datatyp of 'p_date' as datetime I have also used DateTextBox_CalenderExtender on textbox.(from Ajax ToolKit) [CODE] DateTime datetime=new DateTime(); datetime=convert.ToDateTime(DateTextBox.text); InsertIntoMrNo(mrNoTextBox.Text, datetime, postIdTextBox.Text); public void InsertIntoMrNo(string mrno, DateTime mrdate, string postid) { connection =ConfigurationManager.AppSettings["ConnectionString"]; sqlConnectionObj = new SqlConnection(connection); insertQuery = @"INSERT INTO mrno (mr_no,p_date,post_id) VALUES('" + mrno+"', … |
| | i want to create inset and update for following files after inserted updated Find1, varchar(499) Find2, varchar(499) Find3, varchar(499) i wnat to crate trigger if find1 and find2 are inseted ,unpdated then show message in find3 and not updated or inserted reset previous value |
| | any one know how to create trigger for update one column if column have value = 'cityname' then raise error or print error if value is null the don't do any thing |
| | I was required to have my ID number, which is the primary column of my table, to be formatted with date. Instead of having just a number incremented by 1 (identity(1,1)), I need to have something like 318111 that means March 18, 2011 and the last digit is incremented by … |
The End.