October 27, 2013
SQL SERVER INSTALLATION PROBLEMS AND LOGIN PROBLEMS
My system is 32 bit + windows 7
Installing SQL SERVER 2008 R2
WHAT IS R2 NOW ?
The "R2" suffix in Microsoft-ese stands for "Release 2".
1)
STEP...
Sunday, 27 October 2013
Sunday, 13 October 2013
October 13, 2013
GO SCRIPT
SCRIPTS
--A SQL SCRIPT IS A
.SQL FILE (OR OTHER) THAT CONTAINS SQL COMMANDS TO EXECUTE.
--WRITE SOME SQL
COMMANDS
--FILE-->SAVE
[SAVE SOMEWHER...
October 13, 2013
Add Default Constraint
-------ADD A
DEFAULT CONSTRAINT------------------
CREATE TABLE GENDER
(
GENDERID INT PRIMARY KEY NOT NULL,
GENDER VARCHAR(10)
)
INSERT INTO...
Monday, 7 October 2013
October 07, 2013
CURSOR IN DETAIL AND THE TRICK TO USE IT AS CUMMULATIVE WAY IN REAL TIME
--LETS TALK
ABOUT BRIEFLY ABOUT CURSOR--
--1)WHAT IS
CURSOR ?
--ANSWER->A
CURSOR JUST POINT ONE SINGLE RECORD AT A POINT. THEN IT MOVES THROUGH...
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.