Search Results

Search found 6257 results on 251 pages for 'columns'.

Page 89/251 | < Previous Page | 85 86 87 88 89 90 91 92 93 94 95 96  | Next Page >

• Encrypt column names of tables in SQL SERVER EXPRESS

  - by Josh

  Hello, What is the best way to encrypt columns in SQLSERVER 2005 EXPRESS edition so that no one can steal our database design? Thanks

  Read the article

• Have anyone ever create/manipulate a table application from the ground up/scratch?

  - by Darwin

  Have anyone ever create/manipulate a table application from the ground up/scratch? I want to create a table using flash AS 3. I like to have the features like to the MS Studio Web Developer option. The options are create a table, merge cells, split cell, resize columns, delete cell, delete row, delete column etc... I think this is going to be very…

  Read the article

• compare date split across colums

  - by alex-tech

  Greetings. I am querying tables from Microsoft SQL 2008 which have date split across 3 columns: day, month and year. Unfortunately, I do not have control over this because data is coming in to the database daily from a 3rd party source in that format. I need to add between to a where clause so user can pull records within a range. Would be easy…

  Read the article

• Encoding regarding Term::Size

  - by sid_com

  Hello! The Term::Size-module jumbles up the encoding. How can I fix this? #!/usr/bin/env perl use warnings; use strict; use 5.010; use utf8; binmode STDOUT, ':encoding(UTF-8)'; use Term::Size; my $string = 'Hällö'; say $string; my $columns = ( Term::Size::chars *STDOUT{IO} )[0]; say $columns; say $string; Output: Hällö 140 H?ll?

  Read the article

• Need an efficient algorithm solve this kind of complex structure

  - by Rizvan

  Problem Statement is : Given 2 Dimensional array, print output for example If 4 rows and 6 columns, output would be: 1 2 3 4 5 6 16 17 18 19 20 7 15 24 23 22 21 8 14 13 12 11 10 9 I tried it is looking like square within square but when I attempted this problem, I…

  Read the article

• DataSet Schema sync.

  - by np

  Here is my scenario: I have a DataSet1 that i load from a DataSet1.xsd which has a few datatables. After laoding the DataSet1 we add data to it and serialize it and save it to a file. But the next day we make changes to the schema of the dataset for example added a couple of columns to the schema. Now when we load the existing DataSet from the…

  Read the article

• UPDATE statement wrapped in an IF EXISTS block

  - by formica

  I'm trying to write a DML script that updates a column but I wanted to make sure the column existed first so I wrapped it in a IF EXISTS block IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Client' AND COLUMN_NAME='IsClarityEnabled') BEGIN UPDATE Client SET IsClarityEnabled = 1 WHERE ClientID = 21 END So the…

  Read the article

• How to generate a script for changing a column of varchar to xml type with data being converted?

  - by user1323981

  Initially I have a column (partner_email) of varchar.Now a recent change has come where it needs to be changed to be changed to the XML type but the previous records needs to be reserve into the new column. I have applied the below algorithm to accomplish the work /*********************************************************************** …

  Read the article

• Delete from empty table taking forver

  - by Will

  Hello, I have an empty table that previously had a large amount of rows. The table has about 10 columns and indexes on many of them, as well as indexes on multiple columns. DELETE FROM item WHERE 1=1 This takes approximately 40 seconds to complete SELECT * FROM item this takes 4 seconds. The execution plan of SELECT * FROM ITEM…

  Read the article

• putting data from a for loop into a table using matlab and fprintf

  - by user2928537

  I am trying to put the following data from my for loop into a table formatted so that there are 11 values of F in each column, with a total of 4 columns. but I am always ending up with one long column of my data instead of the four columns I want. I was wondering if there is some way to put the data into a matrix and then reshape it,…

  Read the article

• Select distinct ... inner join vs. select ... where id in (...)

  - by Tonio

  I'm trying to create a subset of a table (as a materialized view), defined as those records which have a matching record in another materialized view. For example, let's say I have a Users table with user_id and name columns, and a Log table, with entry_id, user_id, activity, and timestamp columns. First I create a materialized view…

  Read the article

• Merging DataTable(s) Column by Column.

  - by Omky

  Hello All, I want to merge two or more DataTables Colum by Column. I am developing C# Windows Application. My use case is below: I have empty data grid in my application. user will drag and drop one column from available column list box into data grid. The data grid will start displaying data for that column. Now, I will drag…

  Read the article

• One input file to multiple output files

  - by user1265669

  I found some helpful stuff on this site but my input file is different from the examples already posted and I cannot make the leap in an efficient manner. My input file looks like this: sample_dude data1 data2 data3 data4 sample_lady data5 data6 data7 data8 sample_dude data9 data10 data11 data12 sample_child data13 data14…

  Read the article

• Why isn't INT more efficient than UNIQUEIDENTIFIER (according to the execution plan)?

  - by ck

  I have a parent table and child table where the columns that join them together are the UNIQUEIDENTIFIER type. The child table has a clustered index on the column that joins it to the parent table (its PK, which is also clustered). I have created a copy of both of these tables but changed the relationship columns to be…

  Read the article

• best way of importing data into mysql

  - by every_answer_gets_a_point

  i have a table with 500,000 rows and about 10 columns that is in access how do i import it into mysql?

  Read the article

• Creating an AJAX Accordion Menu

  - by jaullo

  Introduction Ajax is a powerful addition to asp.net that provides new functionality in a simple and agile  way This post is dedicated to creating a menu with ajax accordion type. About the Control The basic idea of this control, is to provide a serie of panels and show and hide information inside these panels.…

  Read the article

• SSIS Lookup component tuning tips

  - by jamiet

  Yesterday evening I attended a London meeting of the UK SQL Server User Group at Microsoft’s offices in London Victoria. As usual it was both a fun and informative evening and in particular there seemed to be a few questions arising about tuning the SSIS Lookup component; I rattled off some comments and figured it…

  Read the article

• An XEvent a Day (19 of 31) – Using Customizable Fields

  - by Jonathan Kehayias

  Today’s post will be somewhat short, but we’ll look at Customizable Fields on Events in Extended Events and how they are used to collect additional information.  Customizable Fields generally represent information of potential interest that may be expensive to collect, and is therefore made available for…

  Read the article

• The penultimate audit trigger framework

  - by Piotr Rodak

  So, it’s time to see what I came up with after some time of playing with COLUMNS_UPDATED() and bitmasks. The first part of this miniseries describes the mechanics of the encoding which columns are updated within DML operation. The task I was faced with was to prepare an audit framework that will be fairly…

  Read the article

• SQL SERVER – Weekly Series – Memory Lane – #051

  - by Pinal Dave

  Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from…

  Read the article

• Solaris X86 AESNI OpenSSL Engine

  - by danx

  Solaris X86 AESNI OpenSSL Engine Cryptography is a major component of secure e-commerce. Since cryptography is compute intensive and adds a significant load to applications, such as SSL web servers (https), crypto performance is an important factor. Providing accelerated crypto hardware greatly…

  Read the article

• PowerPivot and the Slowly Changing Dimensions

  - by AlbertoFerrari

  Slowly changing dimensions are very common in the data warehouses and, basically, they store many versions of the same entity whenever a change happens in the columns for which history needs to be maintained. For example, the AdventureWorks data warehouse has a type 2 SCD in the DimProduct…

  Read the article

• PowerPivot and the Slowly Changing Dimensions

  - by AlbertoFerrari

  Slowly changing dimensions are very common in the data warehouses and, basically, they store many versions of the same entity whenever a change happens in the columns for which history needs to be maintained. For example, the AdventureWorks data warehouse has a type 2 SCD in the DimProduct…

  Read the article

• Solaris X86 AESNI OpenSSL Engine

  - by danx

  Solaris X86 AESNI OpenSSL Engine Cryptography is a major component of secure e-commerce. Since cryptography is compute intensive and adds a significant load to applications, such as SSL web servers (https), crypto performance is an important factor. Providing accelerated crypto hardware…

  Read the article

• SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies

  - by pinaldave

  A very common question which I often receive are: How do I find all the tables used in a particular stored procedure? How do I know which stored procedures are using a particular table? Both are valid question but before we see the answer of this question – let us understand two small…

  Read the article

< Previous Page | 85 86 87 88 89 90 91 92 93 94 95 96  | Next Page >