Blog
I am using Visual Studio 2008 and thereby utilizing the ASP.NET AJAX plumbing that comes along with it. Step 1: Open VS 2008. Click File > New > Website. Choose ASP.NET Website from the list of installed template, choose target platform as .NET Framework 3.5, choose the desired language and enter the location where you would like to store the website on your FileSystem. I have created a folder called VS2008 Projects, so the location over here is C:\VS2008 Projects\ GridViewPaginUsingSliderExt... ......
I am refreshing myself how to prgramming in VB again :-) The user interface is a very important part of any program: This is how people use your program it needs to look good and do its job well. Most important for beginner is how to use the Toolbox and how to make controls like buttons and checkboxes fit on the form better. Toolbox is where you will find all of things to add to your user interface like buttons and labels. If you don't see it (it's usually on the left) you can make it appear by clicking ......
Q. What's the main difference between ACCESS and SQL SERVER? Ans: As said before access fulfill all of the CODD rules and behaves as a true RDBMS. But there's a huge difference from architecture perspective, due to which many developers prefer to use SQL SERVER as a major rather than access. Following is a list of architecture difference between them: Access uses file server design and SQL SERVER uses the Client/Server model. The major difference between SQL SERVER and ACCESS. NOTES: Just to clarify ......
Q. What is database or database management systems (DBMS)? TWIST: - What's the different between file and database? Can files qualify as a database? NOTE: Probably these questions are too basic for experienced SQL Server guys. But from freshers point of view it can be a difference between getting a job and to be jobless. Ans: Database provides a systematic and organized ways of storing, managing and retrieving from collection of logically related information. Secondly the information has to be persistent, ......
USE Northwind; ---------------------------... -- Create a view to format data for -- mailing labels ---------------------------... CREATE VIEW dbo.vwEmployeeAddressLabels AS SELECT Address FirstName + SPACE(1) + LastName + Char(13) + Char(10) + + Char(13) + Char(10) + City + CASE WHEN Region IS NULL THEN ' ' + PostalCodeELSE ', ' + Region + ' ' + PostalCodeEND + Char(13) + Char(10) + CountryAS Address FROM dbo.Employees; GO -- Select from the view: -- (best viewed with results to text) ......
USE masterGOif exists (select * from sysdatabases where name='Northwind') drop database Northwindgo DECLARE @device_directory NVARCHAR(520)SELECT @device_directory = SUBSTRING(filename, 1, CHARINDEX(N'master.mdf', LOWER(filename)) - 1)FROM master.dbo.sysaltfiles WHERE dbid = 1 AND fileid = 1 EXECUTE (N'CREATE DATABASE Northwind ON PRIMARY (NAME = N''Northwind'', FILENAME = N''' + @device_directory + N'northwnd.mdf'') LOG ON (NAME = N''Northwind_log'', FILENAME = N''' + @device_directory + N'northwnd.ldf'')')go ......
---------------------------... -- Batches -- Create a table and a view ---------------------------... --This causes an error USE tempdb; CREATE TABLE dbo.Test ( ID TestName ); int NOT NULL, varchar(50) NOT NULL CREATE VIEW dbo.vwTest AS SELECT TestName FROM dbo.Test; --Creating multiple dependent objects requires a GO separator. USE tempdb; CREATE TABLE dbo.Test ( ID TestName ); int NOT NULL, varchar(50) NOT NULL GO CREATE VIEW dbo.vwTest AS SELECT TestName FROM ......
-- Enable SQLCLR -- ************* sp_configure GO 'clr_enabled', 1 RECONFIGURE GO -- Install and register HelloSQLCLR -- ***************************... USE GO Northwind -- Install (change the directory to the actual location) CREATE ASSEMBLY MyUDFsLibFROM 'C:\SQL2005Core\SQLCLR\Hell... GO -- Register CREATE FUNCTION dbo.HelloSQLCLR() RETURNS NVARCHAR(50) EXTERNAL NAME MyUDFsLib.MyUDFs.HelloSQLCLR; -- EXTERNAL_NAME is assembly name, namespace/class, -- and method name -- Test ......
USE Northwind; GO CREATE PROCEDURE dbo.ListEmployees AS SET NOCOUNT ON SELECT EmployeeID, LastName, FirstNameFROM dbo.Employees; GO EXECUTE dbo.ListEmployees; EXEC dbo.ListEmployees; GO CREATE @City PROC dbo.ListEmployeesByCityvarc... AS SET NOCOUNT ON SELECT LastName, FirstName, CityFROM dbo.EmployeesWHERE City = @City; GO EXEC dbo.ListEmployeesByCity @City = 'London'; EXEC dbo.ListEmployeesByCity 'London'; GO CREATE @City PROC dbo.ListEmployeesOptionalCi... = NULL AS SET NOCOUNT ON ......
Select “SQL Sources”. line above. Well, by now you already get it right? one of my favor SQL Sources :)!!
The Professional Association for SQL Server Migrating to SQL Server 2005 - Tips and T... Regional Chapters and Groups OLAP Browser is a multi, data analysis and reporting, software application for MS SQL Server Clients Free SQL Server Resources on SearchSQLServer.com ER/Studio of Embarcadero.com ......
Using Knowledge Management to vastly improve Database Management Database Management needs to continue move into direction by using Knowledge Management. She sees Data moving from being a cost center administrative function to an active contributor of corporate profits. Outcomes and Opportunities this Idea affords: Working closely with an organization's Database Management Team to apply her knowledge in finding the right tools and technique as well as the right assignment. One of the most important ......
The presentation does not define the complete syntax -- see sqlgram.py for the precise syntax as BNF -- nor the complete semantics -- see a good book on SQL for more detailed coverage of semantic (or use the source, Luke ;c) ). Also, please have a look at my evolving database course notes for more coverage of SQL. Examples of all supported constructs are also shown in the test suite source file gftest.py. This document is only a very brief guide, primarily of use to those who already understand something ......
OTHER PROCEDURES sp_bcp: Create unix script to bcp in/out database sp_date: Who can remember all the date styles? sp_iostat: Loops n times showing active processes only sp_grep: Search for patern sp_isactive: Shows info about a single active process sp_lsLists specific objects sp_ quickstatsQuick dump of server summary information sp_whoactive: Show info about who is active The following is a list of errors generated by the auditing procedures 31001 User +name+ Is Locked 31002 Login +name+ Is Expired ......
These procedures are installed into sybsystemprocs on sybase and into master on sql server. All procedure names start with "sp__" (two underscores). This naming convention ensures that the procedures, when run, will be available from any database and that, when they are run, the database context will be the current database. This naming convention also ensures that there are no naming conflicts with Sybase's internal procedures. Thus, if you are in the statsdb database, you can get the space used ......
Checks Common Database Problems Lists users in group public if groups are used. Warn about lack of groups if no groups exist besides public. List users aliased to another non dbo user. List aliases without logins (login previously dropped). List users without logins (login previously dropped). List objects owned by non-dbo (maybe poor code control?). Find objects with access to syslogins in them. This procedure excludes normal objects like sp__addlogin. Use of this procedure will identify potential ......