|
Always for a date field use datetime.
Nuclear launch detected
|
|
|
|
|
DateTime every time.
And why would you want to know the customer's birthdate? I always enter 1900-01-01.
|
|
|
|
|
Marketing. Use a HTML template to congratulate the customer on birthday date...
Nuclear launch detected
|
|
|
|
|
hi all,
can I create sp which take table name ,first column ,secound column as a parameters to create table
(2 columns only) with this varibles name
for example to demonestrate my idea
ex:
---------------------------------
create proc Createtable
@tablename,
@firstColumn Varchar(40),
@secoundColumn Varchar(40)
as
create table @Tablename (@FirstColumn Varchar(40),@SecoundColumn Varchar(40))
----------------------------------
this is my idea Plz help me
Kareem Elhosseny
|
|
|
|
|
sp_executesql 'create table ' + @Tablename + '(' + @FirstColumn + <br />
' Varchar(40), ' + @SecoundColumn + ' Varchar(40))'
- Regards -
JON
Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
|
you can use this command
SELECT RAND(@counter) Random_Number
123
|
|
|
|
|
Hi,
How can Select first 5 records of a table In SQL Server 2000?
In SQL Server 2005 can use Select Top(5) ... but in 2000 what?
Best wishes
|
|
|
|
|
Select Top Num? * from Tablename?
example ;
i need top 5 rows from Orders.
Select top 5 from Orders
123
|
|
|
|
|
It's the same syntax in both versions.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
what's different between index and primarykey?
123
|
|
|
|
|
SVb.net wrote: what's different between index and primarykey?
1. Primary Key Is A UNIQUE Constraint created against the table to uniquely identify each record in the table.
2. A table can have only one PRIMARY KEY constraint.
3. PRIMARY KEY constraint automatically creates Clustered Index against the Column. Physical order of rows is the same as the indexed order of the rows.
1.An Index is a UNIQUE Reference internally created by the Database engine against the Table or View for reference.
2. A table can have 250 Indexes (1 Clustered and 249 Non-Clustered).
3. Physical order of the rows is independent of their indexed order for Non-Clustered Indexes.
- Regards -
JON
Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
John Prabhu wrote: Clustered Index against the Column
what does it mean? can you please explain in details ?
Becoming Programmer...
|
|
|
|
|
xmen_xwk wrote: can you please explain in details ?
Initially when a new table is created, there is no index created by default. As I said in the previous post that an Index is a Reference created by the Database engine for reference, Just like an Index in the book to locate the information. there are 2 types of Indexes created in an Sql Server table - Clustered and Non-Clustered. As I said that When you create a Primary key on a table, By default a clustered Index is created on the table. A Clustered Index is similar to a dictionary. In a dictionary, the words are organized and sorted alphabetically. Same way on Clustered Index Column the records are sorted in the same order as the indexed order of the rows.
- Regards -
JON
Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
i hope, i shall understand it soon XD
Becoming Programmer...
|
|
|
|
|
Hello....i've been working in ado.net for a few months now... and am quite confused how to use the dataset object. though i know it depends on what type of project a person is upto but still i wanted to know which one is the better approach to usin the datasets...
Approach 1: fill the dataset with all tables at project load and use the dataset for all searches and things. though as sqlserver is locally placed, i update the sqlserver tables as soon as i update the data set...
Approach 2: fill dataset with only the rows that are required... ie if u need some rows according to a criteria, write a select statement, discard ur present dataset and refil it with this statement...
Please provide full information,based on performance issues of a system...
as far as i think , i believe approach1 will be better but it becomes hard to handle when u have more tables, like 60 tables... so wat should be done in this case, "A dataset for every 10 tables"? or wat...
Thanx
haseeb
haseeb
|
|
|
|
|
I am developing an application in which when user did login and want to make his sub-login suppose 5 then at the time of making sub-logins the column that contains the number of sub-login 5 may be decremented by 1 itself and when he delete any one of his sub-login then this field will automatically incremented. This application is in C#.NET
|
|
|
|
|
Run an UPDATE query to increment or decrement whatever field is being used to store the number of sub-logins for a particular user, e.g. UPDATE mytable SET sublogin = sublogin +/- 1 WHERE ...
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Any one knows how to use aggregate function on a multiple table. Following query is i am trying but i m not getting any success
SELECT up.UP_C_Date, up.UP_FN, up.UP_LN, up.UP_HEM, up.UP_CITY, up.UP_REG, up.UP_ZIP, up.UP_HPh, up.UP_STAT,count(cp.FK_UA_ID) FROM VTX_UP up, VTX_CRT_PM cp where cp.FK_UA_ID=up.FK_UA_ID;
How can I use aggregate function on a multiple table condition
Rock Star
|
|
|
|
|
There's no difference between using aggregate functions on a single-table query to a multiple-table query.
The problem with your query is that it doesn't have a GROUP BY clause. You use a GROUP BY clause to group similar items of data together. For each group of distinct data items, the COUNT function will return the count of items within this group. Without a GROUP BY clause, no grouping of data will occur and the COUNT function will always return 1.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
You need to put a GROUP BY statement in containing the other fields.
|
|
|
|
|
Hi there .
please help me about this error :
The header for file '%ls' is not a valid database file header. The %ls property is incorrect.
I don't have any backup.
help me to restore my db
DMASTER
|
|
|
|
|
|
I'm working on a project using SSRS and have a query that may accept a multiple valued integer as one of its parameters. I want to do something like this:
<br />
AND p.ID in (<br />
case @pList<br />
when '' then p.ID<br />
else (select id from dbo.fn_split_id_integer(@pList))<br />
end)<br />
which is fine when @Plist is empty but when it has multiple values in it the engine throws an error because multiple values are returned from the select statement, even though I'm using in rather than =.
Has anyone got any suggestions about how get this to work?
It definitely isn't definatley
|
|
|
|
|
AND p.ID in (<br />
case @pList<br />
when '' then p.ID<br />
else (select id from dbo.fn_split_id_integer(@pList))<br />
end)
The highlighted portion of the query is incorrect. Each branch of the CASE statement can only return a scalar value. In the ELSE clause, you are trying to return a table value.
You should change your query so that you JOIN p to the result of fn_split_id_integer().
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
