What kind of encryption mechanisms does SQL Server 2008 Standard offer?
As I see, TDE and EKM mechanisms are available only in Enterprise edition. How can I encrypt data in tables in Standard edition of SQL Server 2008? ...
sql
adding count( ) column on each row
I'm not sure if this is even a good question or not. I have a complex query with lot's of unions that searches multiple tables for a certain keyword (user input). All tables in which there is searched are related to the table book. There is paging on the resultset using LIMIT, so there's always a maximum of 10 results that get withdraw...
how to specify literal value in linq union
I have the following SQL query, note I want the literal value '0' in the second field in the second SELECT statement from the ItemSale table. How do I express this in LINQ? I get the error message 'Invalid anonymous type member declarator'. SELECT BranchNumber,QuantitySold FROM Department UNION SELECT BranchNumber,0 FROM ItemSale How...
two sql queries in one place
<?php $results = mysql_query("SELECT * FROM ".TBL_SUB_RESULTS." WHERE user_submitted != '$_SESSION[username]' AND home_user = '$_SESSION[username]' OR away_user = '$_SESSION[username]' ") ; $num_rows = mysql_num_rows($results); if ($num_rows > 0) { ...
NOT IN statement for Visual Studio's Query Builder for TableAdapter
Hi I want to realize a query with the Visual Studio 2008 build in Query Builder for a TableAdapter similar like following (MSSQL 2008): select * from [MyDB].[dbo].[MyView] where UNIQUE_ID NOT IN ('MyUniqueID1','MyUniqueID2') How do I have to set the Filter in my query in order to call it with the myTableAdapter.GetDataExceptUniqueIds...
Restoring a utf8 encoded database to an iso 1 server - effect on strings
We are doing a migration of our Sybase database that has a utf8 encoding to a server with iso 1 encoding. We are just using char and Varchar for our strings. Will doing backup and restore not truncate any strings? I was thinking that Char and Varchar are just single byte characters. ...
Help me with DB design
Hi, i'm developing text ads system. Some small clone of Google Ads Updated image so all field names would be seen if you don't seen diagram, click here Here is diagram with common tables. Basically make it short, advertiser can have up to 10 variant of same campaign with different text variations, can geo-target his ads and unique im...
Java: Prepare a statement without a connection
I'm trying to generate some sql files in my java application. The application will not execute any sql statements, just generate a file with sql statements and save it. I'd like to use the java.sql.PreparedStatement to create my statements so that i don't have to validate every string etc. with my own methods. Is there a way to use the...
Problem with nvarchar data with XML in SQL server 2005
Create table testxml (xmldata xml) declare @var nvarchar(max) set @var = N'الوفاق الوطني المخ' insert into testxml select @var After inserting , i am getting data from table like select * from testxml --------------------- ???????? Can you provide me the solution? ...
SQL Server 2005 RIGHT OUTER JOIN not working
I'm looking up access logs for specific courses. I need to show all the courses even if they don't exist in the logs table. Hence the outer join.... but after trying (presumably) all of the variations of LEFT OUTER, RIGHT OUTER, INNER and placement of the tables within the SQL code, I couldn't get my result. Here's what I am running: ...
Select multiple unique lines in MySQL
Hi, I've got a table with the following columns: ID, sysid, x, y, z, timereceived ID is a unique number for each row. sysid is an ID number for a specific device (about 100 different of these) x, y and z is data received from the device. (totally random numbers) timereceived is a timestamp for when the data was received. I need a ...
Using generic columns in a database - why?
I'm working for a company where our design team has elected to use "Field1".."Field10" as generic, future purposed columns. I have queried them as to the reason and was told that they are there in case we need them in the future. Has anybody heard of this practice? Is it wrong for my jaw to drop to the floor when I see something like th...
SQL Script To Generate a Database Dictionary **With Linked Fields**
I would like to generate a Data Dictionary for a SQL Server 2008 database that has one row for each field, and the following columns: table_name field_name data_type link_table (for when the field in question is a foreign key) link_field (for when the field in question is a foreign key) I can get the first 3 columns with something like...
Are conditional subqueries optimized out, if the condition is false?
I have a table foo and a table bar, where each foo might have a bar (and a bar might belong to multiple foos). Now I need to select all foos with a bar. My sql looks like this SELECT * FROM foo f WHERE [...] AND ($param IS NULL OR (SELECT ((COUNT(*))>0) FROM bar b WHER...
SQL Server 2008 alternative for SQL-DMO
Hi! I previously was using SQL-DMO to automatically generate scripts from the database. Now I upgraded to SQL Server 2008 and I don’t want to use this feature anymore since Microsoft will be dropping this feature off. Is there any other alternative I can use to connect to a server and generate scripts automatically from a database? An...
How to handle a single quote in Oracle SQL
How do I insert a record in a column having varchar data type having single quote in it? Example: first name is ROBERT and last name is D'COSTA ...
Use cases for NoSQL
NoSQL has been getting a lot of attention in the industry recently. I'm really interested in what peoples thoughts are on the best use-cases for its use over relational database storage. What should trigger a developer into thinking that particular datasets are more suited to a NoSQL solution. I'm particularly interested in MongoDB and C...
What is the most efficient way to read many bytes from SQL Server using SqlDataReader (C#)
Hi everybody! What is the most efficient way to read bytes (8-16 K) from SQL Server using SqlDataReader. It seems I know 2 ways: byte[] buffer = new byte[4096]; MemoryStream stream = new MemoryStream(); long l, dataOffset = 0; while ((l = reader.GetBytes(columnIndex, dataOffset, buffer, 0, buffer.Length)) > 0) { stream.Write(buffer,...
Normalizing data with DISTINCT
I have 1,000,000 rows per month per PC generated by some monitoring software. The DataToImport (temporary) table looks like this: EventID int NOT NULL (Primary Key of denormalized table) EventType int NOT NULL -- A enumerated value Computer nvarchar(50) NOT NULL -- Usually computer name When DateTi...
How do you set up a Report Server instance?
Hi, I'm trying to set up Microsoft SQL Server Reporting Services. I open the Reporting Services Configuration Manager, and it asks for a Server name. Thing is, I don't know the server name, because as far as I know haven't set a report server up yet. So, how do you set one up for Microsoft SQL Server 2008 R2? There seems to be plenty of ...