sql

  • Retrieving Data as XML from SQL Server Article

    Retrieving Data as XML from SQL Server Article 2001-10-01

    All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data

    Tags:
  • Your First SQL Server 2000 Database

    Your First SQL Server 2000 Database 2002-04-10

    Try surfing around the Internet and find a popular site that doesn't use some sort of database to store its content. I bet you'll have a tough time finding just one popular site (i.e. receiving over 5,000 unique visitors a day) that doesn't use some

    Tags:
  • SQL Injection Attacks - Are You Safe? 2002-06-17

    The database is the heart of most Web applications: it stores the data needed for the Websites and applications to "survive". It stores user credentials and sensitive financial information. It stores preferences, invoices, payments, inventory da

    Tags:
  • Stored Procedures on PHP and Microsoft SQL Server 2003-11-26

    Though it's not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. Bu

    Tags:
  • Publish Dynamic Data with SQL Server's Web Assistant Wizard

    Publish Dynamic Data with SQL Server's Web Assistant Wizard 2003-12-30

    As the Web and its development mature, more systems and applications release their own Web interfaces. If, for instance, you buy a wireless access point, it can be configured through a Web page. Or, consider Internet Information Server, which has its

    Tags:
  • Parameterised SQL Queries 2004-04-16

    Reading on the forums, this question often arises. How and why should we use parameters in our SQL queries? First things first. Here's a parameterised query: sqlConnection1.Open(); SqlCommand comm = new SqlCommand("select * from foo where [email protected]&q

    Tags:
  • SQL Server 2000 Reporting Services SR-1 Out! 2004-06-22

    SQL Server 2000 Reporting Service Pack 1 is out today. Biggest improvements have made to the report rendering engines, but, here's an overview of the big changes in this release: # Excel rendering extension has been improved and now supports viewing

    Tags:
  • SQL Server 2005 Express is not Yukon Beta 2 2004-07-02

    Hope you've all been enjoying downloading and playing with the new Express range of Visual Studio.NET tools. One thing to note, however, is that the SQL Server 2005 Express product is NOT Yukon, with all the lovely features that brings. Instead, it's

    Tags:
  • Say Bye Bye to MSDE SQL 2004-07-28

    Ok all! I just found this, so forgive me if you've found it already. Apparently Microsoft has decided to get rid of the MSDE version of SQL Server. MSDE is the Microsoft Developers Edition, this is a free version of SQL Server which is intended for d

    Tags:
  • QA for SQL Express 2005? 2004-08-26

    One of the features lacking in the SQL Express 2005 package is a Query Analyser. Of course, Microsoft have big plans for frontends to SQL Server 2005, however, I want something now! QA Replacement Program is the first step towards building a free Que

    Tags:
  • SQL Server 2005 Express via ODBC? 2004-09-10

    Need to run SQL Express within applications other than those supporting .NET? Well, I needed to get my database schema to Visio, yet none of the connectors would work. By default, Express doesn't talk via TCP or NP and its default listeners won't acc

    Tags:
  • Get More out of SQL Server's Web Assistant Wizard

    Get More out of SQL Server's Web Assistant Wizard 2004-09-16

    In my previous article, Publish Dynamic Data with SQL Server's Web Assistant, you learned that you don't need any HTML skills to share your database data on the Internet. The Wizard can take care of all the formatting and lead you through the creatio

    Tags:
  • Who Be Me Sql Server User in This Configuration? 2006-11-01

    One of the poorly documented, yet quite important, facts of life in dealing with .NET applications is that one is often using Windows Authentication to communicate with Sql Server databases. Unfortunately, exactly which identity one is using by defau

    Tags:
  • Sql Server Full-Text Search Protips Part 1: Setup 2006-11-12

    As I have previously mentioned, Sql Server's Full-Text search can let a developer create some very slick features disturbingly easily. And, unlike many other Full-Text implementations, it is not limited to plain text fields. It can also search within

    Tags:
  • Sql Server Full-Text Search Protips Part 2: CONTAINS vs. FREETEXT 2006-12-06

    In Part 1 of this series we explored the methodology for enabling a Sql Server database for Full-Text Indexing and enabling Full-Text indicies on specific tables. But now we get to the good part-how to use that index in your application. There are fo

    Tags:
  • Sql Server Full-Text Search Protips Part 3: Getting RANKed 2006-12-30

    In Part 1 of this series we explored the methodology for enabling a Sql Server database for Full-Text Indexing and enabling Full-Text indices on specific tables. And in Part 2 of this series we explored the methodology for accessing these Full-Text i

    Tags:
  • SQL injection (Union select?) 2008-09-12

    If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$

    Tags: php, mysql, sql, security, sql injection
  • Linq to SQL Convert 2008-11-17

    Is there a tool out there which can convert SQL syntax to LINQ syntax? I just want to rewrite basic queries with join, etc., to LINQ. It would save me a lot of time. --------------Solutions------------- Linqer is a SQL to LINQ converter tool. It help

    Tags: sql, linq
  • Simply SQL: The FROM Clause

    Simply SQL: The FROM Clause 2009-02-18

    This article is Chapter 3 from the SitePoint book Simply SQL by Rudy Limeback. In Chapter 2, An Overview of the SELECT Statement, we broke the SELECT statement down into its various clauses, but looked at each clause only briefly. In this chapter, we

    Tags:
  • Learn SQL -- The EASY Way!

    Learn SQL -- The EASY Way! 2009-02-18

    We're very pleased to announce the latest addition to the SitePoint library, Simply SQL, by Rudy Limeback. Simply SQL is a practical step-by-step guide to writing SQL. You'll learn how to make the most of your data using best-practice SQL code. Rathe

    Tags:

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.265 (s). 6 q(s)