Pages

SQL
Hot In It
Money
Blogging Tips
Asp.Net
About Me

My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

Tips for Sql

A Blog about Sql Server 2008.Easy to understand Sql Server Tips and Tutorials for beginners and useful sql server knowledge information for database developers.

Online Support

Click Here For Free Online Chat

Intro To Database Standford Lecture

Monday, 31 October 2011

http://openclassroom.stanford.edu/MainFolder/CoursePage.php?course=IntroToDatabases

Posted by Madhu at 05:33 0 comments

Email This BlogThis!Share to X Share to Facebook

Newer Posts Older Posts Home

Labels

add column
add spaces
alter table
batch file
catch
char index
charindex
command
connection strings
database
dcmtk
debugger
delete based on last modified date
dir
dos
dos command
encrypt
forfiles
free online support
functions
funtion to display dates between two dates
Identity
insert
merge
online chat
OPTIMIZATION
pacs
parameter with spaces
performance
poweshell
procedures
read attributes of xml
read relement of xml
round off time
script task
sp
sql optimize
sql querry
sql server
sql to xml
sqlcmd
ssis
ssis connection string
stored procedure
storescp
storescp.exe
subquery
temp dynamic query
trailing space
try
try catch
variables
website chat
whatis
windows service
xml
xml file to table
xml query
xml read
xml to sql
xpath

Blogger templates

Blogger news

Most Reading

Check Column exists in table, if not, add

Check For a Column Exists In A Table If Not Add IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_NAME = ...
SSIS Connection String Format

Connection String is assigned to a variable in the below format Data Source=10.200.2.55;User ID=sa;Password =Welcome123;initial Catalog=Med...
Precision, Scale, and Length (Transact-SQL)

Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example,...
Exe To Windows Service

How to convert an exe to a service? How to create user defined function in windows? How to create a PACS windows Service Using dc...
Importing XML File to Sql Server Table

Here is the example on how to import an xml file in the sql server installed machine to sql server table . Steps to do this 1. Save the ...
Function to Parse AlphaNumeric Characters from String

CREATE FUNCTION dbo.UDF_ParseAlphaChars ( @string VARCHAR ( 8000 ) ) RETURNS VARCHAR ( 8000 ) AS BEGIN DECLARE @IncorrectCharLoc SMA...
SQL SERVER - Insert from one table to another Table

In SQL Database , You can probably insert data from one table into another using two methods. 1. Insert Into - This is used when the tab...
wait statistics -Dynamic Management Views

Select * from sys . dm_os_wait_stats Select * from sys . dm_os_waiting_tasks
Free Google Online Chat Support For Website and Blogs

Free Google Online Chat Support For Website and Blogs STEP1 Go to the following site and create a badge as shown in the Picture http://ww...
XML TO SQL SERVER

I f you’ve got some XML data in a SQL Server column, how can you flatten it out and query it or present it as though it was relational da...