This is my table
CREATE TABLE [dbo].[Testng](
[ID] [int] IDENTITY(1,1) NOT NULL,
[EventOn] [datetime] NULL CONSTRAINT [DF03317E3F] DEFAULT...
@Lock TABLE(LogInID INT, UserName VARCHAR(50), IpAddress VARCHAR(50), LogInDate DATETIME)INSERT
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
DECLARE @CheckInTime AS TABLE(InTime DATETIME)
INSERT INTO @CheckInTime
SELECT '1900-01-01 11:50:00.000' UNION ALL
Can't able to get the identity column name.
So I changed like below.
@TableName = 'PkFkIkTest'SELECT...
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...
What is the internal representation of all the datatypes.
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.
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
WHEN @StartKMs <> VRL.EndKms...
I had changed
I am using the same thing only in the function
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...
This gives the Parameters, DataType and its Size used in the stored Procedure 'SP_Name'
SELECT PARAMETER_NAME ,
<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.