Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft SQL Server


XML Boolean value to SQL Server BIT  

I am working on an application written in Visual FoxPro 7 that produces an XML file of a recordset. One of the fields in this XML file is type="xsd:boolean" with a value of "false". My application then calls... Continue Reading
Views : 145
Monday 26th of November 2012

How to select from a table that's 'named' in another  

I'm trying to do a select on one of a dozen tables, but I don't know which table to use until I look it up in another. However, even once I get the string that names the table I want from a subquery, I don't know how to access it? eg: select * from ( select Tablename... Continue Reading
Views : 142
Monday 26th of November 2012

Just A Little Help!  

Hi guys! I'm new with SQL. SQL is running in my computer 'cause I can see the icon on the taskbar but when I open SQL Enterprise Maneger and try to Run a Wizard or Create a new Database by clicking the buttons on the toolbar it does nothing. I'm running win xp and SQL v7. Any help? Thanks! Continue Reading
Views : 79
Monday 26th of November 2012

SQL Server 2000 Installation  

Hi I have SQL Server 2000 Standard Edition. My question is do I install it on a Client machine or a Server machine or on both? Any help would be really appreciated. Continue Reading
Views : 122
Monday 26th of November 2012

select Top 3  

SELECT Country, CatDescription FROM VIEW1 WHERE (Country IN ('hong kong', 'LA')) GROUP BY Country, CatDescription ORDER BY Country Country Category... Continue Reading
Views : 122
Monday 26th of November 2012

Combining queries  

I need help combining two queries. Doing a 'UNION' displays the data as follows: 1 4786.54 1 78371.00 2 1082.53 2 11695.65 Instead, i want my data displayed as 1 4786.54 78371.00 2 ... Continue Reading
Views : 84
Monday 26th of November 2012

two databases  

I have two databases inside sql server 2000 both have access 2000 as the GUI user interface. How can I make an interface between the two of them. Like a command button that take you to a table in a different database how do I go about doing that??? can anyone help??? Continue Reading
Views : 195
Monday 26th of November 2012

counting records  

Hi, first: sorry because of my bad language, but I?m not a native speaker... I?m a beginner in sql an asp. I need to create a report and would like to do it with asp. I have two tables. In table1 I need to count all records with the same id. The id of the... Continue Reading
Views : 150
Monday 26th of November 2012

Order my data alphabetic in arabic  

How can we order our result alphabeticly in arabicwithout using Collation ? for eg: select * from Instructions_ar order by INST_title Continue Reading
Views : 144
Monday 26th of November 2012

Is that possible to delete the SA userid  

in sql server?how about if i created another administrator level id, and delete this one? Continue Reading
Views : 178
Monday 26th of November 2012

Querystring  

I'm trying to update one column from one table, but I need the information from other table to update it.So my querystring is like thisUPDATE InventoryStockTotal,... Continue Reading
Views : 159
Monday 26th of November 2012

%20 in SQL db  

mySQL1 = "Delete FROM bookmarks WHERE url = '" & url & "'" im using the query above to delete bookmarksbut some of them in the db have %20 between spacesand the one its checking against on the webpages does not. how can i make the query string... Continue Reading
Views : 131
Monday 26th of November 2012

Generate SQL  

Hi. My host cut off all connectivity to MS SQL server via E nterprise Manager, Web Matrix etc. Because of mis use by some of their customers. And They provided a web based db admin title ASP.Net Enterprise Manager for us to use. This program is fine but I need the functionality of MS EM. So I... Continue Reading
Views : 32
Monday 26th of November 2012

backup log **** with no_log  

I have a large Transformation file and I would like to do a backup of the data files without theTransformation files. I have tried using the above command "backup log sbrdb with no_log" with nosuccess. My recovery model is full. Are there any suggestions on why it did not work? Continue Reading
Views : 148
Monday 26th of November 2012

How to insert a banner between news  

I get a news-list with 4 items back from a SQL-query. That already works fine. Now I want to insert a banner after the 2nd news. Let's keep it simple, if blnBanner = true then how can I do it? Continue Reading
Views : 173
Monday 26th of November 2012

osql command  

All: I'm trying to run a SQL job via 3rd party scheduling software. (CA Workload Manager) I can start the job by executing osql -E -Q"exec msdb.dbo.sp_start_job... Continue Reading
Views : 121
Monday 26th of November 2012

How to make it work when the server isnt where i am...  

Hi.I am a total newbie to this so please excuse my dumbness I am renting webservices from somewhere and have a website going there. I have made a... Continue Reading
Views : 239
Monday 26th of November 2012

Easy one for you (Maybe)!!  

I am a fairly advanced Access user and thought it was about time to start playing around with MSDE. I have come across a little problem, which I?m sure will be so obvious, but I have hunted high and low and can not find the answer?The... Continue Reading
Views : 124
Monday 26th of November 2012

Datetime condition in 'where' - international problem  

I use datetime condition in sql-query. For example: select something from sometable where date between '06/15/04 00:00:00' and '06/15/04 23:59:59' and result on two synchronized servers is different. In USA server result contains where date equal... Continue Reading
Views : 126
Monday 26th of November 2012

SQL Views - self reference  

Hi, I would really appreciate your help on this: -I have a view vw_VIEW1 with fields AAA and BBB, which are based on some external tables using SELECT Statements. -trying to calculate a third field CCC so that CCC=somefunction(AAA,BBB), but the view won't let me because... Continue Reading
Views : 60
Monday 26th of November 2012

How to trap error for duplicate key  

Hi,With VFP, I have created a Form based on remote view of a table in MS SQL Database, that have a primary key.If the record is new, after I have enter the primary key, I need to control if the code exist already.I have not... Continue Reading
Views : 184
Monday 26th of November 2012

How to execute DTS package from ASP  

Hi, all.Please, help!I don't know how to execute DTS package from ASP application.I need some sample code.Thanks a lot. Continue Reading
Views : 113
Monday 26th of November 2012

Running SQLserver general Function using scripts  

2 functions i need to perform by using scripts :clear connection (in detach db option) and setting server authentication mode (either windows only or windows and sqlserver)how do i run these functions in scripts ? or should i just call the stored procedures in master db?? which sp... Continue Reading
Views : 175
Monday 26th of November 2012

Alter Table  

i use the statement below to add a column it will work but when i wanna drop that column it wont work "ALTER TABLE LA_LeaveBalance ADD abc SMALLINT NOT NULL DEFAULT 3" whereas if i... Continue Reading
Views : 34
Monday 26th of November 2012

Selecting a specific row  

right now, i use "SELECT TOP 1...". If i wanted to get the second, and only second row, what would i have to do? "SELECT TOP 2" selects the top 2, instead of just the second. Help anyone? Continue Reading
Views : 122
Monday 26th of November 2012

DTS Beginner question  

In order to learn how to create some DTS packages I created a text file to transfer to a test table. I added text file and SQL Server connections to my package and a transform data task connecting them. A simple 1-1 transfer of each column worked fine. Then I added some test code to try... Continue Reading
Views : 185
Monday 26th of November 2012

Permission issue with DTS and ASP  

Please, help me. I am calling a DTS Package from an ASP page using stored procedure and xp_cmdshell.DTS package transfers data from SQL tables to excel files to network shared directory. I am getting a access denied error when the DTS package fails. I used the UNC path for the Excel files... Continue Reading
Views : 142
Monday 26th of November 2012

ORA-12560: TNS:protocol adapter error  

hi ppl, i tried to connect oracle server installed in a remote machine located in the same network and oracle client is installed in my local machine. when i try to execute the SQL statements from my client machine i am experiencing the following problem :- ERROR: Continue Reading
Views : 155
Monday 26th of November 2012

Auto number an existing field  

I have a table with a int auto inc field. I updated the table with over 1000 records. I created a field called LeadNumber. I want to write a script to run in query analyzer that will start at the number 1 for the first record and increment by 1 until all records are updated. So lets say I have... Continue Reading
Views : 129
Monday 26th of November 2012

Some questions  

I would like to ask a very basic question. I installed MSDE 2000. I would like to know the following basic things: 1) After installation, do I need to configure something on MSDE? All I did was: (1) Control Panel >>> Administrative Tools >>> Local Security Policy >>>... Continue Reading
Views : 163
Monday 26th of November 2012