|
|
-
Robert Dennyson Commented 1 Years ago through Ask
Hi Somu,
Its easy,
For ex:
CREATE TABLE ScoreCard(ItemID int,StudentName VARCHAR(25), Subject VARCHAR(20), Mark INT)
GO
-- Inserting Data into Table
INSERT INTO Product(StudentName , Subject , Mark )
...
|
-
Robert Dennyson Commented 1 Years ago through Ask
**SQL Server have included a variety of built-in ways to audit activity inside SQL Server. These included:**
***Login Auditing:*** Only tracks user login successes and/or failures. Results are sent to the OS Application Log.
***SQL Server Profil...
|
-
Robert Dennyson Liked 1 Years ago through Just Learned
Show table header in each page follow this steps..
1) in the grouping pane, click on the small triangle (Near "Column Groups") and select "Advanced Mode" to show static members.
2) Now select "static" and set **RepeatOnNewPage** to true for repea...
|
-
Show table header in each page follow this steps..
1) in the grouping pane, click on the small triangle (Near "Column Groups") and select "Advanced Mode" to show static members.
2) Now select "static" and set **RepeatOnNewPage** to true for repea...
|
-
Robert Dennyson Liked 1 Years ago through Just Learned
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to h...
|
-
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to h...
|
-
Robert Dennyson Liked 1 Years ago through Just Learned
Show table header in each page follow this steps..
1) in the grouping pane, click on the small triangle (Near "Column Groups") and select "Advanced Mode" to show static members.
2) Now select "static" and set **RepeatOnNewPage** to true for repea...
|
-
Show table header in each page follow this steps..
1) in the grouping pane, click on the small triangle (Near "Column Groups") and select "Advanced Mode" to show static members.
2) Now select "static" and set **RepeatOnNewPage** to true for repea...
|
-
Robert Dennyson Liked 1 Years ago through Just Learned
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to h...
|
-
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to h...
|