DotNetShoutout - Stories tagged with SQL

SQL

atom rss
2
Shouts
spam Shout it Mute it

Windows Phone 7 (Mango) Tutorial - 24 - Local Database Support, CRUD operation with Demo © Kunal's Blog
posted by http://www.kunal-chowdhury.com/http://www.kunal-chowdhury.com/ 720 days, 14 hours, 54 minutes ago
Thursday, June 30, 2011 12:53:32 AM GMT
In the last two chapters of the tutorial series, we discussed about the local database support in Windows Phone 7 (Mango). We learnt how to create a DataContext class from existing SQL CE database and also we learnt about the issues that arises once we add the class file in the project to build. We learnt the steps to resolve those issues too. In this article, we are going to discuss about the CRUD operations that we can do using the DataContext class with a small application. We will learn how to creat... (more)
category: Metro | clicked: 3 | comment | | source: www.kunal-chowdhury.com
tags: Silverlight, WindowsPhone7, WP7, wp7dev, SQL, Tutorial, Database, mango
2
Shouts
spam Shout it Mute it

Windows Phone 7 (Mango) Tutorial - 23 - Local Database Support, Configuring Project © Kunal's Blog
posted by http://www.kunal-chowdhury.com/http://www.kunal-chowdhury.com/ 721 days, 13 hours, 39 minutes ago
Wednesday, June 29, 2011 2:09:06 AM GMT
Hope you read my previous post on Windows Phone 7.1 (Mango) local database support. If you didn't read the earlier post, you need to read it before reading this one. You can find it here: "Create DataContext". That will give you the basic context about the same. In this post (I will rather calling it as a Tip), we will configure the project by adding the generated DataContext class and in the next post, we will learn what are the various CRUD operations we can do with a sample application. That will giv... (more)
category: Metro | clicked: 4 | comment | | source: www.kunal-chowdhury.com
tags: Silverlight, WindowsPhone7, WP7, wp7dev, SQL, Database, mango
11
Shouts
spam Shout it Mute it

SQLAuthority News – Monthly list of Puzzles and Solutions on SQLAuthority.com « Journey to SQLAuthority
published 718 days, 18 hours, 43 minutes ago posted by pinaldavepinaldave 722 days, 7 hours, 23 minutes ago
Friday, July 01, 2011 9:04:59 PM GMT Tuesday, June 28, 2011 8:24:37 AM GMT
This month has been very interesting month for SQLAuthority.com we had multiple and various puzzles which everybody participated and lots of interesting conversation which we have shared. Let us start in latest puzzles and continue going down. There are few answers also posted on facebook as well. SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator This puzzle involves NULL and throws an error. The challenge is to resolve the error. There are m... (more)
category: Data | clicked: 124 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, Database, pinaldave, SQLAuthority
3
Shouts
spam Shout it Mute it

Easy Full-Text Search Queries
published 721 days, 6 hours, 53 minutes ago posted by http://jonathan-wood.myopenid.com/http://jonathan-wood.myopenid.com/ 723 days, 18 hours, 35 minutes ago
Wednesday, June 29, 2011 8:54:36 AM GMT Sunday, June 26, 2011 9:12:45 PM GMT
SQL Server's Full-Text Search offers powerful and efficient ways to search your data. However, the query syntax can be rather cryptic. It's bad enough for SQL programmers, but what if you want to allow your users to enter queries? Unless all your users are database experts, they won't know or understand syntax like FORMSOF(INFLECTIONAL, dogs) AND FORMSOF(THESAURUS, cats). Some time ago, I ran into the excellent article A Google-like Full Text Search by Michael Coles. T... (more)
category: Data | clicked: 13 | comment | | source: www.blackbeltcoder.com
tags: C#, SQL, Full Text Search
8
Shouts
spam Shout it Mute it

SQL SERVER – Solution – Generating Zero Without using Any Numbers in T-SQL « Journey to SQLAuthority
published 728 days, 18 hours, 4 minutes ago posted by pinaldavepinaldave 729 days, 6 hours, 5 minutes ago
Tuesday, June 21, 2011 9:43:33 PM GMT Tuesday, June 21, 2011 9:42:45 AM GMT
SQL Server MVP and my friend My friend Madhivanan has asked very interesting question on his blog regarding How to Generate Zero without using Any Numbers in T-SQL. He has demonstrated various methods how one can generate Zero. When I posted note regarding how one he has generated Zero without using number in my blog post for Free Online Training, blog readers have come up with few very interesting answers. I really found them very interesting and here I am listing them with due credit. Special mention ... (more)
category: Data | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
13
Shouts
spam Shout it Mute it

SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*) « Journey to SQLAuthority
published 746 days, 22 hours, 37 minutes ago posted by pinaldavepinaldave 749 days, 7 hours ago
Friday, June 03, 2011 5:11:01 PM GMT Wednesday, June 01, 2011 8:47:38 AM GMT
Try running SELECT * it will throw an error. Try running SELECT COUNT(*) it will not throw an error. Why? Read, Learn and Participate! (more)
category: Data | clicked: 116 | 1 comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
2
Shouts
spam Shout it Mute it

Import Excel Data into Sql Server Using SqlBulkCopy
posted by amitjainamitjain 749 days, 8 hours, 17 minutes ago
Wednesday, June 01, 2011 7:31:10 AM GMT
In this example i am going to describe how to Import or insert data into Sql server from Excel spreadsheet using sqlbulkcopy method. (more)
category: Web Dev | clicked: 5 | 1 comment | | source: csharpdotnetfreak.blogspot.com
tags: Excel Data, MSSQL, SQL, Excel, SQLBulkCopy, ASP.NET
9
Shouts
spam Shout it Mute it

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server « Journey to SQLAuthority
published 753 days, 6 hours, 31 minutes ago posted by pinaldavepinaldave 754 days, 9 hours, 27 minutes ago
Saturday, May 28, 2011 9:16:40 AM GMT Friday, May 27, 2011 6:20:29 AM GMT
SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS. Make sure you have SQL Server Agent Turned on as this feature will create a job. The same job will execute the task. Make sure that SSIS is properly configured as well with necessary security permissions. You can automate this process as well control error logging. Following are the steps to copy database from one instance to another instance. Specify Source Server Spec... (more)
category: Data | clicked: 39 | 1 comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
2
Shouts
spam Shout it Mute it

SQL Server Instead Of Trigger with Sequence Table Sample
published 760 days, 7 hours, 57 minutes ago posted by eralpereralper 762 days, 2 minutes ago
Saturday, May 21, 2011 7:50:32 AM GMT Thursday, May 19, 2011 3:45:43 PM GMT
Using SQL Server Instead of Trigger defined on a table in combination with a sequence table and T-SQL features like SQL Output clause and T-SQL Row_Number function I will show how to insert the identity column value of a table from the sequence table. I faced this sql problem while talking with a SQL developer friend of mine. He was required to use a sequence table in a Microsoft SQL Server 2008 database. Perhaps you already know, a new feature in Denali or SQL Server 2011 is SQL Sequence table usage. B... (more)
category: Data | clicked: 3 | 1 comment | | source: www.kodyaz.com
tags: SQL Server, SQL Server 2008, SQL, T-SQL, Trigger
2
Shouts
spam Shout it Mute it

Parent / Child View In a Single Table With GridView Control On ASP.NET Web Forms
published 782 days, 1 hour, 12 minutes ago posted by http://tugberk-ugurlu.myopenid.com/http://tugberk-ugurlu.myopenid.com/ 782 days, 23 hours, 15 minutes ago
Friday, April 29, 2011 2:35:31 PM GMT Thursday, April 28, 2011 4:32:33 PM GMT
This awesome blog post will demonstrate how to create a complete, sub-grouped product list in a single grid. Get ready for the awesomeness... (more)
category: Web Dev | clicked: 13 | comment | | source: tugberkugurlu.com
tags: Entitydatasource, GridView, nested gridview, SQL, ASP.NET
3
Shouts
spam Shout it Mute it

Create Oracle Linked Server to Query data from Oracle to SQL Server
published 783 days, 6 hours, 15 minutes ago posted by eralpereralper 784 days, 10 hours, 29 minutes ago
Thursday, April 28, 2011 9:32:47 AM GMT Wednesday, April 27, 2011 5:19:04 AM GMT
This SQL Server tutorial shows how to create SQL Server linked server to Oracle database, for SQL Server administrators and t-sql developers to execute sql statements over the target Oracle database tables. I install Oracle 10g Express edition on my laptop where a default instance of Microsoft SQL Server 2008 R2 instance is also running. I sometimes require to read data from Oracle database application and display on SQL Server application. So I tried to create linked server from SQL Server to Oracle... (more)
category: Data | clicked: 1 | comment | | source: www.kodyaz.com
tags: SQL Server, SQL, SQL 2008 R2, Oracle, linked server
10
Shouts
spam Shout it Mute it

FREE for SQL Server Course
published 784 days, 17 hours, 45 minutes ago posted by pinaldavepinaldave 785 days, 10 hours, 54 minutes ago
Tuesday, April 26, 2011 10:03:13 PM GMT Tuesday, April 26, 2011 4:53:27 AM GMT
The Moral of Story You can watch the most popular SQL Server – TSQL course on Pluralsight On-Demand for FREE for the next 48 hours. It starts NOW! The Story Learning is always difficult. After learning how to apply your knowledge, learning in real life is even more difficult. Technology is moving faster than the speed of light and new technologies are always emerging – this is now the reality of the new technology world. Between all of this, I personally have very little time to learn new technology. I... (more)
category: Data | clicked: 1 | 2 comments | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
6
Shouts
spam Shout it Mute it

Considerations When Building Database Schema with Federations in SQL Azure - SQL Azure - Cihan Biyikoglu
published 793 days, 1 hour, 46 minutes ago posted by KluggerKlugger 794 days, 2 hours, 52 minutes ago
Monday, April 18, 2011 2:01:52 PM GMT Sunday, April 17, 2011 12:55:44 PM GMT
When working with federations, database schema requires a special consideration. With federations, you take parts of your schema and scale it out. With each federation in the root database, a subset of objects are scaled-out. You may create multiple federations because distribution characteristics and scalability requirements may vary across sets of tables. For example, with an ecommerce app, you may both have a large customer-orders set of tables and a very large product catalog that may have completel... (more)
category: Data | clicked: 1 | comment | | source: blogs.msdn.com
tags: Database Schema, SQL, SQL Azure, Database, Azure
2
Shouts
spam Shout it Mute it

SQL Server Import Data using SQL Server Import Export Data Wizard SSIS Package
posted by eralpereralper 816 days, 17 hours, 49 minutes ago
Friday, March 25, 2011 9:58:51 PM GMT
SQL Server Import Data using SQL Server Import Export Data Wizard SSIS Package SQL Server Import and Export Wizard, one of powerful SQL Server tools enables SQL Server import data easily for ETL developers and database administrators. In this SQL Server tutorial, sql developers will find step by step illustration of how to import data into SQL Server 2008 (or SQL Server 2005) using SQL Server Import Export Data Wizard. Kodyaz community members will remember SQL Server tutorials SQL Server Export to Exc... (more)
category: Data | clicked: 0 | comment | | source: www.kodyaz.com
tags: Import, SQL Server 2008, SQL, SSIS
5
Shouts
spam Shout it Mute it

Logon failed for login due to trigger execution.
published 818 days, 17 hours, 2 minutes ago posted by eralpereralper 819 days, 19 hours, 34 minutes ago
Wednesday, March 23, 2011 10:45:35 PM GMT Tuesday, March 22, 2011 8:13:49 PM GMT
Logon failed for login due to trigger execution. While trying to connect SQL Server using SQL Server Management Studio Object Explorer, I got the following error message "Logon failed for login 'sqluser' due to trigger execution.". When I see the error message occured during connect to SQL Server 2008 R2 database, I realized that the cause of the sql exception is the SQL Server logon trigger which I created recently for SQL Server login audit purposes. (more)
category: Data | clicked: 4 | comment | | source: www.kodyaz.com
tags: SQL Server, DAC, SQL, Trigger
12
Shouts
spam Shout it Mute it

A Hidden Performance Bottleneck - Discover and Resolve
published 820 days, 18 hours, 40 minutes ago posted by pinaldavepinaldave 821 days, 6 hours, 6 minutes ago
Monday, March 21, 2011 9:07:32 PM GMT Monday, March 21, 2011 9:41:30 AM GMT
I have been working a lot on Wait Stats and Wait Types recently. Last Year, I requested blog readers to send me their respective server’s wait stats. I recorded the wait stats and my recommendations and did further research. At some point at time, there were more than 10 different round trips of the recommendations and suggestions. Finally, after six month of working my hands on performance tuning, I have collected some real world wisdom because of this. Now I plan to share my findings with all of you o... (more)
category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
6
Shouts
spam Shout it Mute it

Step-by-Step: Installing SQL Server Management Studio 2008 Express after Visual Studio 2010 - Beth Massi
published 845 days, 7 hours, 57 minutes ago posted by iftekharahmedamitiftekharahmedamit 847 days, 19 hours, 41 minutes ago
Friday, February 25, 2011 7:50:47 AM GMT Tuesday, February 22, 2011 8:06:49 PM GMT
One of the first things I always do after installing Visual Studio is to install SQL Server Management Studio (SSMS). Visual Studio 2010 installs SQL Server 2008 Express on your machine but doesn’t include SSMS. Although you can use Visual Studio to create/connect/design databases, I like having SSMS around for advanced management. I recall SSMS for SQL Server 2005 was a simple install, unfortunately they threw the kitchen sink into the SSMS 2008 installer and I’m always confused at which buttons I need ... (more)
category: Data | clicked: 13 | 2 comments | | source: blogs.msdn.com
tags: SQL Server, SQL Server Management Studio, Visual Studio 2010, SQL
7
Shouts
spam Shout it Mute it

Microsoft SQL Server JDBC 3.0 and SQL Azure - Microsoft JDBC Driver Team Blog
published 847 days, 19 hours, 49 minutes ago posted by StevesSteves 848 days, 3 hours, 57 minutes ago
Tuesday, February 22, 2011 7:59:04 PM GMT Tuesday, February 22, 2011 11:51:09 AM GMT
Dear SQL Server and SQL Azure developers and users: We are very pleased to announce the availability of an updated version of Microsoft SQL Server JDBC Driver 3.0 supporting Microsoft SQL Azure database: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ae924066-2946-40a7-93c6-c7e83f54072f&displaylang=en This updated version supersedes the release version of SQL Server JDBC Driver 3.0 and also addresses an issue with JDBC API getSchemas. For further information on getSchema issue, please... (more)
category: Data | clicked: 0 | comment | | source: blogs.msdn.com
tags: SQL Server, JDBC, SQL, SQL Azure
5
Shouts
spam Shout it Mute it

SQL Injection vs. Lethal Injection / Protection Against SQL Injection
published 848 days, 21 hours, 24 minutes ago posted by http://tugberk-ugurlu.myopenid.com/http://tugberk-ugurlu.myopenid.com/ 852 days, 5 hours, 4 minutes ago
Monday, February 21, 2011 6:24:18 PM GMT Friday, February 18, 2011 10:44:16 AM GMT
SQL Injection and Lethal Injection... They are both dangerous and they can be easily fatal. But how? What is SQL Injection and how it can effect my project? The answers are in this blog post. (more)
category: Data | clicked: 1 | 1 comment | | source: tugberkugurlu.com
tags: SQL Server, Security, SQL, SQL Injection, Database
4
Shouts
spam Shout it Mute it

Use xp_dirtree SQL Server Stored Procedure and Recursive CTE Query to List Hierarchical Structure of File Folders
published 850 days, 21 hours, 33 minutes ago posted by tsqltsql 854 days, 6 hours, 42 minutes ago
Saturday, February 19, 2011 6:14:56 PM GMT Wednesday, February 16, 2011 9:05:49 AM GMT
Use xpdirtree SQL Server Stored Procedure and Recursive CTE Query to List Hierarchical Structure of File Folders T-SQL developers can use xpdirtree SQL Server stored procedure to display subdirectory list beneath a given file folder as input parameter. xpdirtree extended stored procedure is one of the SQL Server undocumented stored procedures. In this SQL tutorial, we will use SQL Server xpdirtree stored procedure with T-SQL recursive CTE query in order to list hierarchical structure of file folders. (more)
category: Data | clicked: 35 | comment | | source: www.kodyaz.com
tags: SQL Server, SQL, T-SQL
Previous 1 2 3 4 5 6 7 8 9 10 Next