Search results for query: *

Delcare a variable with decimal datatype having scale 2 and assign the original value to newly declared variable. DECLARE @result decimal(5,2), @value1 decimal(5,4), @value2 decimal(5,4) SET @value1 = 1.1004 SET @value2 = 1.0004 SELECT @result = @value1 SELECT @result select @result=@value2...

Hi, Try this select * from <table_name> with (tablock,updlock) The above query will have the table level lock and update lock until the end of the statement or end of transaction. For more hlep read locking, hints in BOL. Madhu.

Hi, While creating a table itself you can create the computed field. Suppose you want to create a column as sum of two already delcared columns, you can create as follows create table test (a int, b int, c as a+b) Here the column C is stored the date vartually in the table , it cannot...

Hi, Sql server will not allow you to use the USE statement inside a Stored Procedure. So it might be the problem. Check once again your stored procedure and modify it as what you want. Madhu.

You must provide the single quote &quot;'&quot; if U use string type data so write as, searchSQL = searchSQL & &quot;where Daily ='&quot; & mydata & &quot;'&quot; instead of searchSQL = searchSQL & &quot;where Daily =&quot; & mydata Madhu.

Hi, It may helps to you try this, exec sp_dboption 'databasename','single user','TRUE' Madhu.

Please check the above query, I think you have to add the TableX_1.COD = TableX.COD instead of TableX_1.NAME = TableX.NAME in above query. Madhu.

Hello, You can write the dos commands as batch file and save it externally to a path and run via the Query analyser with the full path. For ex: Suppose, as you mentioned in your question comprise the dos commands as a batch file and store it as sample.bat in c drive or d drive or at any whare...

Hi, Try in following manner USE pubs BEGIN TRAN SELECT COUNT(*) FROM authors WITH (TABLOCK, HOLDLOCK) or read BOL locking,hints topic. Madhu.

Hello, I think below one will solves your problem, you can try this Begin transaction Insert into temp_table values(1,'mahesh') Select max(id) from temp_table with (TABLOCK,HOLDLOCK) Commit transactin Or if you want to lock the table exclusively use XLOCK option. Madhu.

Try SELECT @Appid=appid From Deleted instead of SELECT @Appid = (Select Appid From Deleted) Madhu.

you can do it by using functions LOWER(char_exp) or UPPER(char_exp). LOWER function will be used to convert all upper case letters to lower case letters, UPPER case function also in similar way used. It may be helpful to U, I think. Madhu.

you can do it by using LOWER(char_exp) or UPPER(char_exp). Lower function will be usefull to convert all upper case letters to lower case letters, the similar way UPPER function also. It may help to U, I think. Madhu.

Hi, You have to create the destination database in Sql server200 before importing data from Oracle with DTS wizard. Madhu.