No announcements
Found 2248967 threads
-
0 Votes
Azyre SQL Data Sync between Row-stored table and Column-stored table?
I know that Power BI Desktop can analyze 100 million + data with nice performance at SQL Server Express Edition and column-stored ...Answered | 4 Replies | 721 Views | Created by Yoshihiro Kawabata - Friday, February 1, 2019 11:31 AM | Last reply by Yoshihiro Kawabata - Saturday, February 2, 2019 1:59 AM -
0 Votes
SQL Server peer-to-peer synchronize between table and data stored in XML
If you want to sync between a XML store (even it may be stored in a table column) to SQL database tables, ...Answered | 6 Replies | 7608 Views | Created by Glenn2654 - Monday, June 7, 2010 3:30 PM | Last reply by jigu2014 - Tuesday, June 8, 2010 5:24 PM -
1 Votes
Storing large data in a table column
LOB Type SQL Server Data Type Max.Answered | 8 Replies | 3559 Views | Created by Nenmeet - Saturday, December 24, 2011 10:41 AM | Last reply by Nenmeet - Friday, December 30, 2011 12:59 PM -
0 Votes
Data tables for SQL Stored Procedures
I created a single data table in Azure Mobile Services to handle the stored procedures.Answered | 7 Replies | 1343 Views | Created by Michelle McCabe - Saturday, September 20, 2014 11:20 AM | Last reply by Michelle McCabe - Tuesday, November 11, 2014 11:47 AM -
0 Votes
Storing large data in tables
selecting the data from the table takes about 30-40 sec.Answered | 3 Replies | 4917 Views | Created by H Kaur - Monday, September 3, 2012 5:05 PM | Last reply by Geert Vanhove DCOD - Thursday, September 6, 2012 8:30 PM -
3 Votes
how to share table between stored procedure?
Unlike temporary tables they are available to all SQL Server sessions until the table is destroyed/the creating session goes out of scope.Answered | 3 Replies | 7751 Views | Created by moshik.salem - Saturday, July 14, 2012 4:49 PM | Last reply by Ahsan Kabir - Saturday, July 14, 2012 8:46 PM -
3 Votes
Data table copy selected rows and columns
and the B table hase 5, like B1, B2, B3 ... .you can use the following query to copy data from desiered colums of table A into table ...Answered | 4 Replies | 10768 Views | Created by Sankar Jayavelu - Monday, April 2, 2012 9:48 PM | Last reply by Sankar Jayavelu - Tuesday, April 3, 2012 4:27 PM -
0 Votes
store email format in SQL server table column
'; WHILE @counterAnswered | 6 Replies | 902 Views | Created by Rishabh Patil - Thursday, February 12, 2015 7:35 AM | Last reply by SQLZealots - Thursday, February 12, 2015 9:06 AM -
0 Votes
Support for triggers for tables with clustered column-store indexes
Columnstore indexes are intended for data warehouses, and while I don't do data warehouses myself, I cannot say that a fact table is where I expect to find a trigger.Answered | 4 Replies | 2281 Views | Created by Michael_SQL - Monday, September 22, 2014 5:53 PM | Last reply by Michael_SQL - Tuesday, September 23, 2014 11:03 PM -
2 Votes
store new table data entities to sql server
Not a SQL Express hosted app - any LightSwitch app, regardless of the data source.Answered | 4 Replies | 3843 Views | Created by Steve Richter - Sunday, August 29, 2010 12:10 AM | Last reply by Steve Hoag - Sunday, August 29, 2010 2:38 AM -
0 Votes
Stored procedure to compare columns in two tables and values within the table
It has to validate the data in target table.Answered | 5 Replies | 2631 Views | Created by Fazlu - Sunday, February 14, 2016 12:51 PM | Last reply by Fazlu - Monday, February 15, 2016 9:58 AM -
0 Votes
execute sql statement stored in table
You can do insert into myTable (Col1) execute @Formula -- sp name and then update two last columns with values for ...Answered | 11 Replies | 7549 Views | Created by Nagy Anawar - Thursday, August 30, 2012 11:21 AM | Last reply by Naomi N - Wednesday, September 5, 2012 11:47 AM -
0 Votes
Storing data in two tables ...
It looks like your Orders table has TrnNo column and Transaction table has OrderID column.Answered | 8 Replies | 1341 Views | Created by StarterPro - Saturday, May 10, 2014 11:47 AM | Last reply by Naomi N - Sunday, May 11, 2014 3:44 AM -
2 Votes
use stored procedure to insert a row in a table with a lot of columns
Hi, I have a table that has more than 30 columns.Answered | 2 Replies | 3986 Views | Created by peter 9 - Wednesday, June 2, 2010 5:50 AM | Last reply by Sorna Kumar Muthuraj - Wednesday, June 2, 2010 7:34 AM -
0 Votes
Using a stored procedure to insert a row to a table with values from relational tables
Since there are foreign key relationships between Table1 and other three tables, you need to first insert values into the other three tables, retrieve ...Answered | 5 Replies | 4548 Views | Created by Woodenhousen - Friday, December 2, 2011 2:53 PM | Last reply by Woodenhousen - Monday, December 5, 2011 4:13 PM -
4 Votes
Combo boxes to store data in tables
I want to store data in tables by the means of combo boxes on a form.Answered | 9 Replies | 953 Views | Created by Carlos Fraile García - Monday, March 31, 2014 2:40 PM | Last reply by George Hua - Monday, April 7, 2014 5:09 PM -
2 Votes
How to store multiple rows in one table using a stored procedure and parameters?
The code I posted above is the one without the parameters and it's not using a stored proc, what I want to happen is convert it using a stored procedure while still being able ...Answered | 6 Replies | 4416 Views | Created by randelramirez1 - Monday, February 13, 2012 7:30 AM | Last reply by Leo Liu - MSFT - Wednesday, February 15, 2012 9:52 AM -
0 Votes
how to insert single row in parent table and multiple rows in child table via stored procedure
1) Having two statements within a stored procedure (you can use BEGIN TRAN to validate integrity) 2) Having a trigger on Orders table to insert the data ...Answered | 1 Replies | 1849 Views | Created by rasol - Tuesday, June 11, 2013 6:24 AM | Last reply by Uri Dimant - Tuesday, June 11, 2013 6:58 AM -
0 Votes
SSIS: Required excel columns should be store in three tables, doesn't store excel all columns in all tables
Excel columns are seperated into three tables perfectly.Answered | 8 Replies | 1954 Views | Created by vsp.santu - Thursday, April 4, 2013 6:39 AM | Last reply by vsp.santu - Thursday, April 4, 2013 9:49 AM -
0 Votes
Table Parameter of Store Procedure Limitation
The group data need match is vary from few to several hundred thousands rows.Answered | 2 Replies | 5364 Views | Created by TravelMan - Tuesday, May 31, 2011 2:31 PM | Last reply by TravelMan - Thursday, June 2, 2011 9:58 PM - Items 1 to 20 of 2248967 Next ›
No announcements