Forum Replies Created
Viewing 15 posts - 16 through 30 (of 73 total)
-
RE: Create a stored procedure
happycat59 (10/14/2014)
I get errorMsg 156, Level 15, State 1, Procedure my_sp, Line 2
Incorrect syntax near the keyword 'FROM'.
because "Column" is a reserved keyword and needs to be delimited if you...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: All datatypes basics in SQL Server 2008R2.
Jeff Torres (10/12/2014)
Shiva,Why are there Chinese characters for the following data types and what do they mean?
,[Nchar22] NCHAR(10) DEFAULT('????')
,[Nvarchar23] NVARCHAR(10) DEFAULT('?????')
,[Ntext24] NTEXT DEFAULT('????')
Jeff
Jeff varchar follow non Unicode characters while nvarchar...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: Code For Truncating Table with foreign Key Constraints
Thank you dear, I will get back to you on monday.
Happy weekend.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: Code For Truncating Table with foreign Key Constraints
I didn't find any error, Will you show me complete error-
This will help others too.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: All datatypes basics in SQL Server 2008R2.
Hi Shiva,
Great job,
still i find one column empty.
you may use either
,[Uniqueidentifier10] UNIQUEIDENTIFIER Default NEWID()at create table statement orINSERT INTO tblWithAllDatatypes (bit1,Uniqueidentifier10)select null,NEWID();
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: THROW defaults
+1
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: information about modification of sql object
Vimal Lohani (9/25/2014)
Hi,Is it possible to get all information about modification of sql objects,
For eg. I have stored procedure i have altered it 5 times, can i get all date...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: Random values
Shiva you are right.
Good observation...:-)
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: Supported spatial data formats
uff, what a question, so concentration required.
my (70-461) preparation, helped me to solve this.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: ISNULL
Good one..
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: how to shutdown ?
spectra (9/20/2014)
DBA From The Cold (9/19/2014)
Safest way is through the SQL Server Configuration Manager.Right click the database engine service and choose stop. Be aware this will immediately stop the service!
There...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: check column exist or not if not exist assign null values for that column
Hi asrinu13,
May you have some constraint in ref table, Please check it.
Other wise no problem in transferring data from one table to another.
Create table #temp1 (id int, name nvarchar(20), salary...Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: Which is the correct spatial data type?
Interesting and Important for (70-461) preparation.
+1
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: Backup is corrupted or not?
Use
RESTORE FILELISTONLY FROM DISK = '<FILELOCATION>' WITH FILE = 1
GO
OR
restore headeronly from disk = 'c:\restore.bak'
If you will get null null in all columns then either the backup is corrupted or...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
-
RE: Parameters may improve SQL Backup Performance in SQL Server 2008
+1
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
Viewing 15 posts - 16 through 30 (of 73 total)