This is my table CREATE TABLE [dbo].[Testng]( [ID] [int] IDENTITY(1,1) NOT NULL, [EventOn] [datetime] NULL CONSTRAINT [DF03317E3F] DEFAULT...
Hi All, DECLARE @Lock TABLE(LogInID INT, UserName VARCHAR(50), IpAddress VARCHAR(50), LogInDate DATETIME)INSERT INTO @LockSELECT 10, 'rkbabu',...
Sorry FrankKalis. once again I need changed the Table structure. Thanks for the reply.DECLARE @CheckInTime AS TABLE(EmpID INT, InTime DATETIME,...
Thanks for the quick reply Frank Kalis. Now I changed the table structure. DECLARE @CheckInTime AS TABLE(EmpID INT, InTime DATETIME)INSERT INTO...
Hi, DECLARE @CheckInTime AS TABLE(InTime DATETIME) INSERT INTO @CheckInTime SELECT '1900-01-01 11:50:00.000' UNION ALL SELECT '1900-01-01...
Can't able to get the identity column name. So I changed like below. DECLARE @TableName NVARCHAR(50)SET @TableName = 'PkFkIkTest'SELECT...
Hi all, I wants to get the PrimaryKey, ForeignKey, UniqueKey, IdentityKey column names. I tried with the below query. But it returns all the...
I read that float is stored as binary and decimal, numeric is stored as number itself. So I want to learn how the value of each datatype is...
Hi all, What is the internal representation of all the datatypes. Thanks, Babu Kumaraasamy
Since max(id) will produce wrong value on deletion. When deleting the last record i am getting the same id once again. So help me with producing by...
Consider I am having a table ([DBO].[WBCustomer]) with IDENTITY column ID. Truncate table [DBO].[WBCustomer] DBCC CHECKIDENT ('[DBO].[WBCustomer]',...
I don't know how to do with SELECT * FROM INFORMATION_SCHEMA.COLUMNS SELECT * FROM INFORMATION_SCHEMA.PARAMETERS
I will be happy if I get both?. Thanks for the reply.
Hi all, We are having 125 tables and more than 1800 sp in our database with 8 schema. Lots of Procedures are given with wrong data type and size....
How to convert the two case statement in to single case statement CASE WHEN @StartKMs <> VRL.EndKms...
Thanks, I had changed
I am using the same thing only in the function SELECT Id FROM TestTable WHERE StartKMs BETWEEN @StartKMs AND @EndKms...
create table TestTable (ID INT IDENTITY, StartKms NUMERIC(18,2), EndKms NUMERIC(18,2)) INSERT INTO TestTable(StartKms, EndKms ) SELECT 6, 8 UNION...
Hi all, This gives the Parameters, DataType and its Size used in the stored Procedure 'SP_Name' SELECT PARAMETER_NAME , DATA_TYPE...
<p>I am having table like this.<br></p><table x:str="" width="600" border="1" cellpadding="0" cellspacing="1" height="115"><col span="8" width="80">...
Separate names with a comma.
