All DevCenters
MSDN Home
Sign in to Windows Live ID
MSDN Code Gallery:   Code Gallery Home   |   Browse Gallery   |   Share Code   |   Help and FAQs
Home
Downloads
Discussions
People
License
 
Discussions List | Create New Discussion
1-10 of 25 < Previous Next >
Discussions for TSQL Samples from Venkatesan Prabu - SQL Server MVP
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: DBReindex: DBReindex is used to reindex the entire sql server database. It will flush out the indexes and create new index in the leaf level. Thats why its considered as very effective in...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: Copy only structure with out data from SQL Server table: Am creating a table name Table1, CREATE TABLE Table1(id int primary key,nam varchar(10)) I am creating the second table Table2. ...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: Copy table in sql server: In our database world, we used to face this situation frequently. You will be given a table and requested to copy those data into another table. Let's see how to...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: Stored procedure output into the table: I have seen lots of lots people are querying about, projecting stored procedure output into a table. I will take an extended procedure to explain t...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: Am creating a table name Table1, CREATE TABLE Table1(id int primary key,nam varchar(10)) I am creating the second table Table2. CREATE TABLE Table2(id1 int primary key, nam varchar(10))...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: Trim function is a very important function in database part. Sometimes, our front end application will populate some spaces with out actual data. While validating the data ( "X" is not...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: Count data value in a group from result set: I have come up with a new scenario like, I need to add the data value in the result set. Using the below technique, we can achieve the same. ...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: charindex in sql server: Charindex method is used to identify a particular character position in the string. Thh syntax is Charindex(character or string to find , parent string). This fu...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: Distinct filename or distinct items in SQL Server Let see some interesting facts like identifying the unique file types available in the database. Considering, I have stored lot of file ...
Jump to: First Post
Latest post:
Jun 27 2009
1 Post
First post: venkatesanj wrote: Question: I have a table with 1 columns, and I would like to change the predefined value 'NULL' to other value, that can be the same for all rows in the table. How can we achieve this. So...
Jump to: First Post

Configure View

Sorted by Latest post
Search
Filter
(by tag)
All tags
1-10 of 25 < Previous 1 2 3 Next >
Show 10 25 All discussions
Updating...
Page view tracker