Microsoft SQL Server Forum

I am new to SQL and just inherited a sql database that has 3 encrypted columns. I need to export the data in those columns but it appears that everything is encrypted. I have done a lot of of googling but am unable to find any info on how to encrypt the columns if you dont know how the data was encrypted in the first place of any of the...

My understanding from these MSDN pages ({CONCAT (Transact-SQL)}, {+ (String Concatenation) (Transact-SQL)} & {SET CONCAT_NULL_YIELDS_NULL (Transact-SQL)}) is that the + will propagate NULLs, where the server's CONCAT_NULL_YIELDS_NULL property is set to ON as mine is, whereas CONCAT() will convert them implicitly to empty strings. My code, a...

one of my SQL database corrupt. and i dont have any backup ......i got the bigest prob. i tryed to repair will all the 'DBCC' command but none of those works.. i tried 'dbcc checkdb', 'dbcc CHECKALLOC', 'DBCC CHECKTABLE' but none of this find any problem. is there any extra tools or other command to repair MSQL 7.0 Database. please helpppppp...

I have a problem understanding how/why T-SQL refuses the following line within a View : IIF(..='C',IIF(..,'P',IIF(..,'Q','N')),..) AS Error: Error in list of function arguments: '=' not recognized. Unable to parse query text. It seems to be that, unlike when processing the same code in Access, it cannot, or will not, resolve expressions...

Can you tell me why this CAST(ExtensionData AS nvarchar(10)) AS Expr1 results in an error "Data type mismatch - no conversion possible"? is an ntext column. This error pops up SQL Server Management Studio when I am editing a view; if I ignore it and run the view anyway, it pops up again. It also happens if I use CONVERT instead of...

Hi I am new to SQL coding - need some advice I have data with dates but the dates I have are currently "YYYYMMDD" which is fine and I don't want to change But the data I wish to bring back needs to be data from the last 7 days So

Hi, everybody Prompt please, MS SQL 2012 on the virtual computer. Backup of all section with bases every day, at 19.00. That is, for every day I have the file copy .MDF and .LDF. Is there a way to recover the database at a certain time? Not 7 hours, but for example at 12.00. If I just attach the base then at the start I get an error about the...

I have multiple users using an Access front end plugged into a SQL Server back end. I want something that identifies the user's session to SQL server. I've tried @@SPID and found that there can be multiple values when connecting from the same session of Access. Equally, login and user names/IDs are not reliable as it's perfectly possible...

I am wanting to replace "in stock", "low stock" and "out of stock" with Values of "20" , "2" and "0" my software only allows me to do one expression at a time. I wanted to know if this is possible and if so how?

dear all, I have 2000 rows in my table and i want to have subtotal after every 20th row could anyone help me i do not know how to do it. thanks in advance.

Hi, I wonder if someone could advise on the following. I inherited this code, I am not a coder but have had some kind of hack and am looking at code to reduce its vulnerability. At the top of the page I have nPage = CLng(Request.QueryString("Page")) Keyword = Trim(Request.QueryString("Keyword")) in the where clause I have

Hi, I wonder if anyone could help. I have been hacked and one field in my database has had html and links added after the original content. http://www.website.com</title><style>.ajbv{position:absolute;clip:rect(481px,auto,auto,446px);}</style><div class=ajbv><a href=http://ma I need to remove everything after and including the title to...

Hello, this is a two part question 1) Can someone recommend a way to automatically backup SQL and mysql databases? Preferably if there is an online service (free or paid). Would be nice if the software or website could handle SQL and mysql. I am currently hosting my .net MVC 3.0 application hosted on asphostportal.com. We are in the final...

I set up a Web Service Task in SSIS with the following Server URL: http://www.webservicex.net/globalweather.asmx?WSDL, Service:Global Weather, Method:GetCitiesByCountry Output File:WeatherOutput.xml. It runs fine and produces the data, but contains control characters. Instead of < and >, it shows &lt; and &gt;.

i got this question in an interview! lats say i have a below table and i want to fetch the rows only till the period is currently active (all the rows above including Active Period = 1). if Active Period = 1 that means it currently Active.Query has to be dynamic lets say if the Active Period changes later then it has to fetch the rows till...

Viewing them both on the screen yields 2 different sizes (object browser says (5), sp_help says (10))....no there have not been any recent changes so I do not need to refresh the view of the object browser. Any one know why the difference? Thanks!

I know that users can be given permission to access the database to select data from database as shown below. But doing this for each user in the user table would take ages.. is there any method i could do this for all users in the user table I want to give all of them roles to allow them to read certain tables only.. any ideas how this can be...

I am new to sql server I have web application in asp.net 4.0 with code in vb.net I am saving data for example: hr & safety When i save data in sql server 2008 R2 and retrive it in my web forms it shows hr amp safety what is it? how can i solve it? and what if i want to replace & with simple and?

Hi, I'm having problems with databases that are getting corrupted. I have a server that runs a SQL Anywhere 11 database. (the consolidated database). Beside that, we have about 15 remote databases that run on the laptops of my mobile workforces. To keep all databases in sync, I have setup a two-way server-to-laptop replication.

Hai all, I have to select the data from sql server table which is in following format. Ex table Name : sample The table sample has one column named as Text and the datatype of that column is nvarchar(20). so in that column i have a data like:

I've searched around for help on this but everything I find seems to be a discussion about the relative benefits of using, or not using, this setting. I want to specify in SQL Server that ZLSs are not acceptable in the field whether or not NULLs are allowed. If ever I have to deal with an empty-looking value I want to know it's NULL rather...

Dear all, I am currently undertaking an academic project to design & build a Web Application (using HTML5 and open standards) that will require a data storage method and a means of serving the data to the Web Application. Data will include items such as simple statistics in numeric format and information in text format. I am considering...

If i make any changes(Insert/Delete/Update)in a site then the corresponding changes will store in tables of that particular DB. How to know on which table which operation(DDl/DMl)has done. I would like to store DML activities on Database level in a table,not on perticular Table, Please help

I am trying to loop through my counter to create a dynamic sql query which should finally look like I am trying to use this approach to get the final query but doesnt seems to work declare @CurrentRow int set @CurrentRow =0; declare @RowsToProcess int declare @FinalHistoricalQuery varchar(5000) WHILE @CurrentRow<3 BEGIN

Below is a screenshot of my sql code and results where I've been trying to join 3 tables. I need to find the number and name of each customer that currently has an order on file for a Gas Range. I've included screenshots of the data as well. Any help you can give me with this most difficult problem will be appreciated. ...