8:09 AM
Deep Dey
This error occurs when a variable name is preceded by # instead of @. # is used to declare temporary table
declare #myi int
Should be replaced by
declare @myi int
skip to main |
skip to sidebar
- Home
- SQL Basic
- SQL Advanced
- SQL Top
- SQL Like
- SQL Wildcards
- SQL In
- SQL Between
- SQL Alias
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Union
- SQL Select Into
- SQL Create DB
- SQL Create Table
- SQL Constraints
- SQL Not Null
- SQL Unique
- SQL Primary Key
- SQL Foreign Key
- SQL Check
- SQL Default
- SQL Create Index
- SQL Drop
- SQL Alter
- SQL Increment
- SQL Views
- SQL Dates
- SQL Nulls
- SQL isnull()
- SQL Data Types
- SQL Functions
- Table Manipulation
- SQL CREATE TABLE
- SQL CONSTRAINT
- SQL NOT NULL
- SQL DEFAULT
- SQL UNIQUE
- SQL CHECK
- SQL PRIMARY KEY
- SQL FOREIGN KEY
- SQL View
- SQL CREATE VIEW
- SQL Index
- SQL Alter Table Add Column Syntax
- SQL Alter Table Modify Column Syntax
- SQL Alter Table Rename Column Syntax
- SQL Alter Table Drop Column Syntax
- SQL Alter Table Add Index Syntax
- SQL Alter Table Drop Index Syntax
- SQL Alter Table Add Constraint Syntax
- SQL Alter Table Drop Constraint Syntax
- SQL DROP TABLE
- SQL TRUNCATE TABLE
- SQL USE
- SQL INSERT INTO
- SQL UPDATE
- SQL DELETE FROM
- SQL Answers
- Submit Question
Search This Blog
Daily Visits
Followers
Date And Time
Updates
Recent Posts
About E-Learn
What We Do
elearnsqlserver is a site devoted to bringing you easy to understand, simple to implement tutorials and query examples for SQL.
Who We Are
The team behind elearnsqlserver is The E-Learning Network. The E-Learning Network is a collection of tutorial websites focused on teaching the world about Technology.
Contacting Us
If you have any suggestions for tutorials, or you found a bug to squash, or maybe you just want to chat it up please hop over to the Contact page and drop us a line. Have a great day!
Copyright © 2011 E-Learn SQL Server | Powered by Deep's
0 comments:
Post a Comment